I am having an issue with importing a CSV file. The problem arises when an address field has multiple comma seperated values e.g. home no, street no, town etc.
I have googled but the problem did not solved because of a single field containing multiple comma separated values.
Any idea or solution? because I didnt found any help
my file have these column
ID |Instrument |Units |EntryDate |Comments
2C | pen,screw |1 |1/1/2010 |rer
my problem is that the value of Instrument column it reads this two column (pen and screw) not(pen,screw) .the take screw as next(Unit) column value.....