Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2009
    Posts
    8

    Question Unanswered: .csv file used for bcping has a comma for a value which is in double quotes -- prob

    Hi

    I have a .csv file which contains some values with comma and those values are in double quotes.
    When i bcp , that single value is becoming 2 values and is placed in the wrong field in the table.

    How to avoid it .Pls help .
    Table has 3 columns
    .csv file (ie., input file) looks like this
    example :-
    wheat,"grown in , NY",Albany

    Here these 3 values r going into the table's 3 columns as
    first column takes :- wheat
    second column takes :- grown in
    third column takes :- NY

    And Albany is not stored at all in the table .

    How can i get 3 values in 3 columns ..

    Any help is appreciated ..
    Thank You .

  2. #2
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    create a format file
    use ," as first delimiter
    and ", as 2nd delimiter

  3. #3
    Join Date
    Oct 2009
    Posts
    8
    Hi


    Pls explain me with one record as an example.

    I didnot understand . Sorry for the trouble.

    Thank You once again.

  4. #4
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1

Posting Permissions

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