Count the number of occurances of a Character BODS (AKA DI)

dataservices administration
1

I am attempting to count the number of occurrences of a character in a file using functions in a Query Transformation.
The entire line is treated as a single field.

Field
Joe^Schmoe
J^oe^S^chmoe

I want to count the number of occurances of the ‘^’ character in each row.

So for the above example I would want to see the results as:

Joe^Schmoe = 1
J^oe^S^chmoe = 3

Pretty simple use case it seems - but I cannot figure this out. Can someone help me Please?

Ken

klynch0323 (BOB member since 2018-08-20)

2

NVM - found the answer in the blog here.

Used it as follows:

=Length([string]) - Length(Replace([string];"-";""))

*Need to be sure to replace the string with a blank for the correct count of characters replaced by that formula.

klynch0323 (BOB member since 2018-08-20)