Environnement variable to get the file name or part of it

Question

Hi, I'm trying to get the file file name and put them in a variable to display in the interface tab. 
 But my real goal is to get the begining part of the file name, 9 first characters to be exact. Is this possible? 
 Because in my project file name need to include the revision of the drawing but we need to remove this revision in the title bloc. 
 So what I want is that my file name be like 45612-S01-RA.dgn but my titleblock display only the first 9 characters: 45612-S01 
 So my thining was to get the file name and put it in a variable that only contain 9 caracters so that the rest would get discarded but I can't seem to find a way to have a variable that display the file name. 
 
 Anybody can help here?

Sean Duphily · Accepted Answer

Since you posted this in the ProjectWise forum, I'm assuming you are trying to set an Attribute to this value. If so, try: 
 SELECT SUBSTRING(RIGHT('$DOCUMENT.FULLNAME$', CHARINDEX('\',REVERSE('$DOCUMENT.FULLNAME$'))-1),1,9) AS ExtractString 
 
 If this is something you are trying to do inside of MicroStation, there are better ways of doing this.

JeremieDL · Answer

Thanks I will try this right away! Where do you get the information on how to do this? I mean where did you find this?

Environnement variable to get the file name or part of it

Top Replies