Is there anyone that can tell how to split table 1(left) and table 2(right) as attached? I am still trying to understand how to use the correct expression using the regex tool. Any help is really appreciated.
Thank you in advance.
I included with the sample data for your reference
Solved! Go to Solution.
Hi @Ladarthure
Thank you for the help and your solution is brilliant. it's makes me want to explore regex tool more.