Hyperlink Property UNC Path with white space %20

Dorean 9 months ago

Hi Guys

I'm calculating a UNC path Value into a Hyperlink Text property, whichs looks something like this:

Only variable hereby is the last 5 digits, the rest of the path is static. Sadly, the whitespace / blank is translated to "%20" which then leads to an error opening the link with explorer. Without this, by coping the whole thing directly into explorer path, it works smoothly.

I already tried a couple of workarounds from the web like putting the path in "" / <> or brackets []. None of it had an effect.

Neither did putting file:// in front of the whole thing or trying the old windows path length restriction version (~1).

Has anyone an idea, how to get rid of this nuisance? I think it stems from the fact, that M-Files convert the sentence into a weblink, instead of an explorer path.

Many thanks for your help and kind regards,

Thomas

Top Replies

0 𝕤𝕨𝕖𝕚𝕤𝕖 9 months ago

Sorry, this ist not what you want to hear, but did you consider naming the Folders without space?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Dorean 9 months ago in reply to 𝕤𝕨𝕖𝕚𝕤𝕖

Sadly, another System references to this exact path, so it cannot be renamed, as long as its in use. Otherwise its references would be destroyed.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 d.dear 9 months ago

Note sure if this helps you or not, but we do something similar that involves the white spaces and then adds a variable or changed part at the end. The static part is formatted this way for us: szPath = "file:///M:\Closed Matters\- Master View -\" . This references a view, but the the triple slash? Maybe? We have a small script to calculate the final value.
Cancel
Vote Up +1 Vote Down

Sign in to reply

Verify Answer

Cancel

0 Ne0Tr0n 9 months ago in reply to d.dear

This is not bad idea.

Set oPropVals = CreateObject("MFilesApi.PropertyValues")
Set oPropVals = Vault.ObjectPropertyOperations.GetProperties(ObjVer)

iPDFileName = Vault.PropertyDefOperations.GetPropertyDefIDByAlias("PD.FileName")

szPDFileName = oPropVals.SearchForProperty(iPDFileName).TypedValue.DisplayValue

szPDFileName = Replace(szPDFileName,"""","")
szPDFileName = "file:///" & szPDFileName

OUTPUT = szPDFileName