Home

repair QIF format for NLB

E-mail Print
Share/Save/Bookmark
I use NLB (Nova Ljubljanska Banka) and I wanted to import data to Quicken.

The problem was, that NLB only supports QIF or CVS export and Quicken only supports limited QIF import.

When I looked more deeply I found out that the problem occurs because of the date format. NLB exports date as DD.MM.YYYY and Quicken expects date to be MM/DD/YYYY.


This can easily be achieved with search and replace functionality built in almost every text editor. I use a free Notepadd++

Open qif file in your editor, go to search and choose Regular expression mode. You can find all occurrences of a date with expression D(.*)\.(.*)\.(.*) and replace it with expression D\2\\1\\3


Let me know if I helped ;)
Hits: 1443
Comments (0)Add Comment

Write comment

busy
Last Updated ( Wednesday, 03 March 2010 20:10 )  

Sponsored Links

My friends

Bookingpoint
partner websites

Donate

Do you find content useful? Please donate so I can cover my hosting expenses! Thanks!