Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to convert text into date format? | Excel Discussion (Misc queries) | |||
How to convert decimal numbers to time format | Excel Worksheet Functions | |||
document doesn't open unrecognizable format | Excel Discussion (Misc queries) | |||
Convert [h]:mm sum total format to number format | Excel Worksheet Functions | |||
My document won't open, tells me file format is not valid | Excel Discussion (Misc queries) |