AnsweredAssumed Answered

How to depict a changing doc name in VB hyperlink script

Question asked by hannahm7 on Jun 13, 2016
Latest reply on Jun 13, 2016 by tkowal

I am trying to hyperlink PDF Floor Plans through Facility Number in VB Script Field Calculator.

My issue is that there are about 859 Floor Plans and each has a different name but starts with a Facility Number.  I have no issue matching the Facility Number but what do I do about the varying string description that vary in length and contain numbers.

 

Example:

Facility Number = A123

Floor Plan = A123_Admin_Hall_2016.pdf

 

This is what I have so far, how do I incorporate the string?? Are there wild card characters I can use?

 

"S:\DPW\Eng Record Management\Floor Plans" & [facilityNumber] & .pdf"

 

Thanks!!!

Outcomes