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!!!
... View more