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.