Split Filename

[Immow]

Sorry if this is a double post, can't find my original one.

We use our file-names to store part-numbers.

example "[xx_xx_xx_xx] name"

I'm trying to separate [xx_etc.] from the file-name for my sheet and BOM.

To get the file-name we use this line of code: $PRP:"SW-File Name(File Name)"

The next step would be to use excel to filter out [xx_etc.] part or split it somehow. I don't know how to do this.

Kind regards,

Koen

 

[handleman]

Do you have any familiarity at all with VBA? You can embed VBA code in an equation to do this. The equation can be stored in the part template. I can't remember if it was here or the SW forum, but I've posted a very similar equation before to load a custom property with part of the filename.

-handleman, CSWP (The new, easy test)

 

[Gupta65]

Koen, I posted a video on how to do it with design table here:

https://forum.solidworks.com/message/224715#224715

Deepak Gupta
SW 2010 SP4.0 & 2011 SP3.0
Boxer's SolidWorks™ Blog