var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: .csv file used for bcping has a comma for a value which is in double quotes -- prob
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
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 .
create a format file
use ," as first delimiter
and ", as 2nd delimiter
Pls explain me with one record as an example.
I didnot understand . Sorry for the trouble.
Thank You once again.