Discussions

Expand all | Collapse all

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

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

    Posted 04-26-2017 17:55
    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] --------------


  • 2.  RE: How do you extract text from the middle of another text field?

    Posted 04-26-2017 18:44
    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.


  • 3.  RE: How do you extract text from the middle of another text field?

    Posted 04-26-2017 19:06
    Perfect!  Thank you very much!


  • 4.  RE: How do you extract text from the middle of another text field?

    Posted 05-10-2017 11:18
    Kevin
    Your formulas are for Excel and not QuickBase.