I do this: I have a file "CR" which has just a CR (or Cr/LF if you need it) in it.
I have a text file, AddCR.cmd which has one line in it as follows: COPY YourFile.csv+CR Newfile.csv Then in R:Base: LAUNCH AddCR.cmd That should do it! Regards, Stephen Markson The Pharmacy Examining Board of Canada 416.979.2431 x251 From: [email protected] [mailto:[email protected]] On Behalf Of Dick Fey Sent: Monday, March 05, 2012 5:07 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: CSV question Using 9.1 Using Unload Thanks to all for the advise. Dick Fey On 3/5/2012 3:55 PM, Lawrence Lustig wrote: If you're exporting as CSV, the last line should already be terminated with CR LF. If you're using UNLOAD AS CSV and need an extra CRLF you can just: WRITE '' before setting your OUTPUT back to SCREEN. -- Larry ________________________________________ From: Dick Fey <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Monday, March 5, 2012 3:06 PM Subject: [RBASE-L] - CSV question We upload a file monthly to our State sales tax department as a CSV file. They need a carriage return (enter?) at the end of the last line. We have to edit the file and add it manually. Anyone know how to insert it automatically ? Dick Fey Carpet Broker
