reReplace

[jesse1]

I am uploading a csv file and want to limit the fields to letter numbers and spaces. I am using the listfix function to replace empty csv fields with Null. The code below does not seem to work because it does not remove ,'s and .'s

<cfset newI = #listgetAt('#index#',1, ',')#>
<cfif newI neq 'Null'><cfset newi=#REReplace(newi, "[^A-Za-z0-9 ]", "", "ALL")#></cfif>
<cfqueryparam cfsqltype="CF_SQL_VARCHAR" value="#newi#">,

 

[TimeTraveler]

1. Why bother testing for "null"? Even if [blue][tt]newI[/tt][/blue] equals "null" the result of the replace appears the same.

2. For non-numeric values, I found it best to quote the [green][tt]REreplace[/tt][/green] function. If not expecting single or double-quotes in [blue][tt]newI[/tt][/blue], try:

<CFSET newI="#REreplace('#newI#', '[^A-Za-z0-9]', '', 'All')#">

-TT

 

[cfSearching]

For non-numeric values, I found it best to quote the REreplace function

Why?

The string "null" is probably used as a replacement for empty elements. Prior to CF8, all list functions ignore empty elements. That can create problems if empty elements are significant (ie with a csv file).

----------------------------------

http://cfsearching.blogspot.com/