General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
I need some help with file exporting please
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)
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only