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
> >
>