search

stant / mdcsvimporter2015

GNU Lesser General Public License v3.0
13 stars 5 forks source link

Parsing priority #7

Closed breaghva closed 5 years ago

breaghva commented 6 years ago

Hi all, Nice tool, thanks. Ithink I've found an issue importing text fields which contain a "," character - this is used a lot in some currency values. The record below:

13/01/2018,"Reference: xxx"," 7.59","WS CALAIS","8,25 EUR COMM.FEE 0.22 Process Date 13/01/2018 Currency Conversion Rate 1.1194 Commission Amount 0.22",

Imports as: 13/01/2018 Reference: xxx 7.59 WS CALAIS 8

(last field should be: 8,25 EUR COMM.FEE 0.22 Process Date 13/01/2018 Currency Conversion Rate 1.1194 Commission Amount 0.22

I guess the parsing should look for the closing quote character before examining the text for more delimiters... If there is a workaround, please let me know.

stant commented 6 years ago

Hi.This works. Look at the settings I used. I just set: header, footer, Date and fields. I'm sorry I did not see this among other emails. settings entry main preview