2 Replies Latest reply on May 18, 2009 12:07 PM by tej_web

    Trim URL from the right side.

    tej_web Level 1

      Hello all,


      I am trying to trim the right side of a URL base on the first occurrence of "\".                      



      Note: URL is a Verity search result.



      The URL example: "C:\Inetpub\wwwroot\Conv_PDF\Files\facility \ facility_ur_plan.doc "


      If I use           cfset tString = #right(#URL#,  20)#


      I get the result of  "facility_ur_plan.doc"


      What I would like to do is find the first " \ "starting from the right side and this use the result as the cut point of the Right function.


      ex: cfset tString = #right(#URL#,  #cut#  )#


      This would allow any length of a document name to be used.


      Any ideas would help.


      Thank you