Search the web
Sign In
New User? Sign Up
aqt · Advanced Query Tool Discussion Group
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Show off your group to the world. Share a photo of your group with us.

Best of Y! Groups

   Check them out and nominate your group.
Having problems with message search? Fill out this form to ensure your group is one of the first to be migrated to the new message search system.

Messages

  Messages Help
Advanced
batch export delimit columnname with "   Message List  
Reply | Forward Message #4110 of 4217 |
Re: batch export delimit columnname with "

Hi Phil,

thanks - it works!
'it seems to work better if you have a blank after the colheader=" and before
the column list.' => this is the solution.
i have tryed to do it with colheader=""xxx","yyy"" but in this case
it does not work.

Michael

--- In aqt@yahoogroups.com, "Phil Castle" <group@...> wrote:
>
> So... you want the column names to have double-quotes around them?
>
> I don't think there is any way of doing this easily. In the Export Options
window, you can click on the Customize button beside the "Include header line"
option, and add the double-quotes to the column names. This will obviously be a
bit tedious if your table has a lot of columns.
>
> Alternatively, you can go View > Export Options to see the export script. Copy
the script to the SQL window, then add the double-quotes to the column names.
What you have in the SQL window will look something like:
>
> --aqt
export,file=customer_details.csv,type=csv,filemode=replace,nulls=NULL,prompt=yes\
,header=yes,colheader="
"cust_code","first_name","last_name","date_of_birth","customer_type","date_joine\
d" "
> Select * from Customer_Details
>
> Note: it seems to work better if you have a blank after the colheader=" and
before the column list.
>
> Phil.
>
>
> --- In aqt@yahoogroups.com, "dbfan111" <m.kopf@> wrote:
> >
> > Hi Phil,
> >
> > i try to create an batchexport using headercolum. but i want to delimt the
columnname with ' " '!?
> > Is it possible to do so? what i have to define?
> >
> > best regards
> >
> > Michael
> >
>





Wed Jul 8, 2009 5:59 am

dbfan111
Offline Offline
Send Email Send Email

Forward
Message #4110 of 4217 |
Expand Messages Author Sort by Date

Hi Phil, i try to create an batchexport using headercolum. but i want to delimt the columnname with ' " '!? Is it possible to do so? what i have to define? ...
dbfan111
Offline Send Email
Jul 7, 2009
9:26 am

So... you want the column names to have double-quotes around them? I don't think there is any way of doing this easily. In the Export Options window, you can...
Phil Castle
cardettnz
Offline Send Email
Jul 7, 2009
11:27 am

Hi Phil, thanks - it works! 'it seems to work better if you have a blank after the colheader=" and before the column list.' => this is the solution. i have...
dbfan111
Offline Send Email
Jul 8, 2009
5:59 am
Advanced

Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help