Skip to main content
Apr 5, 2012 7:15 PM UTC

Divide file name to two parameters

If your file name (model name, assembly name) is combined with DRAWING_NUMBER and MODEL_NAME separated by underscore "_" (254-33-03-008_wheel.prt) you can write relations for divide this file name to two parameters:

 

DRAWING_NUMBER = 254-33-03-008

MODEL_NAME = WHEEL

 

Write into Relations: Tools>Relations...

 

DRAWING_NUMBER=EXTRACT(REL_MODEL_NAME,1,SEARCH(EXTRACT(REL_MODEL_NAME,1,(STRING_LENGTH(REL_MODEL_NAME))),"_")-1)

MODEL_NAME=EXTRACT(REL_MODEL_NAME,(SEARCH(REL_MODEL_NAME,"_")+1),((STRING_LENGTH(REL_MODEL_NAME))-(SEARCH(REL_MODEL_NAME,"_")+1)+1))