Extracting 1 Field Name Separating into 3 Columns

[KamenRider]

Hi 

I would like to ask for your assistance in extracting the following separating them into 3 columns.

Sample

 

Output or Results

 

Thanks 

Kamen

 

[gawa · Accepted 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.

[caltang · Accepted solution]

An alternative to @gawa 's solution would be the REGEX function:

(\d+\.\d+)\s+([A-Z]+); (\d+) [A-Z]+; (\d+)

[KamenRider]

Hi @gawa  and @caltang 

Thanks for your help and ideas.

Kamen

[caltang]

Hi @KamenRider if both ideas helped, you can mark both as accepted solutions. Helps others who may have the same issue.