Forum Discussion

ArchiveUser's avatar
ArchiveUser
Qrew Captain
9 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
EricCirrusOps's avatar
EricCirrusOps
Qrew Trainee
9 years ago
Hi Bob,

Let's say your field was called "Description".

If you use this formula:

If(Contains([Description],"S5"),
"S5"&Left(Right([Description],"S5"),3),"")


It will find the first instance of "S5" in your field then combine S5 with the first 3 characters after S5 in the string of text. It is sort of a quick and dirty solution, but I think it should probably work. If S5 is not detected, the formula text field will remain blank.

Let me know if that works for you. Good Luck!

Eric