Split rows base on value

[kflow]

Hi Team ,

I'm looking for a tools to split my data set accordingly.  The original data like below
Example :

Input : A001 Day 4 and B001 Day 1,3,6

Output:

A001, Day 4
B001 , Day 1
B001 ,Day  3
B001, Day  6

[paulfound]

You could use regex something like:

(\w\d+\s)Day\s(\d+)\sand\s(\w\d+\s)Day\s(\d+),(\d+),(\d+)

parse it to several columns

[OllieClarke]

Hi @kflow I also used RegEx, but broke it into a couple of steps:

[danilang]

hi @kflow 

Does your data really come in the form "A001 Day 4 and B001 Day 1,3,6"?  What if you get a record for C001? Does it add an "and".

Could it actually come in on separate rows like 

A001 Day 4 

B001 Day 1,3,6 

Dan

[kflow]

hi@danilang,

The original data is like below:

A001 Day 4 

B001 Day 1,3,6 

[Julien_B]

You can do it this way : 
From this :

to that : 

[benakesh · Accepted solution]

Hi @kflow ,

Try text to columns ( space delimiter) followed by  another text to columns ( , delimiter and split to rows ) .

[danilang]

Hi @kflow 

Thanks for the clarification.  This workflow uses a regex formula to split the input columns into Type and Day and then a text to columns to split the day numbers into rows

After that, it's a question of how you want the output.  The top output is the most useful for further processing since [Day number] is a single numeric value that you can convert to a day name or a date.  The second output includes the "Day" label in the [Day] field.  the third output is similar to the output you included in the original post

Dan

[kflow]

Thanks for your help, i'm able to do what i want with the simple flow.