Forum Discussion

ArchiveUser's avatar
ArchiveUser
Qrew Captain
10 years ago

Can I extract specific text from the middle of a string?

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 m...
Formulas and functions
roles and permissions
Tables and fields
_anomDiebolt_'s avatar
_anomDiebolt_
Qrew Elite
10 years ago
But the "best" known QuickBsae formula fails on this test case:

I am driving down US54 to pick up a load of SASSAFRAS AND BOXES OF S5442

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.