Mar 24 2019 09:01 AM
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
Mar 24 2019 10:44 AM
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"})