group by bunch of letters?

[ioannagr]

Hello,

I have a bunch or sentences and in all them I can find the word "photo", "photographer", "photogenic". I want to count in every sentence that contains one of these words, say, look for "phot".

Can this be done?

Thanks!

Ioanna

[tresesco]

Try SubStringCount()

[ioannagr]

But, these sentences are under the field "reasons".  I mean, they're not just separate sentences. 

What should i do?

[tresesco]

Could you share a sample data and expected output against that? Also mention where/how would you want the output, i.e. - in a chart or kpi object.

[ioannagr]

In a KPI.

Well, I can't share, but it's something  like that

id reason

1 photo is not very  nice

2 photo is not nice

3 not photogenic

4 is late

I want for example to count  all the reasons that have to do with the photo, search for "phot" in each sentence, then count the sentence in because there's "phot" in it.

[tresesco · Accepted solution]

Like this?

=Count({<reason={"*phot*"}>}id)

[ioannagr]

Thanks you rock 😄