Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I would like to count the appearance of a word in a List of Sentences.
List:
Number Phrase
1 Hello World
2 Qapla
3 the force awakens
4 the force may be with you
5 The Storm
Now I want to count for example “force” or “the”.
Force should be (2) and the (3)
I have tried
=SubStringCount(PHRASE,'force')
=count({<PHRASE={'force'}>}Number)
Hi Markus
=substringcount(Concat(Phrase), 'force')
If words can begin with a capital letter, use, for example, function lower()
=substringcount(Lower(Concat(Phrase)), 'the')
Regards,
Andrey
Try with wildcard search, like:
=count({<Phrase={'*force*'}>}Number)
Hi Markus
=substringcount(Concat(Phrase), 'force')
If words can begin with a capital letter, use, for example, function lower()
=substringcount(Lower(Concat(Phrase)), 'the')
Regards,
Andrey