Skip to Content
0
Former Member
Apr 18, 2011 at 06:33 PM

Formula - word extraction

41 Views

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]