#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2013
    Posts
    2
    Rep Power
    0

    Field separator argument is not what is expected


    I am trying to load data using the following sql, but always getting error as "field separator argument is not what is expected". Can anyone help to tell what is wrong with my sql?
    Thank you in advance.

    load data local infile 'C:/RxNorm_full_04012013/rrf/RXNATOMARCHIVE.RRF' into table RXNATOMARCHIVE
    FIELDS TERMINATED BY '|' ESCAPED BY ''
    lines terminated by '\n
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2007
    Location
    Purley, Surrey
    Posts
    248
    Rep Power
    37
    Pobably the ESCAPED BY ''
    what is that supposed to do? Can you try it without it?
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2013
    Posts
    2
    Rep Power
    0
    Originally Posted by TonyF123
    Pobably the ESCAPED BY ''
    what is that supposed to do? Can you try it without it?
    Thank you much for your reply. I tried without the character, and it works now!

IMN logo majestic logo threadwatch logo seochat tools logo