I'm fairly new to SSRS and still learning what all the many functions will do. I have a string that contains the entire legal description of a location (Township, Range, Section, and Subsection). An example is: T36SR01W36NESE. This would be easy to use the LEFT function but the numbers between the T & S and between the R & W aren't always padded with the leading 0. In addition, the last 4 showing NESE are sometimes only two characters. What I'm trying to figure out is how to get them to be 4 separate fields:
Township: T36S
Range: R01W
Section: 36
SubSection: NESE
Township will always begin with T and end with S or N
Range will always begin with R end with E or W
Section is always 2 digit (although I'm not sure the lower numbers have the leading 0 all the time)
Is it possible to create functions to extract this data?
Thank you in advance for any help and advice!
Sande
Township: T36S
Range: R01W
Section: 36
SubSection: NESE
Township will always begin with T and end with S or N
Range will always begin with R end with E or W
Section is always 2 digit (although I'm not sure the lower numbers have the leading 0 all the time)
Is it possible to create functions to extract this data?
Thank you in advance for any help and advice!
Sande