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 adva...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi babuInba 

     

    For your simple sample, you can do 

     

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

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi babuInba 

 

For your simple sample, you can do 

 

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