Results 1 to 3 of 3

Thread: BCP out utility

  1. #1
    Join Date
    Feb 2003
    Posts
    3

    Unanswered: 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

  2. #2
    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

  3. #3
    Join Date
    Mar 2003
    Posts
    15

    Re: BCP out utility

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •