Forum Discussion

EmberKrumwied's avatar
EmberKrumwied
Qrew Assistant Captain
3 years ago

Extracting Text

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 Replies

  • try this

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

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------
    • EmberKrumwied's avatar
      EmberKrumwied
      Qrew Assistant Captain
      Brilliant!  Thank you SOOOO very much!

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