Can you encode CR/LF in into CSV files?

Question

Is it possible/legal to somehow encode CR/LF characters into a CSV file? (as part of a CSV standard?) If so how should I encode CR/LF?

Accepted Answer

Yes, you need to wrap in quotes:

```
"some value
over two lines",some other value
```

From this document, which is the generally-accepted CSV standard:

Fields containing line breaks (CRLF), double quotes, and commas should be enclosed in double-quotes

P.S For fields with double quotes inside, you should also escape double quotes with two quotes, e.g

```
"Samsung U600 24"""
```

Solution