How split string with numbers and text into 3 columns

[deepnandi]

Hi All,

I am new to Alteryx and I need help in segregating string into 3 different columns. 

[{Name= Final Budget, Id=87FB, Amount=400.02}, {Name=Initial Quote, Id=EB8F2F8D-66C0, Amount=890.73}, {Name= Working Budget, Id=CF6000,Amount=50.00

I need to segregate the above into 3 columns  Name, id, Amount

Name	id	Amount
Final Budget	87FB	400.02
Initial Quote	EB8F2F8D-66C0	890.73
Working Budget	CF6000	50

I tried the Regex tool but was not able to split it into columns. Help will much appreciated.

[seinchyiwoo]

Hi,

You would need to split them to rows first, then only split them into 3 columns.

Attached please find the workflow.

Cheers,

Seinchyi

[grazitti_sapna · Accepted solution]

Hi @deepnandi,

Here is my take on this problem.

I hope it resolves your issue.

[grazitti_sapna]

Hi @deepnandi , an alternate solution to your problem.

Thanks.

[Danish409]

Hi @deepnandi 

Alternatively you can also do it with the help of Text to Column & Transform tool.

Please Find the attached Workflow.

[deepnandi]

Thanks it worked like a charm. Thanks for the help again