Comma in Dataport

upasanisandip

Hi all,
While importing data from .csv file, for the address field of Customer Card comma is there, so it is creating problem.
How can this be solved?

thanks,
sandip.

ssingla

Change the field seprator in the dataport to something other than " , ".

Alisha

If you save the csv from Excel, and it does contain a comma, the contents of that field are saved between "", so it wouldn't cause a problem to import it using a dataport with field separator = ','.

I'm doing that and it works fine.

kolaboy

The safest is to change the FieldStartDelimiter and FieldEndDelimiter to none and then import. Its going to complain of commas if you don't take care of the commas. Make sure there is no comma in you data.

Alisha

kolaboy wrote:

The safest is to change the FieldStartDelimiter and FieldEndDelimiter to none and then import. Its going to complain of commas if you don't take care of the commas. Make sure there is no comma in you data.

That's not true, I'm importing data with commas separated by commas too (csv files), and it works perfectly.

kolaboy

What you said is true, I am just suggesting that if he is having trouble with the comma delimited, then he can do what i said.