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