Select order number from text field
I have a text field includes the subject for order confirmations. Some emails have the subject: Order Confirmation (1234567) or Order Confirmation - 1234567 Is there a way to grab only the sal...
Forum Discussion
I tested this and it works :)
var number A = ToNumber(Part([Subject],1," -(),"));
var number B = ToNumber(Part([Subject],2," -(,)"));
var number C = ToNumber(Part([Subject],3," -(,)"));
var number D = ToNumber(Part([Subject],4," -(,)"));
var number E = ToNumber(Part([Subject],5," -(,)"));
var number F = ToNumber(Part([Subject],6," -(,)"));
Max($A, $B, $C, $D, $E, $F)
I suggest continuing the pattern up to as many words you think are possible before the numbers. So just go to say ABCDEFGHIJKLM
The characters in these quotes here " -()," need to be all the ones which might precede or directly follow the numbers.
Mark
var number A = ToNumber(Part([Subject],1," -(),"));
var number B = ToNumber(Part([Subject],2," -(,)"));
var number C = ToNumber(Part([Subject],3," -(,)"));
var number D = ToNumber(Part([Subject],4," -(,)"));
var number E = ToNumber(Part([Subject],5," -(,)"));
var number F = ToNumber(Part([Subject],6," -(,)"));
Max($A, $B, $C, $D, $E, $F)
I suggest continuing the pattern up to as many words you think are possible before the numbers. So just go to say ABCDEFGHIJKLM
The characters in these quotes here " -()," need to be all the ones which might precede or directly follow the numbers.
Mark
- Thank you! That worked great.
