Skip to main content
Question

Add Comma Values Into Single CSV Cell

  • August 15, 2023
  • 1 reply
  • 245 views

LoganPrice
Most Valuable Pathfinder
Forum|alt.badge.img+12

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

Forum|alt.badge.img+2
  • Cadet | Tier 2
  • 7 replies
  • August 17, 2023

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings