Forum Discussion

babuInba's avatar
babuInba
Frequent Visitor
5 years ago
Solved

Substring count in single cell

Hi Everyone,

 

i'm looking for solution to count number of specific text in a string. 

Example  i have value as "123e23,2455e2334e" i would like to count number "e" in this string.

Thanks in advance.

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi babuInba 

     

    For your simple sample, you can do 

     

    Text.Length(Text.Select([Column1],"e"))

     

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi babuInba 

     

    For your simple sample, you can do 

     

    Text.Length(Text.Select([Column1],"e"))