Home

Get & Transform

Star12019
New Contributor

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 a column can be split be selecting 3 different delimiters at the same time ……...

I am familiar with Text to Columns however I can't work out how to do this in the Get and Transform area ….thankyou in advance for all your advice 

J T 

1 Reply

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"}

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies