Table and Repeat Region Formula for Truncating filename field

[jungleb77]

Hi Guys,

I know that this is possible, but the horrendous PTC documentation doesn't turn anything up. I'm looking for a relation formula to truncate a filename field.

We've got filenames that look like: 12-345678_short_note.drw

I'd like to show this in title blocks and BOM tables as simply 12-345678

Anyone done this? Any good sources for help on this type of thing?

thanks in advance,

--John

 

[charleskim]

John,
Try something like this in relations.

where=search(rel_model_name,"_")
drawing_no=extract(rel_model_name,1,where-1)

Charles