|
Hello list.
OK, here's the scoop:
I am taking a text file from EDI, and then saving
it to an array.
I have the proper column lengths for each field.
The record length is 548 lines. So, if the text file has 12 records, the file
length with spaces should be 6576 characters long.
However, the file length is actually 6595
characters long. So, some of the data gets truncated and put in other columns
that overlap, thus I cannot update the database because the information isn't
correct.
I've built my array with the proper column values
and string lengths, and I'm using the <@SUBSTRING> to get the correct
positions.
Any help would be appreciated. I've attached my taf
and the text file if anyone has the time to look at it.
Thanks in advance,
Rick Sanders, President Tel: (201) 521-0396 Fax: (201) 521-0390 Email: [EMAIL PROTECTED] Web: www.webenergy-sw.com |
data.taf
Description: Binary data
941766.FRM
Description: Binary data
________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
with unsubscribe witango-talk in the message body
