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

· Sorted by Oldest

Andreas Wernicke
·
·
https://app.clay.com/workspaces/9621/tables/t_cAcvgycuUtvf/views/gv_ZvpF6b6x7ewJ
Andreas Wernicke
·
·
Loading attachments
Andreas Wernicke
·
·
https://clayrunhq.slack.com/archives/C02F37UK3CH/p1724947439855059 I think this may be a problem with the task AND the formula generator performance?
Muhammad
·
·
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 Wernicke
·
·
This is awesome Bruno (Clay)! It clicked now for me will be able to use this much better in the future. Super helpful

Andreas Wernicke
·
·
https://app.clay.com/workspaces/9621/tables/t_cAcvgycuUtvf/views/gv_ZvpF6b6x7ewJ
Andreas Wernicke
·
·
Loading attachments
Andreas Wernicke
·
·
https://clayrunhq.slack.com/archives/C02F37UK3CH/p1724947439855059 I think this may be a problem with the task AND the formula generator performance?
Muhammad
·
·
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 Wernicke
·
·
This is awesome Bruno (Clay)! It clicked now for me will be able to use this much better in the future. Super helpful