I am working with a client to clean up records containing the legal descriptions of about 750 land parcels in 12 states. An example of the data I am starting with is "8-14N-17E", which describes three types of information about that land parcel: Section 8, Township 14N, and Range 17E. All three items contain either one or two digit numbers, plus the township and range always contain a single letter for the direction.
What I am tryiing to do is parse this data in a way that breaks it into five fields: Section, Township Number, Township Direction, Range Number, Range Direction. I am just getting started with understanding how to do this as easily as possible. I have thought of replacing the hypens with a space so that I can use the Left, Middle & Right functions, and then extract the directions after doing this.
I don't want to overcomplicate this. Any ideas? Thanks!