I have a client who wants me to parse some data and then export the file in the same format that I got it so that it can be read into another batch process.

The file contains two things - a header and then the main data records.

What I am currently doing is reading the data in to two dbfs - one containing the header information and the second, the main table, all of the data rows for parsing. (The reason for reading the header into a dbf file is that I will need to update the information once I have parsed the data)

I have a problem

The data I receive has pipe character delimiters, with no quote wrappers. How do I do a Copy To command and not have the fields wrapped in quote characters? BTW I can't use a space as a delimter either since this would also change the column size because it embeds a space before and after the pipe.


Thanks for your help

John

(I'd appreciate a direct email on this one if possible please)