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 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 ;)