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.
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"