Count number of character occurrence in string

Jmoreno · September 2022

Trying to see if there is a way to achieve this.

I have a column that has something like the left column here

Is there a way to achieve the right side column by looking at maybe the number of commas + 1 maybe?

Doing this in ETL formula tile would be best for me if possible

GrantSmith · September 2022

You can calculate the length of the string, remove the character you want, recalculate the length and take the difference.

LENGTH(`Color`) - LENGTH(REPLACE(`Color`, ',', '')) + 1

GrantSmith · September 2022

You can calculate the length of the string, remove the character you want, recalculate the length and take the difference.

LENGTH(`Color`) - LENGTH(REPLACE(`Color`, ',', '')) + 1

Magic ETL