I have an imported spreadsheet that I need to break apart some information in the database table. The follwoing is an example of the information. What I need to do is break apart strGrade so it sperates the grade and rank in different fields, then I need to break aprt the city state and zip into different fields as well. This is currently how all the data looks in fields.
(E5) SSG PEMBINA ND 58271
(05) LTC LAKEVILLE MN 55044-8203
I need it to look like below
strGrade strRank strCity strState strZip
E5 SSG Pembina ND 58271
O5 LTC LakeVille MN 55044
With the last 4 of zip dropped off, some have them some do not.