import on bad data file
Brian K. White
brian at aljex.com
Thu Jul 24 13:46:00 PDT 2008
----- Original Message -----
From: "Scott Nelson" <scott at logicdatasystems.com>
To: "filePro Mailing List" <filepro-list at lists.celestial.com>
Sent: Thursday, July 24, 2008 1:54 PM
Subject: import on bad data file
>I have found a problem with an import on a file downloaded from fedex.
> Seems their system does not put an end of record marker on the last
> record in the file. I am using import ascii filename r=\n f=\n since I
> want the entire record as one field for my own parsing. The import is
> not getting the last record since the marker is missing.
>
> Anyone have this happen, or do fedex invoice downloads, or have an idea
> on how to make import get the last record?
>
> Thanks,
>
> Scott
Just blindly append a record delimiter yourself every time and allow for the
fact that you may or may not get what looks like an empty record at the end
of the import loop sometimes.
rreport ... -r fedex-file.txt
@once:
then: h = open(@pm,"w") ;x = seek(h,"0","2") ;x = write(h,chr("10")) ;x =
close(h)
then: end
--
Brian K. White brian at aljex.com http://www.myspace.com/KEYofR
+++++[>+++[>+++++>+++++++<<-]<-]>>+.>.+++++.+++++++.-.[>+<---]>++.
filePro BBx Linux SCO FreeBSD #callahans Satriani Filk!
More information about the Filepro-list
mailing list