Solved: Substring count in single cell

babuInba · ‎07-08-2021

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.

Anonymous · ‎07-08-2021

For your simple sample, you can do

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

Anonymous · ‎07-08-2021

For your simple sample, you can do

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

Substring count in single cell