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------------------------------
Original Message:
Sent: 05-18-2022 09:43
From: Raymond Sakar
Subject: Formula to display one part of text field
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
Original Message:
Sent: 05-18-2022 09:25
From: Mark Shnier (YQC)
Subject: Formula to display one part of text field
There is more than one way to do this, and detecting a line feed can be tricky, but try this
Trim(Right(Left([my Code Order field], "\n"), " "))
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
Original Message:
Sent: 05-18-2022 09:14
From: Raymond Sakar
Subject: 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: 123456789
Order: XXXXXXXX
Thanks!
------------------------------
Raymond Sakar
------------------------------