BigFoz


Hi,

I need to be able to create a standard ASCII file delimited with tabs. However the default for the command:

COPY TO file.txt DELIMITED WITH TAB

produces the character " wrapped around all fields. Does anyone know a way of producing a standard tab delimited file without the " characters

Cheers,

Paul.




Re: Copy to delimited

Naomi Nosonovsky


You may try

Code Snippet

COPY TO test.txt DELIMITED WITH "" WITH CHARACTER TAB






Re: Copy to delimited

dni

You may use in combination, clause:

WITH CHARACTER Delimiter







Re: Copy to delimited

Rick Borup

Try this:

COPY TO file.txt DELIMITED WITH "" WITH CHARACTER tab

-Rick






Re: Copy to delimited

BigFoz

Thanks Rick, that's got it.

I was trying all sorts of delimited with / character combinations but yours has hit the button.

Cheers!

Paul.