Forum Discussion

AlycnBjergo-Jus's avatar
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

1 Reply

  • This might work

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

    Mark Shnier (YQC)