T
Tmuldoon
Hello,
My bank allows me to download transactions but only in .qif or .ofx
formats (Quicken and MS Money). Any way to get into Excel or Open
Offices Calc?
The .qif format looks like this in Word (2 records shown)
D01/02/2006
T-15.70
MPOS MERCHANDISE;COMPOOTER WARE #2173;
^
D01/02/2006
T-14.52
MPOS MERCHANDISE;CHEVRON 89002074;
^
I would like to see each line in separate filed - so I would have two
records like
D01/02/2006 T-15.70 MPOS MERCHANDISE;COMPOOTER WARE #2173;
D01/02/2006 T-15.70 MPOS MERCHANDISE;CHEVRON 89002074;
Since the 2nd filed is a number - any way I could strip out the 'T-'
so I could do calculations?
I don't have Perl or any scripting language on my XP home setup - any
suggestions?
Thanks,
Tmuld.
My bank allows me to download transactions but only in .qif or .ofx
formats (Quicken and MS Money). Any way to get into Excel or Open
Offices Calc?
The .qif format looks like this in Word (2 records shown)
D01/02/2006
T-15.70
MPOS MERCHANDISE;COMPOOTER WARE #2173;
^
D01/02/2006
T-14.52
MPOS MERCHANDISE;CHEVRON 89002074;
^
I would like to see each line in separate filed - so I would have two
records like
D01/02/2006 T-15.70 MPOS MERCHANDISE;COMPOOTER WARE #2173;
D01/02/2006 T-15.70 MPOS MERCHANDISE;CHEVRON 89002074;
Since the 2nd filed is a number - any way I could strip out the 'T-'
so I could do calculations?
I don't have Perl or any scripting language on my XP home setup - any
suggestions?
Thanks,
Tmuld.