Forum Discussion

AlycnBjergo-Jus's avatar
AlycnBjergo-Jus
Qrew Member
3 years ago

Formula help

I need to pull out the text string which in the example below is "MVP623037 (Load ID)" however it is not always in the same place in the field.  It could be the first string, second or last string between commas for example.  How can I pull this out?  Am I also able to only pull out the "MVP623037" in that string via formula?

1381207285 (PRO), MVP623037 (Load ID), MVP623037 (BOL)


------------------------------
Alycn Bjergo-Justen
------------------------------
Formulas and functions
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    3 years ago
    This might work

    Right(
    Trim(Left(
    SearchAndReplace([My String],"(Load ID)", "|") ,"|"))," ")

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