I'm using a File Access Node to write a CSV file and there is column that has a comma in it (Employee,Hiring Manager) which must stay in one cell. How do I handle the comma in this instance where it does not how up as two separate columns?
*file should be field.
Usually in CSV files if there is a field that contains commas, that file will be wrapped in a text qualifier character (usually double quotes).
You will need to encase the value within double quotes example "Employee, HiringManager"
Ok - I'll take a look and Thank you
If your field's value might ever have a quotation mark in it, then you'll also need to escape the quotation mark by doubling them up.
I.e., if your input was John Doe,The "Big" Boss then when you write your CSV file you'd want to output it as "John Doe,The ""Big"" Boss" (contrived example, obviously). If your Employee and Hiring Manager values just refer to employee numbers (say 123456,987654) then you'd only need to wrap the whole thing in double quotes ("123456,987654").
All set and Thank you
