Post reply

BCP -line feed row terminator

  • July 24, 2003 at 2:18 pm

    #65616

    Hi all,

    How can i mention the {LF}-i.e Line feed as rowterminator using the bcp -r argument.For ex for newline i mention \n.

    Thanks in advance.

  • July 24, 2003 at 10:56 pm

    #466963

    In the past when neither "\r" nor "\n" has worked for me, a combination of "\r\n" has done the trick.


    Cheers,
    - Mark

  • July 25, 2003 at 6:20 am

    #467018

    In BCP \r indicates single return character (ascii 13 0x0D) and \n indicates two characters CR/LF (ascii 13,10 0x0D0A). There is no provision (in SQL7) for just LF (ascii 10 0x0A) as a row delimiter. If your file is fixed format you can ignore the LF by using a format file otherwise you will need to convert the character.

    Far away is close at hand in the images of elsewhere.
    Anon.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply