Forum Discussion

ScottErvin's avatar
ScottErvin
Qrew Cadet
8 years ago

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

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] --------------

3 Replies

Sort By
  • Eric_J_Hansen's avatar
    Eric_J_Hansen
    Qrew Cadet
    8 years ago
    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.