AnsweredAssumed Answered

How to split land survey location (twp,rg,mrd)?

Question asked by ljw338 on Dec 9, 2016
Latest reply on Dec 12, 2016 by ljw338

New to FileMaker and am trying to split up cells containing well locations, which are originally listed as one string, into 4 separate cells.


Example of original data: S20T31R1M5

Desired outcome: S20, T31, R1, M5. 


The other issue is that sections (S) and ranges (R) can be either 1 or 2 digits and townships (T) can be either 1, 2 or 3 digits in length.  I have seen answers describing how to split up first and last name into separate cells and that makes sense as they had spaces whereas here I do not.


Any help would be appreciated - thanks in advance.