Forum Discussion
Get and Transform Excel 2016 - split a column with different delimiters in variable length text
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...
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"})