Repair .txt file truncated lines?

[RDF25087]

Hi all -

My source data is a large .txt file. However, I have noticed there are issues with the format of some of the data, with some lines truncated and the remainder of the line dropping to the line below. The break always appears to be at the same point (after the invoice number) but there doesn't appear to be any logic as to which line gets truncated.

Is there a way I can use Alteryx to repair these lines? Any help gratefully received. I include a sample of the affected .txt input files.

Regards

RDF

[cpapaioannou]

Hi,

Yes, just configure the Input Data tool > 7. Field Length. Default is 254 but you need to set it to something larger e.g. 999 so that there are no more conversion errors with "truncated records".

[RDF25087]

Thank you for the response. I have already set the field length to 1000000 and it still isn't pulling in correctly.

[cpapaioannou · Accepted solution]

Oh yes, I didn't read it carefully and assumed it was the classic one. Check out the attached WF and let me know. Of course according to your full data you may need to make minor adjustments.

[RDF25087]

Thanks for the response. Brill, that seemed to do the trick. What difference does it make changing the Code Page to ANSI - Latin I make?

RDF

[cpapaioannou]

Well, I believe none... I was just testing during input :)