Read/write .csv where individual field contains a comma

[Warren]

I just realized I've backed myself into a corner where I"m reading and writing from csv, but now that I've created 100 of the csv's, I realized a few of them have a field that contains a comma.

What's the best resolution?

Is there a convention like encasing the field in special characters like {"..."}, or force a different delimiter like a colon? Just looking to do whatever the standard solution is.

[Marcus Tettmar]

With CSV you should put strings in quotes. Then you'd have no issue:

"this, string", 5, "blue"

That is three fields and CSV/Excel will cope. Without the quotes clearly Excel is going to treat it as 4 fields.