Convert .qif or .ofx to .xls or Open Office format?
 

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.

Convert .qif or .ofx to .xls or Open Office format?
 

A simple google search yields a number of possibilities:
http://www.google.com/search?hl=en&q...files+in+excel

http://www.bigredconsulting.com/docu...umentation.doc

http://groups.google.com/group/micro...4387b48d0325f6

Dave
--
Brevity is the soul of wit.


"Tmuldoon" wrote:

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.

Convert .qif or .ofx to .xls or Open Office format?
 

I've managed this.

Since its basically a text file, open it in a word processor,
including Open Office. Do a find and replace for "D[hrt]" where [hrt]
is whatever the word processor's code is for a return. In the replace
box, put in a pipe or some other delimeter, I wouldhave said a semi-
colon, but your file seems to already have semi-colon's in it. Then
have it replace all of those. Do the same with the other letters: T
and M.

What you want is a text file that looks like lines like these:

1/02/2006|-15.70|POS MERCHANDISE; COMPOOTER WARE #2173;
1/02/2006|-14.52|POS MERCHANDISE; CHEVRON 89002074;

Now, save it as a text file, when you open it in the spreadsheet, it
should guide you through confirting the pipes "|" into columns and
you'll be all set.

-TTB