Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Get no of text string in Column

Hi,  I have a column that contains some text, and I want to find the no of a text string in it. Eg  
Need Help
Tips and Tricks
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    You can add a custom column in the query editor with

     

    = List.Count(Text.Split([Column], " "))

     

    Pat

     

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

You can add a custom column in the query editor with

 

= List.Count(Text.Split([Column], " "))

 

Pat