Search for repeated alphabet in a string (column)

[snowrider1799]

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? Thank you.

Name	Count
Melissa Sandy	2
Albert Adam	3

[Anonymous · Accepted solution]

Hi @snowrider1799 ,

I believe there are several ways to achieve this

One of these :

[Anonymous]

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","")))