Hi Guys,
I am trying to write a relation to determine whether a part number starts with either ABC or DE1?
I have tried looking and trying to resovle it, but i am struggling? The relation so far looks likes the below, but it doesnt work?
/* DECIDING IF DRAWING ISABC OR DE5
DECIDE_1 = 'ABC'
DECIDE = EXTRACT(PART_NO,1,3)
DECIDE = DECIDE_1 == 'ABC'
ENDIF YES (its coming back with yes as an answer rather than 'true'
If the part number starts with 'ABC' i have a relation which converts underscores to dashes this works, if the part number starts with DE5 then it is left as it is?
Your help is much appreciated?
Regards
Gary
I am trying to write a relation to determine whether a part number starts with either ABC or DE1?
I have tried looking and trying to resovle it, but i am struggling? The relation so far looks likes the below, but it doesnt work?
/* DECIDING IF DRAWING ISABC OR DE5
DECIDE_1 = 'ABC'
DECIDE = EXTRACT(PART_NO,1,3)
DECIDE = DECIDE_1 == 'ABC'
ENDIF YES (its coming back with yes as an answer rather than 'true'
If the part number starts with 'ABC' i have a relation which converts underscores to dashes this works, if the part number starts with DE5 then it is left as it is?
Your help is much appreciated?
Regards
Gary