>Hi
>
>I need to unload data from a table and it must be pipe delimited, but not with double qoutes around the character variables. I got it right to get a pipe delimited file, but do not now how to get rid of the double qoutes (" ") around the character values.
>
>Code:
>
>COPY TO c:\tmp\wtbsold.txt ;
>NOOPTIMIZE ;
>TYPE DELIMITED WITH CHARACTER "|"
>
>My end result must look like this :
>
>P|XX11|0234|WP and not "P"|"XX11"|"0234"|"WP".
>
>If there is another command that I should use, please let me know.
>
>Thank you
>
>Irene Grassow

Irene,
If added extra spaces are no problem then :

COPY TO c:\tmp\wtbsold.txt ;
TYPE DELIMITED with ' ' WITH CHARACTER "|"

If they're a problem you can remove them :

COPY TO c:\tmp\wtbsold.txt ;
TYPE DELIMITED WITH CHARACTER "|"
StrToFile(chrtran(FileToStr('c:\tmp\wtbsold.txt'),'"',''),'c:\tmp\wtbsold.txt')

Cetin