Question on CSV file

[Walter D Vaughan Jr]

> -----Original Message-----
> From: filepro-list-bounces+wvaughan=steelerubber.com at lists.celestial.com
> [mailto:filepro-list-
> bounces+wvaughan=steelerubber.com at lists.celestial.com] On Behalf Of
> Boaz Bezborodko
> Sent: Thursday, May 23, 2013 11:49 AM
> To: Filepro-List at Lists. Celestial. Com
> Subject: Question on CSV file
> 
> I have a customer that is sending us CSV files that are somewhat non-
> standard.  Each line ends with just a CR and no LF except the last one
which
> does not have either.  When I tell Filepro to IMPORT using CR as the
record
> delimiter it drops off the last record.
[Walter D Vaughan Jr] 

Then why not have your import code make two passes.
First pass jump to the last character of the import file. If it's an
ASC("13"), then just import, if it's not, append one, then close the file
and make a second pass using your normal import routine. That way if all of
a sudden then start sending the file correctly you don't care, or more
important if all of a sudden it changes back and forth depending upon who's
on vacation that week, you really don't care.
> 
> If I open the file with OpenOffice and then save it this corrects the
problem,
> but involves a separate step.
> 
> Unfortunately the customer is all that computer savvy and doesn't
> understand any of this nor how to solve it.  What could be creating the
file
> this way and is there an easy way to solve the problem. (I'm using Windows
> FPro.)
> 
> Thanks.
> 
> --
> Mirrotek International, LLC
> 90 Dayton Avenue
> Building 1-F
> Passaic, NJ  07055
> 
> Tel:  973-472-1400 x.112
> Fax:  973-472-5170
> 
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list