I wrote a little program/script called qif_date.py. I posted it on a site and had a link to download the file. However, when I tried the link, I got a fake pop-up virus checker. This is probably from a bogus ad. It was a fake attempt
to simulate a virus checker screen. As a result, I removed the link. Copy and paste the program into a file named qif_date.py . The file is source code that Python can read and execute directly. The file contents
are below between the begin and end lines. Note each line after the line that contains __main__ starts with 4 spaces. Anything after a # on a line is a comment.
You need to install ActiveState Python version 2.6 or 2.7
http://www.activestate.com/activepython/downloads http://downloads.activestate.com/ActivePython/releases/2.7.2.5/ActivePython-2.7.2.5-win32-x86.msi
will go right to the 32-bit installer.
http://www.activestate.com/activepython/downloads has links for 64-bit. version 3.x may work fine, but I tested with 2.6.
You will download the QIF file into the folder that contains the qif_date.py file...
Lets suppose you downloaded the file as xyz.qif . You would cd to the directory/folder and enter "qif_date.py xyz.qif" or "qif_date xyz.qif" without the quotes. . The program would read the xyz.qif file, it would interchange the month and day fields,
and it would write the result back to xyz.qif . Since it interchanges the date and month, if you run it twice, you are back where you were.
There is no sanity checking such as inspecting the file to be converted to insure that it is in mm/dd format initially before converting to dd/mm format. The program is not guaranteed to work correctly, but it has worked for me at least once. I expect it
to work correctly for you.
Here is the program content. There are 21 lines, 5 of which are blank. 7 of the lines are only comments. The lines after the line which contain "__main__" must be indented exactly 4 spaces. In my paste test, the indent level got a little off.
=======begin qif_date.py==============
#interchange day and month values for QIF file.
# If run twice on the same file, things are back as they were.
#useage: qif_date xyz.qif
# will change a mm/dd QIF file to a dd/mm QIF file, or vice versa
# 2012-07-15 Cal Learner.
# You are free to copy or modify as you wish.
import os, sys, re
if __name__=="__main__":
qiffile= open(sys.argv[1],'r') #open file named on command line for read
# Input file read in as parameter. Output file fixed in this case.
content=qiffile.read() #read whole file into string
qiffile.close()
datestring=re.compile (r"^D(\d+)/(\d+)([/\']\d+)$", re.MULTILINE)
content2=datestring.sub(r"D\2/\1\3", content) #the big substitution
file2= open(sys.argv[1],'w') # open the same for write
file2.write(content2) #write the modified content
==========end qif_date.py===============
