Search RS field manipulation

Results 1 to 2 of 2

Thread: Search RS field manipulation

  1. #1
    Join Date
    Dec 1969

    Default Search RS field manipulation

    After search results are retrieved, how can I alter the link to the file to point to a UNC share on another server. The current results point to a physical drive location and I want to change that to a UNC. The current LOOP in the results display is:<BR>Link = RS("DocAddress"). I want to extract the file name from "D:directory estfile.doc" using vbscript. Any assistance would be greatly appreciated.

  2. #2
    Join Date
    Dec 1969

    Default RE: Search RS field manipulation

    &#039define the filePath<BR>filePath = RS("DocAddress")<BR>&#039this will return the position of the slash nearest the end<BR>i = InStrRev(filePath,"\")<BR>&#039this will trim the string and eliminate everything left of the slash nearest the end of the string<BR>fileName = right(filePath,len(filePath)-i)<BR>response.write fileName

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts