Hello all, I'm trying to correct some shopping cart files that got messed up and need to be reformatted, so we can rebuild the database from these text order files. This is a sample of some of the data:
order_items::PF110::1::::::::::::89.95::0.00::89.95:::::::::: ^^GG111::1::::::::::::49.95::0.00::49.95:::::::::: order_items::GU402::2::Necklace Color Black::::::::::29.95::0.00::59.90:::::::::: ^^TUE100::1::::::::::::95.00::0.00::95.00:::::::::: ^^GG111::1::::::::::::49.95::0.00::49.95:::::::::: ^^LM305::1::::::::::::12.95::0.00::12.95:::::::::: ^^CO303::1::::::::::::24.95::0.00::24.95:::::::::: order_items::GU402::2::Necklace Color Black::::::::::29.95::0.00::59.90:::::::::: ^^AN401::1::::::::::::64.95::0.00::64.95:::::::::: ^^GU407::1::::::::::::29.95::0.00::29.95:::::::::: ^^PF110::1::::::::::::89.95::0.00::89.95:::::::::: Now each of these "order_items" lines, I need to grab the lines from the file, IE: order_items::PF110::1::::::::::::89.95::0.00::89.95:::::::::: ^^GG111::1::::::::::::49.95::0.00::49.95:::::::::: then put it all on one line, IE: order_items::PF110::1::::::::::::89.95::0.00::89.95::::::::::^^GG111::1::::::::::::49.95::0.00::49.95::::::::: Here is what the entire order file looks like: invuserid::[EMAIL PROTECTED] address1::1111 Princewood Dr. address2:: city::AnyWhere state::WI zip::12345 country::US firstname::John lastname::Doe midname::D. phone::1.555.1212. hphone:: nphone:: fax:: shaddress1::1111 Princewood Dr. shaddress2:: shcity::AnyWhere shstate::WI shzip::12345 shcountry::US shfirstname::John shlastname::Doe shmidname::D. total_weight::2.54 invno::1023467192204 invdate::6/7/2002 tot_price::289.75 tot_discount::57.95 tax_total::0.00 vat_tax::0.00 shipping_total::8.00 tot_item_shipping::0 grand_total::239.80 order_items::TUE100::1::::::::::::95.00::0.00::95.00:::::::::: ^^PF109::1::::::::::::59.95::0.00::59.95:::::::::: ^^LGP107::1::::::::::::59.95::0.00::59.95:::::::::: ^^QM201::1::::::::::::24.95::0.00::24.95:::::::::: ^^EN200::1::::::::::::24.95::0.00::24.95:::::::::: ^^CO303::1::::::::::::24.95::0.00::24.95:::::::::: Any suggestion/help on the best way to do this, and would be appreciated. TIA, -- Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Bus Phone: 1(985)902-8484 Cellular: 1(985)320-1191 Fax: 1(985)345-2419 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]