Formula to display one part of text field

Question

Hello! I'm looking for help with the proper formula syntax to grab a string of numbers from a text field. The string I want will also be after the word "Code" and before the word "Order".

Code: 123456789
Order: XXXXXXXX

Thanks!

------------------------------
Raymond Sakar
------------------------------

markshnier__you · Answer

There is more than one way to do this, and detecting a line feed can be tricky, but try thisTrim(Right(Left([my Code Order field], "
"), " "))------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

raymondsakar · Answer

Thanks, Mark. That formula output the Order #, not the Code. I've tried several variations and can't seem to get the Code. I either get the Order, the word "Code" or the word "Order"

------------------------------
Raymond Sakar
------------------------------

markshnier__you · Answer

OK, Plan Bvar text ReplaceCode = SearchAndReplace([Code Order], "Code:", "|");var text ReplaceOrder = SearchAndReplace($ReplaceCode, "Order:", "|");Trim(Part($ReplaceOrder,2, "|"))------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

Forum Discussion

Formula to display one part of text field