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]

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