CFLib.org – Common Function Library Project

Description:
Strips doublequotes from the beginning and end of a string. Useful for cleaning up CSV data that uses quoted columns.

Return Values:
Returns a string.

Example:

<cfset sample = """ray""">
<cfoutput>#stripOuterQuotes(sample)#</cfoutput>

Parameters:

Full UDF Source:

/**
 * Strips doublequotes from the beginning and end of a string.
 * 
 * @param string      String to modify. (Required)
 * @return Returns a string. 
 * @author Pete Ruckelshaus (pruckelshaus@gmail.com) 
 * @version 0, December 13, 2010 
 */
function stripOuterQuotes(string) {
    if (left(string, 1) EQ """") {
        string = right(string, len(string) -1);
    }
    if (right(string, 1) EQ """") {
        string = left(string, len(string) -1);
    }
    return string;
}