bgame-hunter / mdcsvimporter

Automatically exported from code.google.com/p/mdcsvimporter
GNU Lesser General Public License v3.0
0 stars 0 forks source link

regex parsing is not working #35

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago
What steps will reproduce the problem?
1.
2.
3.

What is the expected output? What do you see instead?

Please use labels and text to provide additional information.

Original issue reported on code.google.com by stashu....@gmail.com on 1 Jan 2015 at 5:44

GoogleCodeExporter commented 8 years ago
correct. it was storing and retrieving the config definition but then it was 
not using the user regex strings to parse with. it was using hardcoded test 
strings. I fixed it to use the config strings like it should.

Original comment by stashu....@gmail.com on 1 Jan 2015 at 5:46

GoogleCodeExporter commented 8 years ago
I put out a new mdcsvimporter-beta-18.zip. Please give that a try and let me 
know if it works for you.

Work with strings similar to these:

([^,]*([,]|\Z)).*
"([^,]*([,]|\Z)).*
([^,]*([,]|\Z)).*
([^"]*)(["]|\Z).*
([^,]*([,]|\Z)).*
([^,]*([,]|\Z)).*
([^,]*([,]|\Z)).*

for csv file:

Exported from Direct Net on 26.12.2014 / 10:19 CET,,,,
Bookings,,,,
Account Details ,,,,
Account,"1234567-01 Private account Bonviva Silver Joe Public, Switzerland 
",Balance,CHF 300.00,,
IBAN,CH73 0000 0000 0000 0000 0,BIC / SWIFT,CRESCHZ999R,,
Booking Entries from 22.12.2014 - 26.12.2014,,,
Booking Date,Text,Debit,Credit,Value Date,Balance
24.12.2014,"Bonviva Silver package fee      ,                                   
            ",45.00,,31.12.2014,300.00
24.12.2014,"Standing order                  ,CABLECOM                           
            ",117.00,,24.12.2014,
22.12.2013,"Balance of closing entries      ,as shown separately                
            ",,,31.12.2013,462.00
Total of Column,,162.00:w,0.00,,

Thanks,
Stan

Original comment by stashu....@gmail.com on 1 Jan 2015 at 5:57

Attachments: