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,~brbr~Just to confirm this report is scheduled and running for you (I think in Batch mode) by CRD Managed Services. ~brbr~See report example attached.“
“00T3300004pRxv6EAC”,“01233000000IgHfAAK”,“5003300000tySXWAA2”,“2016-02-29”,“00533000003ce8SAAQ”,“2016-02-29T19:23:55.000Z”,“00533000003ce8SAAQ”,“2016-02-29T19:24:47.000Z”,“00533000003ce8SAAQ”,””,"Hi Tim~br
Thanks,
Jonathan