[12] 903.199,95 [13] 04,00 [14] 36.127,88
How can I parse the above mentioned line to following result -
Hi @Vighnesh_Kamath_7 ,
There are many ways of doing this in Alteryx. You can parse it all using Regex, you can do it in a formula tool, but I've broken it down step by step to make it easier to explain the process:
First, I used the Test to Columns tool to split this to rows on the opening square bracket remembering to check the "Skip Empty Columns" box, as this will remove those cells where the contents are only the removed delimiter:
This gives you the following:
I then used the same Text to Columns tool to split into two columns on the closing square bracket:
Which leaves us with:
I then used Regex (you can use a formula) as follows:
This simply removes any character not in the defined set, which would be any special character.
I then dropped the original column and renamed accordingly:
Workflow attached.
I hope this helps,
M.
Here's an alternative way of getting to the answer,
I just realized you'll also need a data cleanse or to trim the characters.