repair QIF format

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 andQuicken 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 expressionD(.*).(.*).(.*) and replace it with expression D2\1\3

Let me know if I helped 😉

Leave a Reply

Your email address will not be published. Required fields are marked *

Please prove me that you are not spamer :) * Time limit is exhausted. Please reload CAPTCHA.