[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

[osy45]

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

[db_mate]

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