CFLib.org – Common Function Library Project

AccessLinkClean(strval)

Last updated January 3, 2002

author

Mark Andrachek

Version: 1 | Requires: CF5 | Library: StrLib

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:

Name Description Required
strval Variable containing the MS Access link you want to 'clean'. Yes

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); 
}
blog comments powered by Disqus

Search CFLib.org


Latest Additions

Kevin Cotton added
date2ExcelDate
May 5, 2016

Raymond Camden added
CapFirst
April 25, 2016

Chris Wigginton added
loremIpsum
January 18, 2016

Gary Stanton added
calculateArrival...
November 19, 2015

Sebastiaan Naafs - van Dijk added
getDaysInQuarter
November 13, 2015

Created by Raymond Camden / Design by Justin Johnson