Get and Transform Excel 2016 - split a column with different delimiters in variable length text

Copper Contributor

Hi
Is it possible in the Get and Transform function to split columns by more than one delimiter in a variable length text string. For Example
PT1007 WE: 23-02-2017 Name: J Jones ST 25 Units
PT1007 WE: 20-02-2017 Name: Tom E Westward ST 100 Units
hence in the above example split columns,  at the same time , by the following 'different' delimiters
WE:
Name:
ST
Units
Grateful for all your advice
If you are able to assist can you reply with a screen shot please of the formula I need to enter so I can see what is needed
Thankyou

1 Reply

Hi @Star12019 ,

 

You may start to split from one delimiter, in formula bar you'll see as part of formula something like

Splitter.SplitTextByDelimiter("del1", QuoteStyle.Csv), {"Col.1", "Col2.2"})

Here manually change function on SplitTextByAnyDelimeter, expand you delimiters as list as well as columns names and press Enter, it looks like

Splitter.SplitTextByAnyDelimiter({"del1","del2","del3"}, QuoteStyle.Csv), {"Col.1", "Col.2", "Col.3", "Col.4"})