Counting The Occurrences of Specific Text Strings

Question

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 Answer

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 · Answer

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.

サインアップ

ソーシャルログイン

コミュニティへログイン

ソーシャルログイン

ファイルをウイルススキャンする。

このファイルはダウンロードできません