Split Column by Delimiter ONLY if more then one exists

[misiek5510]

Hi,

I wanted to split the column if dash "-" exist more than once for each row and split it without spliting the first dash. Hopefully the below will make more sense:

Example column to be split:

Sample

Sample - Sample1 

Sample - Sample1 - Sample2 - Sample3 

Sample - Sample1

Sample - Sample1

Sample - Sample1 - Sample2

Column that needs to be created:

Sample

Sample - Sample1

Sample - Sample1

Sample - Sample1

Sample - Sample1

Sample - Sample1

[Thennarasu_R]

Hi !
@misiek5510 

You Created Calculated Column Using Len and Left Functions
Here Attached the Ex Pic.I hope it Will help to You.

Thanks,
Thennarasu

[amitchandak · Accepted solution]

@misiek5510 , First Use Split By Delimiter, and split on only 1st occurrence (Into two columns),

Then again split By Delimiter the second into rows

https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/