Hi,

I am trying to read your CSV file and getting some issue while inserting in the database.

CSV file data-

Seller Name,RapNet Account ID,Name Code,etc... (Column Names)

Goodfine Diamond Int'l Corp.,2099655,GOODF,etc... (Column values)

when I split the above values it is working fine and inserting properly in the databse as below-

Goodfine Diamond Int'l Corp.

2099655

GOODF

But some times when i split these values whenever comma comes in between the Seller name for eg. (Ninacci, Inc.) the value before the comma get inserted in the first coloumn and the value after the comma get inerted in the second column.

which is not proper.

CSV file data-

Seller Name,RapNet Account ID,Name Code,etc... (Column Names)

Ninacci, Inc.,2099655,GOODF,etc... (Column values)

when i split with comma the above values it is not getting inserted in the relevant columns as below-

Ninacci

Inc.

2099655

GOODF

Can you please suggest what could be the solution to this problem.

Thanks,

Shobhit Parasher