# Quoted field containing a comma not being processed by CSV iterator
**URL:** https://www.finalbuilder.com/forums/t/quoted-field-containing-a-comma-not-being-processed-by-csv-iterator/4702
**Category:** Bugs
**Created:** [March 1, 2016, 6:27am UTC](https://www.finalbuilder.com/forums/t/quoted-field-containing-a-comma-not-being-processed-by-csv-iterator/4702 "2016-03-01T06:27:05Z")
**Posts on this page:** 4
**Page:** 1
### Author:  [@jonathanmeltzer](https://www.finalbuilder.com/forums/u/jonathanmeltzer)
#### Post date: [March 1, 2016, 6:27am UTC](https://www.finalbuilder.com/forums/t/quoted-field-containing-a-comma-not-being-processed-by-csv-iterator/4702/1 "2016-03-01T06:27:05Z")
I will be the first to admit that when I usually report a CSV Iterator issue, it is usually something besides Automise that is causing the problem, but I can replicate this one pretty easily.
Using Automise 4.0.0.852
I am processing a CSV file from SalesForce using the CSV iterator. All fields are enclosed in double quotes. The last field in the record is a Description text field (defined as a Variant in the variable definition).
When the Description field contains a comma (the delimiter defined for the CSV iterator), the entire record is not even processed by the CSV iterator. If I remove the comma inside the Description field, the record is processed without a problem.
I thought that a CSV record’s fields can contain the delimiter if the field is enclosed in double quotes. That does not seem to be happening here, though, and I am not sure what to do about it.
A sample record that does not get processed:
“00T3300004pRxv6EAC”,“01233000000IgHfAAK”,“5003300000tySXWAA2”,“2016-02-29”,“00533000003ce8SAAQ”,“2016-02-29T19:23:55.000Z”,“00533000003ce8SAAQ”,“2016-02-29T19:24:47.000Z”,“00533000003ce8SAAQ”,"",“Hi Tim,~br~~br~Just to confirm this report is scheduled and running for you (I think in Batch mode) by CRD Managed Services. ~br~~br~See report example attached.“
I remove the comma from the last field, and the following record is processed without a problem:
“00T3300004pRxv6EAC”,“01233000000IgHfAAK”,“5003300000tySXWAA2”,“2016-02-29”,“00533000003ce8SAAQ”,“2016-02-29T19:23:55.000Z”,“00533000003ce8SAAQ”,“2016-02-29T19:24:47.000Z”,“00533000003ce8SAAQ”,””,"Hi Tim~br~~br~Just to confirm this report is scheduled and running for you (I think in Batch mode) by CRD Managed Services. ~br~~br~See report example attached."
Any ideas?
Thanks,
Jonathan
---
### Author:  [@nevar](https://www.finalbuilder.com/forums/u/nevar)
#### Post date: [March 2, 2016, 4:17am UTC](https://www.finalbuilder.com/forums/t/quoted-field-containing-a-comma-not-being-processed-by-csv-iterator/4702/2 "2016-03-02T04:17:17Z")
We found the issue in the CSV iterator action. Below is a build of Automise with updates to allow the last field to be quoted.
[http://downloads.automise.com/downloads/automise/400/ATCMD400\_919.exe](http://downloads.automise.com/downloads/automise/400/ATCMD400_919.exe)
[http://downloads.automise.com/downloads/automise/400/AT400\_919.exe](http://downloads.automise.com/downloads/automise/400/AT400_919.exe)
[http://downloads.automise.com/downloads/automise/400/AutomiseRunner400\_919.exe](http://downloads.automise.com/downloads/automise/400/AutomiseRunner400_919.exe)
---
### Author:  [@jonathanmeltzer](https://www.finalbuilder.com/forums/u/jonathanmeltzer)
#### Post date: [March 2, 2016, 2:14am UTC](https://www.finalbuilder.com/forums/t/quoted-field-containing-a-comma-not-being-processed-by-csv-iterator/4702/3 "2016-03-02T02:14:13Z")
Thank you for the quick response! Do I download all of the linked files?
---
### Author:  [@jonathanmeltzer](https://www.finalbuilder.com/forums/u/jonathanmeltzer)
#### Post date: [March 2, 2016, 4:22am UTC](https://www.finalbuilder.com/forums/t/quoted-field-containing-a-comma-not-being-processed-by-csv-iterator/4702/4 "2016-03-02T04:22:52Z")
I have downloaded the files and installed them, and I can verify that the issue is fixed. Thank you again for the quick turnaround!