CFLib.org – AccessLinkClean

AccessLinkClean(strval)

Last updated January 3, 2002

author

Version: 1 | Requires: ColdFusion 5 | Library: StrLib

Rated 0 time(s). Average Rating: 0

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:

view plain print about

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

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

<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:

	
	
			
			
			
				
				view plain
				
				
				copy to clipboard
				
				
				
				
				print
				
				
				about
				ColdFISH is developed by Jason Delmore.  Source code and license information available at coldfish.riaforge.org.  Version 3.1.1
				
			<cfscript>
/**
 * 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 (&#104;&#97;&#108;&#108;&#111;&#119;&#64;&#119;&#101;&#98;&#109;&#97;&#103;&#101;&#115;&#46;&#99;&#111;&#109;) 
 * @version 1, January 3, 2002 
 */
function AccessLinkClean(strval)  
{
   return Mid(strval,2,Len(strval)-2); 
}
</cfscript>
		<cfscript>
/**
 * 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); 
}
</cfscript>