Forum Discussion
Get & Transform
Hi Is it possible , in the Get and Transform Option to split a column by 2 or more different delimiters at the same time ? For Example ..selecting "(", Then selecting ")", then selecting "-" ...so...
Hi,
Yes, that's possible. First split by any one delimiter, let say comma. In formula bar second part of the formula will be like
Splitter.SplitTextByDelimiter(",", QuoteStyle.Csv), {"Col.1", "Col.2"}
Change inserting Any in function name and adding list of all your delimiters, like
Splitter.SplitTextByAnyDelimiter({",",";"}, QuoteStyle.Csv), {"Col.1", "Col.2", "Col.3"}