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

     

     

     

     

tackytechtom's avatar
tackytechtom
Icon for Most Valuable Professional rankMost Valuable Professional
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

That's working perfectly, thank you!!