How do you extract text from the middle of another text field?

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
I need to extract a person’s name from another field that captures the date and person that made the change.  I am struggling with a formula that captures the characters between the second blank and the ].  Here is an example.

-- [APR-26-17 Scott Ervin] --------------
Photo of Scott

Scott

  • 238 Points 100 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
NotLeft(Left(Right([Notes],"["),"]"),10)

This will look at your notes field with new entries being added to the bottom (set in the field properties), and will return the name of the person making the last note.
Photo of Scott

Scott

  • 238 Points 100 badge 2x thumb
Perfect!  Thank you very much!
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,436 Points 50k badge 2x thumb
Kevin
Your formulas are for Excel and not QuickBase.