I have a .csv file that has double-quotes around every field. Some of the fields have a comma inside the double quotes. When I use the Create Excel task, it works beautifully until it hits a field with a comma inside the double quotes, and parses on that comma as well. For Example:
"John", "Doe", "1234 Somewhere Lane, My City, CA", "(123) 293-8829"
This should parse with 4 fields as:

But instead it parses with 6 fields as:

How do I get the Create Excel task to recognize the quoted identifiers and parse correctly.
I have set the quoted identifier option as double-quotes.

Thanks for the report, I have passed this on to our developers.

---

We believe we have fixed the issue in this version, please test:

http://www.visualcron.co....aspx?g=posts&t=4940 

---

Hm. I believe your change has introduced a new error.
I now get the following error in my Create Excel Task:
Error: Exception in Task: parsing "\|(?=(?:[^]*[^]*)*(?![^]*))" - Unterminated [] set.

My task is based on output from another task with a Pipe-separator, a blank text-qualifier and Cr as newline.
I think it's the blank text-qualifier that is the problem

Best regards,
René

Hm. I believe your change has introduced a new error.
I now get the following error in my Create Excel Task:
Error: Exception in Task: parsing "\|(?=(?:[^]*[^]*)*(?![^]*))" - Unterminated [] set.

My task is based on output from another task with a Pipe-separator, a blank text-qualifier and Cr as newline.
I think it's the blank text-qualifier that is the problem

Best regards,
René

Thanks for the report - we will look at this ASAP.

---

René, please try this build that has this only fix:

http://www.visualcron.co....aspx?g=posts&t=4994 

---