Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to split column with Multiple information

Hi All,   I have a data source as an excel file which has a particular column having multiple information in it. I want to split the column in different columns. However the challenge i am facing ...
Need Help
Show and Tell
Tips and Tricks
  • HotChilli's avatar
    HotChilli
    4 years ago

    If you add custom columns for each sub-field using Text.BetweenDelimiters to find the specific info, for example,  

    Text.BetweenDelimiters([Total with vat], "Free Shipping", ";") that should do it.

HotChilli's avatar
HotChilli
Community Champion
4 years ago

If you add custom columns for each sub-field using Text.BetweenDelimiters to find the specific info, for example,  

Text.BetweenDelimiters([Total with vat], "Free Shipping", ";") that should do it.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thanks for the solution HotChilli appreciate it 🙂