Need to find specific letter and then count length

[mmustkee]

Hi team,

We need to find specific letter from my table i.e. "?" and then length +1

For example we have ? coming as 13 times so length should be 14 as we need to add 1 to total length of ?

Name	Find	Result
6C?CP?EM?MD?HY?HI?EH?6C?CP?EM?MD?HY?HI?EH	?	14

[JosephSerpis · Accepted solution]

Hi @mmustkee one way to tackle this is to use regex count for charcters that are used in regex expressions such as ? you need to include a \ to state you are searching for that string.

[Christina_H · Accepted solution]

Try this in a formula tool:

Length([Name])-Length(Replace([Name],[Find],""))+1

[mmustkee · Accepted solution]

Hi @Christina_H 

This solve the purpose but the data I have is as below and attached. I am unable to apply the same in my data. Please apply this from attached file.

6CBWMURDEHHYEMRT

6CBWRDEM

6CBWRT

6CBWRTBWRT

6CCP

6CCPEHEMHI

6CCPEMMDHYHIEH

6CCPEMMDHYHIEH6CCPEMMDHYHIEH

6CCPHI

6CCQRT

6CCQRTEH

6CCW

[mmustkee]

Hi @JosephSerpis 

This solve the purpose but the data I have is as below and attached. I am unable to apply the same in my data. Please apply this from attached file.

6CBWMURDEHHYEMRT

6CBWRDEM

6CBWRT

6CBWRTBWRT

6CCP

6CCPEHEMHI

6CCPEMMDHYHIEH

6CCPEMMDHYHIEH6CCPEMMDHYHIEH

6CCPHI

6CCQRT

6CCQRTEH

6CCW

[JosephSerpis]

Hi @mmustkee you need to adjust the formula to match the character you want to find. Using the excel you supplied the character becomes _

[Christina_H · Accepted solution]

Hi @mmustkee, 

Same answer as @JosephSerpis, you just need to update the formula to match your data:

Length([F1])-Length(Replace([F1],"_",""))+1