Regex parsing

[Inquisitive1]

Hi All, and i hope you have a great Friday. 

I would like a help with regex syntax (i am fairly new to this and it's now hurting my head). 

I have the following data set: 

"Mo, Tu, We 10:00-18:00 Th 10:00-20:00 Fr 10:00-18:00 Sa 09:00-17:30 Su 11:00-17:00",
"Mo, Tu, We, Th, Fr 10:00-18:00 Sa 09:00-17:30 Su 11:00-17:00",

etc in any combinations of days/hours

Desired outcome:

Mo	Tu	We	Th	Fr	Sa	Su
10:00-18:00	10:00-18:00	10:00-18:00	10:00-18:00	10:00-20:00	09:00-17:30	11:00-17:00
10:00-18:00	10:00-18:00	10:00-18:00	10:00-20:00	10:00-18:00	09:00-17:30	11:00-17:00

Which is the best method ? Tokenise? Parse?

How would you quickly tackle the "Different lengths"?

Could someone help me please?

Thanks, 

[Ladarthure · Accepted solution]

Hi @Inquisitive1,

here is a way to do it. you would need to use RegexReplace formulas to do so! (find the solution attached!)

[Inquisitive1 · Accepted solution]

Brilliant! Thank you very much.