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

Ryan Thompson-Jewell Ryan Thompson-Jewell added
ListSplit
3 day(s) ago

Nathan Dintenfass Nathan Dintenfass added
RowsToColumns
3 day(s) ago

Barney Boisvert Barney Boisvert added
indentXml
4 day(s) ago

Barney Boisvert Barney Boisvert added
REReplaceCallbac...
4 day(s) ago

Top Rated

Rob Brooks-Bilson                                 FolderSize
Rated 5.0, 7 time(s)

Nick Giovanni                                     UniqueValueList
Rated 5.0, 5 time(s)

James Sleeman                                     QuickSort
Rated 5.0, 3 time(s)

Jeff Howden ListDeleteDuplic...
Rated 5.0, 3 time(s)

Created by Raymond Camden / Design by Justin Johnson