need help in xml parsing a field with carriage returns

Question

Hi, I have a xml file and one of the field is in below format with carriage returns {1:F21IBNJUS33AXXX3294012033}{4:{177:1808010833}{451:0}}{1:F01IBNJUS33AXXX3294012033}{2:I996BCOMPTPLXXXXN}{4: :20:ANSWER3288012013 :21:ANSWER0768228235 :76:URGENT . :11S:950 180726 0768228235 :20:ANSWER0768228235 :21:ST/0020/20180725 :76:PLEASE PROVIDE MORE DETAILS FOR CREDIT EUR 295.00 REF.5878118723777906 :11R:950 180726 0768228235 :20:ST/0020/20180725 :25:PT50003300004540157517305 :28C:145/1 :60F:D180724EUR314631,19 :61:1807250725D0,2NCOM20180724//S076684928800001 IBNJUS33XXX :61:1807250725D0,7NCOM5878118723777906//S076785500000001 45401575173 :61:1807250725D5,NCOM20180724//S076684928800001 IBNJUS33XXX :61:1807250725D17,5NCOM5878118723777906//S076785500000001 45401575173 :61:1807250725C295,NTRF5878118723777906//S076785500000001 45401575173 :61:1807250725C2000,NTRF03MT180724190473//S076785191200001 2076108073 :61:1807250725D60000,NTRF20180724//S076684928800001 IBNJUS33XXX :61:1807250725C88516,NTRFA075318724G100TY//S076785509600001 1010065602 :62M:D180725EUR283843,59 -}{5:{CHK:630C7C6F5AC7}} --------------------------------------------------------------------------------------------------------------------------- When I am using the xml parser the whole lines are not being parsed in one cell only partial data is getting in. How can I solve this? {1:F21IBNJUS33AXXX3294012033}{4:{177:1808010833}{451:0}}{1:F01IBNJUS33AXXX3294012033}{2:I996BCOMPTPLXXXXN}{4: :20:ANSWER3288012013 :21:ANSWER0768228235 :76:URGENT . STILL WAITING FOR YOUR REPLY . REGARDS LUIS CHIPELO-WPC :11S:950 180726 0768228235 :20:A...

Ben_H · Answer

Is that from the results window or a browse tool?

The results window will truncate values, but the actual data is there if you stick a browse on the end of the workflow.

Regards,

Ben

davidskaife · Answer

Hi @dexter90

Ahhh ok, i think i see what you're meaning. The data is there Alteryx just truncates it for performance purposes if it's greater than 256 characters.

If you output it to a CSV file it should contain all the data you're expecting. If it is still truncating then you can try adjusting the size of the field using a Select Tool.

dexter90 · Answer

I tried that but it is not giving the complete output for the field, I see it is only giving partial output after using Data cleansing tool.

{1:F21IBNJUS33AXXX3294012033}{4:{177:1808010833}{451:0}}{1:F01IBNJUS33AXXX3294012033}{2:I996BCOMPTPLXXXXN}{4: :20:ANSWER3288012013 :21:ANSWER0768228235 :76:URGENT . STILL WAITING FOR YOUR REPLY . REGARDS LUIS CHIPELO-WPC :11S:950 180726 0768228235 :20:A...