BOM TABLE

[Bryce Lee]

I am trying to set up a BOM table but our PDM system adds 9 under scores and a 6 digit number after our part number. I am trying to write a relation to only include the part numbers before the under scores.


Example: 174490_________535303.prt (need to only keep 174490)


Any ideas!!


Thanks!!


Lee

 

[dibloff]

Generally I can say, if you have a part number & part name in a context like this:


12345678_this_in_the_part_name


and you use these relations:


PART_NO=extract(rel_model_name,1,search(rel_model_name,"_")- 1)


NAME1=extract(rel_model_name(),10,(string_length(rel_model_n ame())-9))


You can have these parameters:


PART_NO=12345678


NAME1=this_in_the_part_name


I leave the rest for you. Just play with the numbers in the brackets. If I would say what are the correct numbers, you woul not recognize it a year later