key pairs

I have the following bit of information coming in that I need to generate key pairs of so I can drop it all into a database. I'm creating tables for each section (SHIP_TO and BILL_TO) with matching Unique_IDs. What's the best way to go about this (creating the pairs, stripping off excess spaces from some fields that have them after the last character, etc., etc.) ---------- data ---------- SHIP TO: Business Name:

 Contact Name:     Ashley Kirchner
 Day Number:       303 442-6410

Evening Number: Fax Number:

 Address:          3550 Arapahoe Ave., Ste. #6

Address: Address:

 City:             Boulder

State/Province: CO Zip/Postal Code: 80303

 Country:          USA

BILL TO: Business Name:

 Contact Name:     Ashley M. Kirchner
 Day Number:       303 4426410

Evening Number:

 Fax Number:       303 442-9010
 Address:          3550 Arapahoe Avenue
 Address:          Suite #6

Address:

 City:             Boulder

State/Province: CO Zip/Postal Code: 80303

 Country:          USA

---------- -- W | I haven't lost my mind; it's backed up on tape somewhere. +-------------------------------------------------------------------- Ashley M. Kirchner <mailto:ashley@pcraft.com> . 303.442.6410 x130 IT Director / SysAdmin / WebSmith . 800.441.3873 x130 Photo Craft Laboratories, Inc. . 3550 Arapahoe Ave. #6 http://www.pcraft.com ..... . . . Boulder, CO 80303, U.S.A.