Counting The Occurrences of Specific Text Strings

[Eric_D_Miller]

Hello,

I am running a Note Report for specific text strings and was curious how I would go about counting how many times a certain text string shows in the comment.

Here is an example of a comment

In this case I would like to have a count of how many times each text string appears.

From this photo I would get a count of:

• 'Copy/Change:' 9
• 'Creative Change:' 6
• 'Creative/Copy Change:' 4
• 'URL Change:' 5

Is there formula that will achieve this? Thank you in advance!

[Doug_Den_Hoed__AtAppStore · Accepted solution]

Hi @Eric_D_Miller,

Although our Magic Reports solution could dissect the notes and aggregate the counts of specific text strings, to my knowledge doing so is beyond Workfront's native reporting capabilities.

Regards,

Doug

[skyehansen]

Doug is right -- there's no way to do this. You want to count 4 different text strings, so the only way to do this would be to make 4 reports -- one for each string you want to count. Then, the total lines on each report is how many times that string has shown up.