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
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
10 years ago
yes, quite right so this is now the best native solution

List("\n",
  If(Begins(Part(, 2, "Ss"), "5"), "S" & Left(Part(, 2, "Ss"), 4)),
  If(Begins(Part(, 3, "Ss"), "5"), "S" & Left(Part(, 3, "Ss"), 4)),
  If(Begins(Part(, 4, "Ss"), "5"), "S" & Left(Part(, 4, "Ss"), 4)),
  If(Begins(Part(, 5, "Ss"), "5"), "S" & Left(Part(, 5, "Ss"), 4)),
  If(Begins(Part(, 6, "Ss"), "5"), "S" & Left(Part(, 6, "Ss"), 4)),
  If(Begins(Part(, 7, "Ss"), "5"), "S" & Left(Part(, 7, "Ss"), 4))

I do agree that the one line of code does look powerful