I have a file that I'm getting from an source, the first field contains a
field like this:

OK - Interim OR Director / Southwestern Medical Center
IA - ASAP MedSurg/Float Nurse/Nights / Allen Hospital
AZ - ICU (URGENT) / Tuba City Regional
MT- OR/RN / Billings Clinic
CO - RN OR Eve shift / Medical Center of the Rockies

Each line represents one cell. My problem is that I need this data
transformed some how in to three fields. State, Position, Facility (which is
the order and information contained in the cell).

Any thoughts, suggestions? Thanks in advance for your help.