Read carefully, do not simply throw me script and ask me do it. NO. it will not work that way you need to process this data in the test fiel of 200mb(800,000) records in less than 30 minutes see complete data and input and output i expect is detailed below url www.lpbatt.com/tmp/hp-data/ 1… (Budget: $30-$250 USD, Jobs: MySQL, Perl, Script Install, UNIX)