Hi
I would like to ask for your assistance in extracting the following separating them into 3 columns.
Sample
Output or Results
Thanks
Kamen
Solved! Go to Solution.
Hi @KamenRider
In this case, Text to Column tool is the best.
In addition to Text to Column, data cleansing is needed to satisfy with your demand. In attached workflow, I utilize REGEX function to parse numeric data.
An alternative to @gawa 's solution would be the REGEX function:
(\d+\.\d+)\s+([A-Z]+); (\d+) [A-Z]+; (\d+)
Hi @KamenRider if both ideas helped, you can mark both as accepted solutions. Helps others who may have the same issue.