If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Sybase > BCP out utility

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 02-19-03, 06:05
yeshwant yeshwant is offline
Registered User
 
Join Date: Feb 2003
Posts: 3
BCP out utility

I am performing the BCPOut utility and writing contents in Sybase table into a csv file..but here in one of the fields in Sybase Table there are new line characters so it appears as new line in csv file which I want to avoid and make it appear in the same row...

Let me know if u have any idea abt this
Reply With Quote
  #2 (permalink)  
Old 02-19-03, 07:52
osy45 osy45 is offline
Registered User
 
Join Date: Nov 2002
Posts: 833
you should configure the bcp tool with a fmt - file and chose as delimiter a value that is not part of the unloaded data. I prefer somthing like ~@@

osy45
Reply With Quote
  #3 (permalink)  
Old 03-12-03, 03:40
db_mate db_mate is offline
Registered User
 
Join Date: Mar 2003
Posts: 15
Re: BCP out utility

Quote:
Originally posted by yeshwant
I am performing the BCPOut utility and writing contents in Sybase table into a csv file..but here in one of the fields in Sybase Table there are new line characters so it appears as new line in csv file which I want to avoid and make it appear in the same row...

Let me know if u have any idea abt this
Hello,

you can use

-t"|" or you can also use "," if you want csv

use

-r"^" so new line will not be taken as new record

well it all also depends on where or how you want to import or use the data
and what special caracters your data contains
__________________
db_mate
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

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

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On