Question

Add Comma Values Into Single CSV Cell

  • 15 August 2023
  • 1 reply
  • 74 views

Userlevel 3
Badge +9

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.


1 reply

Badge +2

Hi Logan ,

 

Please pass the variables withing "$value$"

 

Example 

 

Log to file "dollar", "eft, check, cash", "$3,000,000"

 

If u do the follow u will have 3 column values as you wanted 

Reply