How to retrieve part of the filename in a custom property

Hello

I'm in SW21

I work with mechanically welded parts whose file name is composed of the "case number" and the marker

Example: Case 12364

Reference: D27

File Name: 12364-D27

In my room, I would like the custom property "Coordinate System" to be automatically updated with the name of the coordinate system (D27)

I searched on the forum, but I couldn't find the walkthrough...

If anyone has an idea... thank you in advance

Solution 1: do the opposite,  fill in the locator property and concatenate the Rep property and deal number (no need for a macro, can do it)

Solution 2 Smartproperties (Visiativ software)

Solution 3: Via Macro to develop yourself.

1 Like

Thank you sbadenis!

 

you have to go through a macro to extract part of the file name with "-" as a separator

REP=Right(nom_fichier, Len(nom_fichier) - InStr(1, nom_fichier, "-", 1))