List:General Discussion« Previous MessageNext Message »
From:Mike Koponick Date:June 25 2004 12:51am
Subject:OUTFILE to CVS with headers
View as plain text  
Hello,

I'm working on a project where I must export to a text file and the text
file needs to be formed into columns so that it can be imported into a
WORD mail merge document.

So, the format of the output file has to have the headers for each
column and the lines must have a CR at the end of each line in order to
keep the columns formatted.

Here is what I'm doing now:

select created, status,user, comment1,  comment7, comment8, trouble from
tbl WHERE customer = 'customer' AND created BETWEEN '2004-05-31' AND
'2004-06-25' ORDER BY created, status into outfile 'test5.txt' fields
terminated by ',' optionally enclosed by '"' escaped by '\\';

All the lines run together so it makes it impossible to import.

Thanks in advance for your help.

Mike

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they are
addressed. Please report errors to security@stripped. 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~


Thread
OUTFILE to CVS with headersMike Koponick25 Jun
RE: OUTFILE to CVS with headersBob Bessares25 Jun
RE: OUTFILE to CVS with headersMike Koponick25 Jun