Forum Discussion

Qrew Cadet

3 years ago

Formula to display one part of text field

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: 123...

Formulas and functions

RaymondSakar

Qrew Cadet

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

Qrew Legend

3 years ago

OK, Plan B

var text ReplaceCode = SearchAndReplace([Code Order], "Code:", "|");
var text ReplaceOrder = SearchAndReplace($ReplaceCode, "Order:", "|");

Trim(Part($ReplaceOrder,2, "|"))

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