dbTalk Databases Forums  

tab delimited without quotes

comp.databases.xbase.fox comp.databases.xbase.fox


Discuss tab delimited without quotes in the comp.databases.xbase.fox forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Monica J. Braverman
 
Posts: n/a

Default tab delimited without quotes - 07-14-2004 , 07:17 PM






Is there any way to write a tab delimited file (using copy XXXX type
....) without getting quotes to delimit each field??

Thanks.

Molly

Reply With Quote
  #2  
Old   
Stefan Wuebbe
 
Posts: n/a

Default Re: tab delimited without quotes - 07-15-2004 , 01:30 AM







"Monica J. Braverman" <monica (AT) datashark (DOT) net> schrieb
Quote:
Is there any way to write a tab delimited file (using copy XXXX type
...) without getting quotes to delimit each field??
Hi,

Would this do what you want?

CREATE CURSOR temp (c1 C(10), n2 N(2), d3 D)
INSERT INTO temp VALUES ("a", 5, DATE())

*!* COPY TO test55.txt DELIMITED
*!* COPY TO test55.txt DELIMITED WITH BLANK
COPY TO test55.txt DELIMITED WITH "" WITH CHARACTER tab

MODIFY FILE test55.txt
* ERASE test55.txt



hth
-Stefan


Reply With Quote
  #3  
Old   
Monica J. Braverman
 
Posts: n/a

Default Re: tab delimited without quotes - 07-15-2004 , 02:58 PM



That does it! Thanks much.

MJ

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.