comma in csv

[sal21]

Big problem...
i need to use a csv with comma delimited.
but....

in one or more value, have a comma in string!!!!
similar:

...,price_title,...
...,145,55,....

[HansV]

If you want comma as delimiter, you should either enclose such values in quotes: "145,55", or use a point as decimal separator: 145.55.
Alternatively, use semi-colon instead of comma to separate the values: ...;145,55;...

[Doc.AElstein]

I get a lot of problems with , ; . in text files. If at all possible I would use some character as the separator that is unlikely to ever be in any of your data.
The pipe, | , is often used. It looks nice and pretty as a separator as well because it looks like a dividing wall

[sal21]

If you want comma as delimiter, you should either enclose such values in quotes: "145,55", or use a point as decimal separator: 145.55.
Alternatively, use semi-colon instead of comma to separate the values: ...;145,55;...

no.
required only comma delimited.

if the value is incapsulated in Myvar (as string), how to "145,55"

peraphs:

Myvar=""145,55"" (with double quote, or not?)

[HansV]

Myvar = """145,55"""

or

Myvar = Chr(34) & "145,55" & Chr(34)

[sal21]

Myvar = """145,55"""

or

Myvar = Chr(34) & "145,55" & Chr(34)

reolved with chr! tks

but similar problem with:

dim COLB AS STRING

COLB = "a:1:{i:0;s:8:"customer";}"

when i import, Excel consider two value!!!

a:1:{i:0 and s:8:"customer";}

i have used also a chr(34) for Chr(34) & COLB & Chr(34)

but why i use a comma delimited and not ;

[HansV]

It might be because your system settings use ; as list separator.