CFLib.org – Common Function Library Project

AccessLinkClean(strval)

Last updated January 3, 2002
Download UDF

author

Mark Andrachek                                    Mark Andrachek

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:

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

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

Search CFLib.org


Latest Additions

Shawn Porter Shawn Porter added
DeMoronize
3 hour(s) ago

Chris Carey Chris Carey added
readPropertiesFi...
1 day(s) ago

Randy Johnson Randy Johnson added
lastDayofWeek
3 day(s) ago

Frank Marion Frank Marion added
sitemapPing
7 day(s) ago

Top Rated

James Sleeman                                     QuickSort
Rated 5.0, 3 time(s)

Barney Boisvert indentXml
Rated 5.0, 3 time(s)

Nathan Dintenfass                                 queryColumnsToSt...
Rated 5.0, 3 time(s)

Kevin Pepperman generateSsccAsn
Rated 5.0, 3 time(s)

Created by Raymond Camden / Design by Justin Johnson