Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Begginer question: Split several delimiters

Hello, I'm a begginer with Power BI and Power Query and I'm currently lost. I currently have 10000 lines like this: F550876]27.10.2021]Emp3]West C546767[29.10.2021^Emp3[North D642576[02.11.2021\E...
Need Help
  • tackytechtom's avatar
    tackytechtom
    4 years ago

    Hi Anonymous ,

     

    You can add this code in the Advanced Editor:

    #"Split Column by Delimiter" = Table.SplitColumn(Source, "Column1", Splitter.SplitTextByAnyDelimiter({"[","]","\", "_", "^"}, QuoteStyle.None), {"Column1.1", "Column1.2", "Column1.3", "Column1.4"})   

     

    You can specify all potential Delimeters in the SplitTextByAnyDelimiter() function.

     

     

     

     

    /Tom

    https://www.tackytech.blog

    https://www.instagram.com/tackytechtom

     

     

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thank you for your answer Tom!

    The small problem I have is that sometimes the data can be like this:

    L49106_28.10.2021]Emp10^West
    P539648]29.10.2021\Emp6[East

    So the delimiter by position don't really work sadly. Sorry I should have show it before.