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)) ...
Need Help
  • Jeanxyz's avatar
    Jeanxyz
    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

     

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