Thanks to all who recommended solutions. Unfortunately, the problem is made more complex because QIF files have different kinds of data in different kinds of records. So I can't just read in everything as records, sort it, eliminate duplicates and write it out. There are Account Records, Expense Category Records, Budget Records, Security Records, and Transaction Records. Each of the records are gathered under one or more "header records" that identifies the collection of records following. A "switch record" identifies the end of a collection. Individual transaction records do not identify which account they come from.
I could separate the deposit/expense transactions for each separate account, make records, do a case insensitive multi-phase sort so that date order, check order, and payee order are preserved, eliminate duplicates, and write each record out as text items. Then I would need to go through and clean up. At least there would be fewer of the over 4200 records that have to be changed. But the chances of deleting information incorrectly or not deleting information that should be deleted are high. I guess I may do this if no one has done a program previously. Thanks again for your interest and help! Ed Feustel ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ Unicon-group mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/unicon-group
