Forum Discussion
snowrider1799
Helper I
Helper ISearch for repeated alphabet in a string (column)
Hello, I would like to know if there's any method to count the repeat alphabet in a string. For example, I want to get "a" from a column, repeat for how many times. Is there a way to do it? ...
others way cooldbe be to add a column with one of the following rules:
- List.Count(Text.SplitAny([Name],"aA"))-1)
- Text.Length([Name])-Text.Length(Text.Replace(Text.Lower([Name]),"a","")))