Page 1 of 1

TI load txt file - retrieve incomplete records

Posted: Wed Jun 19, 2019 12:39 pm
by danz
Hi all

I have a txt file generated from SAP (Encording UTF-8-BOM), open in Notepad++ shows there are 2.4m lines (3 columns, Tab delimited).

Try to read it with TI and to count number of records, I get 1.4m+.

Where is the other 1m records????

Anyone come across similar issue before????

Appreciate if you could share your view.

PA 2.0.6

Re: TI load txt file - retrieve incomplete records

Posted: Wed Jun 19, 2019 2:24 pm
by Wim Gielis
How do you count in TI ?
Please show us the code.
Also know that completely empty lines will not enter the metadata and data tabs.

Re: TI load txt file - retrieve incomplete records

Posted: Thu Jun 20, 2019 10:56 am
by danz
Wim thanks for your reply.

I have resolved the problem during the day, it was a Char Quote causing some data been misread.