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

 

  • You can add a custom column in the query editor with

     

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

     

    Pat

     

1 Reply

  • mahoneypat's avatar
    mahoneypat
    Microsoft Employee

    You can add a custom column in the query editor with

     

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

     

    Pat