Splitting data into Columns

Question

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 🙂

atcodedog05 · Answer

Hi @Tid14

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

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

Workflow:

Hope this helps : )

split columns.yxmd

mst3k · Answer

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

Regex Parse.yxmd