Parse number and string

[umairah]

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

[Ladarthure · Accepted solution]

Hi @umairah,

here is a workflow, just had to replace the , in some numbers.

[umairah]

Hi @Ladarthure 

Thank you for the help and your solution is brilliant. it's makes me want to explore regex tool more.