CFLib.org – Common Function Library Project

Description:
MS Access stores hyperlink information like: www.KomputerMan.com#http://www.KomputerMan.com#. This tag removes the second part of that data leaving you with just www.KomputerMan.com.

Return Values:
Returns a string.

Example:

<cfsavecontent variable="myString">
 www.KomputerMan.com#http://www.KomputerMan.com#
</cfsavecontent>

<cfoutput>#trimAccessHyperlink(mystring)#</cfoutput>

Parameters:

Full UDF Source:

/**
 * Convert an Access hyperlink field to text.
 * 
 * @param str      String to parse. (Required)
 * @return Returns a string. 
 * @author Kurtis D. Leatham (KDL@KomputerMan.com) 
 * @version 0, June 25, 2008 
 */
function trimAccessHyperlink(str) {
    var endTag = "";
    var extract = "";
    str = trim(str);    
    endTag = findNoCase("##", str);
    if (endTag gt 0) {
        endTag = endTag - 1;
        extract = left(str, endTag);
    } else {
        extract = str;
    }
    return trim(extract);
}