How to create CSV with enquoted strings inside?



I’m trying to generate CSV file with just strings inside. Unfortunately I’m unable to enclose strings in double quotes.

I’ve tried using Chr(34) + strVar, but that ends with strings enclosed in three double quotes.

All variables are defined as System.String.

I’m using these actions to write CSV:

  1. Build Data table (all columns are strings),
  2. Add data row (arrayRow = {numEA, numPS, “OK”}
  3. Append to CSV

Thank you.


chr(34) works for me

{"numEA","numPS", chr(34)+"OK"+chr(34)}