Count number of character occurrence in string

Jmoreno

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

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

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