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,
Solved! Go to Solution.
Hi @Inquisitive1,
here is a way to do it. you would need to use RegexReplace formulas to do so! (find the solution attached!)
Brilliant! Thank you very much.