Submitted by Mordechai on
Issue summary:
Hi,
You're not handling line items with quoted strings correctly. The following lines were not included in the output QIF file.
Any line item with "Smith, Herbert MD" or "Katchis, Stuart MD" or "Howanitz, Nancy MD". I was wondering why these weren't making it through but other healthcare items were, then I realized these were all doctors that I had as last name, first name.
Also, line items with amounts greater than 999.99 aren't making it to the QIF file because Excel has them as 1,234.00 so they get quoted. I suppose I could have changed the format to not include commas but that was not an obvious problem beforehand.
Regards
Mordechai
Reporter:
Mordechai
Created:
Mon, 08/15/2016 - 02:48
Updated:
Fri, 08/19/2016 - 01:23
Comments
Mordechai replied on Comment #1
See Issue Summary
admin replied on Comment #2
Before I start debugging this, have you tried to re-save the CSV on Excel as suggested here
http://www.csvconverter.biz/blog/how-fix-csv-file-not-being-converted