Skip to main content
1-Visitor
June 13, 2005
Question

Repeat Regions Relations

  • June 13, 2005
  • 2 replies
  • 909 views
Hey Everyone:

I know this horse has been beat to death, but I can't find my archive for it. I need to create a repeat relation where the quantity for a hose is reading the length parameter instead of the rpt.qty parameter. This is one of those things I haven't done in forever and can't remember the exact syntax.

Thanks!

Wes Holliday

    2 replies

    21-Topaz I
    November 12, 2007
    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


    21-Topaz I
    November 12, 2007
    On a side note...this is very interesting. I sent in a completely separate email to this board with the same exact Subject line as another from 2 years ago. It seems to have attached itself to that one.

    Steve Galayda