Replace Underscores with Spaces in Relations

[dgschaefer]

We use the format <vendor name>_<vendor p/n> for some of our purchased components.  In order to show the info in a more readable format on drawings, that same info gets added to our "Description" parameter with spaces instead of the underscores.  I'd like to avoid typos by driving the parameter from the filename via relations while replacing the underscores with spaces. Of course, not every vendor name is the same number of characters, so using the string length isn't an option.  I need to be able to find the underscores and replace them.

Possible?

[MartinHanak · Accepted solution]

Hi,

use search and extract functions.

See http://support.ptc.com/help/creo/creo_optm/usascii/index.html#page/optm%2Foptions_modeler%2Ffund_seven_sub%2FOperators_and_Functions_for_Strings.html%23

[dgschaefer]

That should do it, I just now need to sort out the full syntax since there might be spaces in the vendor name as well.  I think I can sort that out.

Thanks.

[HamsterNL]

You could try this:

The trick here is that COMP_NAME_NICE will be "out-of-date" after the FIRST and SECOND parameters have changed, thus another regeneration is required.

Problem is that you first need to run this once, then uncomment the line.

COMP_NAME = "MY_COMPANY_NAME_WITH_UNDERSCORES"
COMP_NAME_NICE = COMP_NAME
/* COMP_NAME_NICE = FIRST + " " + SECOND
IF search(COMP_NAME_NICE,"_") > 0
   FIRST = extract(COMP_NAME_NICE,1,search(COMP_NAME_NICE,"_")-1)
   SECOND = extract(COMP_NAME_NICE,search(COMP_NAME_NICE,"_")+1,string_length(COMP_NAME_NICE)-search(COMP_NAME_NICE,"_"))
ENDIF

[dgschaefer]

Wow, that's great stuff, thanks.  I've since realized that in most cases the file name will become the P/N of the purchased item, but not in all.  So this will still be useful, but not universal as I had thought.

Thanks again.