Splitting data into Columns

[Tid14]

Hi

I have converted pdf into Excel then taken extract into alteryx but the data is not coming as required

As the fund and numeric values have merged into similar column.

What i want is to have 3 different Columns 

Namely

Income fund 

62%

0%2

and same goes for the second row.

Thanks in advance 🙂

[mst3k]

A simple Regex tool can do this in Parse mode, using the regular expression: (.+?)\s*(\d*%\d*)\s*(\d*%\d*)

[atcodedog05]

Hi @Tid14 

Here is how you can do it using regex tool parse mode.

Regex: (.+)\s(\d.+)\s(\d.+)

Workflow:

Hope this helps : )