I have a formula that extracts the numbr after the x and is used in a calculation. Now the word "fix is being entered before the x5 and it is messing up the formula. Can someone tell me how I can extract the word fix or fixed from this string so my formula below works again.
STRING
fix - x5/zpwv/q2/r57/c89/zons/q1/r104/zbp/q2/r43/u10
Formula
IF Len({@Convert Labor Ticket to Lower Case}) -
Len(Replace({@Convert Labor Ticket to Lower Case},"x","")) >= 1
THEN SPLIT({@Convert Labor Ticket to Lower Case},"/") [1]