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
BobJordan's avatar
BobJordan
Qrew Cadet
9 years ago
Hey Dan,
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

You mentioned that this could be done with script and regular expressions - can this be done within a quickbase formula field?

I've noticed that within a text formula field I can include "javascript($string..." and it will accept it, but any parameters of the javascript variable willl error out (ex: javascript($string.search("S5")) will result in an error at the .search part).
BobJordan's avatar
BobJordan
Qrew Cadet
9 years ago
Hi,

Thanks Dan. Understood about the script in formulas - it does seem rather cumbersome. If I wanted to look into getting out of formulas though, where woudl you input the script? 

I work with imported sheets, so I'm attempting to pull the middle strings out from these imported fields. Is there a specific type of field and format I should use to make use of script?