I want to put a string with commas into a single CSV cell.
I have a comma separated list, but some of the values themselves contain commas that must be preserved. How can I log a value to a single CSV cell while retaining the commas within the value?
For example, I want to log data to CSV that ends up looking like this:
Currency | Payment Type | Amount |
---|---|---|
dollar | eft, check, cash | $3,000,000 |
NOTE: I understand that the data could be better represented by removing commas from the number and spreading the Payment Types into unique rows, but for the sake of my purposes, I need to figure out a way to include commas in a single cell if possible.