I have a field that contains serial numbers within blocks of sentence text. I want to extract the serial numbers and place them into their own field. I cannot control the input into these fields or mandate that a new field be filled out.
For example, the field may contain:
"Picked up S5442 at Boxies on Golden" or "S5931 inbound to home"
What I'd like my formula field to display is "S5442" and "S5931" respectively.
The serial numbers will always start with "S5" and be 5 characters long total.
What would be ideal is something similar to excel's 'Find' formulas - for example: MID(A1, FIND("S5", A1,), 5) - However I can't seem to find anything analogous to this in Quickbase.
You simply cannot get the anywhere near the level of precision with the extremely limited set of text manipulation functions in QuickBase compared to using script and regular expressions