Our part numbers are 7-digits. Instances will have extra characters after
the 7th digit that are numbers and/or letters and could have an underscore
thrown in.
1234567_x1
1234567x1
1234567_fl
I have a series of IF-ELSE-ENDIF's for a BOM table. The problem is this:
My last two nested IF statements state to
test=extract(asm_mbr_name, 8,3)
IF test == "a certain character sequence"
new_name=extract(asm_mbr_name, 1,10)
ELSE
test=extract(asm_mbr_name, 8,4)
IF test == "a certain character sequence"
new_name=extract(asm_mbr_name, 1,11)
ELSE
new_name=extract(asm_mbr_name, 1,7)
ENDIF
ENDIF
The problem is occasionally a 10-character model name will slip through the
first IF above depending on the situation. When it does as you can see the
relation then looks for the 8-11 position characters. Since the model has
only 10 the relation doesn't know what to do with it and I have a blank cell
in the table...at least I am assuming it doesn't know what to do with it.
Is this a bug or suppose to work that way? Does anybody have a work around?
Steve G