[Solved] Create Excel Office Task - VisualCron - Forum

Community forum

jmlanca
2015-05-22T21:00:01Z
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:
John
Doe
1234 Somewhere Lane, My City, CA
(123) 293-8829

But instead it parses with 6 fields as:
John
Doe
1234 Somewhere Lane
My City
CA
(123) 293-8829

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.
Support
2015-05-26T11:50:44Z
Thanks for the report, I have passed this on to our developers.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Support
2015-05-27T14:14:53Z
We believe we have fixed the issue in this version, please test:

http://www.visualcron.co....aspx?g=posts&t=4940 
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
ReneTruelsen
2015-05-29T09:55:37Z
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é
Support
2015-05-29T10:17:55Z
Originally Posted by: ReneTruelsen 

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.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Support
2015-05-29T13:03:24Z
René, please try this build that has this only fix:

http://www.visualcron.co....aspx?g=posts&t=4994 
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Scroll to Top