Reliable Methods to Count Word Occurrences in Scraped Text

·

What’s a reliable way to count occurrences of a word? Let’s say I want to count “selling” in the scraped body text. This seems to break the formula editor. It either crashes the table (only happened once) or doesn’t go anywhere. Or is there a formula editor performance issue?

5 comments

Andreas W.
·
·
https://app.clay.com/workspaces/9621/tables/t_cAcvgycuUtvf/views/gv_ZvpF6b6x7ewJ
Andreas W.
·
·
Andreas W.
·
·
https://clayrunhq.slack.com/archives/C02F37UK3CH/p1724947439855059 I think this may be a problem with the task AND the formula generator performance?
Muhammad S.
·
·
hey, you can use this formula
{{paragraphText}}?.match(/\b(sell)\b/gi)?.length || 0
It is counting occurence of word sellin the column paragraphText
🙌1
Andreas W.
·
·
This is awesome Bruno R.! It clicked now for me will be able to use this much better in the future. Super helpful