Question on CSV file

Boaz Bezborodko boaz at mirrotek.com
Thu May 23 08:48:46 PDT 2013


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.

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



More information about the Filepro-list mailing list