CFLib.org – Common Function Library Project

Description:
Takes an Access "Hyperlink" field value, and turns it into a regular URL by removing the extra pounds at the beginning and end of the URL. This preserves pounds included as internal references.

Return Values:
Returns a string.

Example:

<CFSET AccessLink="##http://www.cflib.org/##">

<CFOUTPUT>
Access Link: #AccessLink#<BR>
Cleaned: #AccessLinkClean(AccessLink)#
</CFOUTPUT>

Parameters:

Full UDF Source:

/**
 * This turns a Microsoft Access hyperlink field into a standard URL.
 * 
 * @param strval      Variable containing the MS Access link you want to 'clean'. 
 * @return Returns a string. 
 * @author Mark Andrachek (hallow@webmages.com) 
 * @version 1, January 3, 2002 
 */
function AccessLinkClean(strval)  
{
   return Mid(strval,2,Len(strval)-2); 
}