Parsing FIX messages within Alteryx

[gelvira]

Hello, 

I have a working python logic in Alteryx to process FIX messages. My issue is when I process > 50000 records and pass it through python. It takes a lot of time. I am trying to build it in Alteryx :

I replaced the ASCII characters and tokenizing it. But I am not getting it right. 

Column looking like the following

8=FIX.4.2
9=1757
35=W
34=917409
52=20220517-13:49:45.503
15=USD
37=NA
5613=045254757384
130=7.1200
131=7.1300
132=300
133=4200
260=4
130=7.1200
131=7.1400
132=100
133=600
275=P
273=20220512-13:49:45.157109
1046...130=7.1400
131=7.15
132=1000
133=1500

130	131	132	133	260
7.1200	7.1300	300	4200	4
7.1200	7.1400	100	600	4
7.1400	7.15	1000	1500	4

I appreciate any help.

Thanks!

[BrandonB · Accepted solution]

You can replace ASCII code 01 with a Regex Replace function to convert it to a comma which you could then parse out: Regex_Replace([Field],"\x01",",")