Forum Discussion

Jeanxyz's avatar
Jeanxyz
Icon for Power Participant rankPower Participant
2 years ago
Solved

power query: split text by delimter stop working after certain number of words

I want to split text in field Work Desc by 

#split= Table.SplitColumn(#"Trimmed Text", "Work Description", Splitter.SplitTextByAnyDelimiter({" ",";",":",",","/", "#(tab)","@","."}, QuoteStyle.Csv))

 

I notice the split stops after certain words (in image, line 8, split stops after the word "by"). If I filter in line 7 and run the same split code, it seems to work correctly. Is there a bug in M query splitcolumn function?

 

 

Need Help

1 Reply

  • Jeanxyz's avatar
    Jeanxyz
    Icon for Power Participant rankPower Participant
    2 years ago

    problem solved. Here is the video:  #"Split Column by Delimiter" = Table.TransformColumns(#"Trimmed Text", {"Work Description", Splitter.SplitTextByAnyDelimiter({" ",";",":",",","/", "#(tab)","@","."})}),

    help video: https://www.youtube.com/watch?v=bKkXxbOnqxA