Discussions

Expand all | Collapse all

Extracting Text

  • 1.  Extracting Text

    Posted 9 days ago
    I've ready a few posts and have been able to get a formula to almost work, but I'm missing something.  I have a field that will contain a text string like the following:

    B100 - C212 - M12777 - I10020
    B100 - C213 - MLV5064-01202 - I10021

    The data will always present in this format.  I need to pull out each section into its own field, but only the data that follows the letters "B", "C", and "M".  I had this working until I added the last section (starting with "I").

    My formula to pull out the data after "M" returned everything after M, including the new section "I".

    I am wondering if there is a formula to search for "M" and extract everything up until " - I".

    This formula will extract some of the "M" section but not all.  If the M section starts with LV5064, that is the only part extracted, but I need the full LV5064-01202.

    Trim(Left(Right([Time Entry Link],"M"), "- I"))

    Any suggestions?

    Thanks

    ------------------------------
    Ember
    ------------------------------


  • 2.  RE: Extracting Text

    Posted 9 days ago
    try this

    Left(NotLeft([Time Entry Link], "M"), " ")

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: Extracting Text

    Posted 8 days ago
    Brilliant!  Thank you SOOOO very much!

    ------------------------------
    Ember
    ------------------------------