Count specific entry

Hi,

I would like to seek your help with my data. I am trying to count the exact entry from a specific column, however, it contains multiple words with characters. I just would liek to count specific entry (in my chase below its letter A)

Entries	Count
A,AB, BC;A B	1	should count (first letter A)
AB, BC; A B	Null
BC#A	1	should count
BC#BC,A	1	should count
BC, B A B#C	Null
BC,A#C	1

Workflow

Regex

Accepted answers

Emmanuel_G

Hi @Jeff88 ,

You can find a test attached with exact desired output.

Let us know if it works the way you want.

Cheers !

Count Red.yxmd

All comments

davidskaife

Hi @Jeff88

If you're simply wanting to count the number of times the letter A appears then the Regex formula REGEX_CountMatches([Field], 'A') will work.

If you have more specific requirements you may need to explain a bit further for your example.

Jeff88

Hi David,

Thank you for the prompt answer, however what i need to do is just to count the specific word, here's an example data again and what should i expect to reflect.

On a form, user can select multiple colors and when I extract my data to excel, it will show the table below and it was separated by special characters like ;

I only would like to count if the user selection includes "Red" not "Light Red" or "Dark Red"

If the field consist of "Light Red" and "Red", it should count as 1

If the field consist of "Light Red" and "Dark Red", it should not count

Item	Result (count)
Red	1
Dark Red; Light Red	Null
Red;Blue;Light Green; Light Red	1
Brown;Red;Dark Blue	1
Light Red, Blue	Null
Red, Dark Red, Light Red	1
Dark Red;Red;Brown	1
Light Red# Red	1

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15881

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703