Which delimiter should be used for lists of values inside a CSV file?

Question

I have a CSV file that has lists of values for some fields. They're stored in the database as HTML "ul" elements, but I want to convert them into something more spreadsheet-friendly. What should I use as my delimiter? I could use escaped commas, pipes, semicolons, or pretty much anything else. Is there some kind of de facto standard people use for this?

Accepted Answer

Quotes around the item is for this

```
123, hello, "a, b, c, d", 29
```

Which delimiter should be used for lists of values inside a CSV file?

Solution

Problem