Problem in importing data from csv file using Multiload

[amehra]

I am having a csv file that is to be used for importing data. But the
problem is that some description columns in the csv files contain comma
itself, so this is causing problem.

The structure of csv file is like this:

Id,Name,Desc,Value
1,xyz,This is description,and is having a comma in it,10

Now when I am trying to import such data using Multiload it reads

Id as 1
Name as xyz
Desc as This is description
Value as and is having comma in it

which is wrong.We need to import 10 in Value column and "This is
description,and is having a comma in it" in Description column.

Can this problem be solved?

In the layout option can we specify someting for it?

 

[dnoeth]

The only way i can think of is an INMOD, but i don't know if you can write it for VARTEXT format.

But how do you know it's
Name -> "xyz"
Description -> "This is description,and is having a comma in it"

instead of
Name -> "xyz,This is description"
Description -> "and is having a comma in it"

Dieter