Removing Whitespace

[Guest_imported]

Does anyone know a CF tag that can remove all spaces from a line of text. For example...I have a value called "Bonita Bay" and I want to create a variable called "BonitaBay". How do i remove the space? Trim() does not work and RemoveChars will not work because I will not always know the position of the spaces . Any help is greatly appreciated.

 

[Silvano]

replace
Description: Returns string with occurrences of substring1 replaced with substring2 in a specified scope.

Syntax: replace(string, substring1, substring2 [, scope ])


substring1 = String to replace

substring2 = String that replaces occurrences of substring1

scope:
Defines how to complete the replace operation:
ONE replace only the first occurrence (default)
ALL replace all occurrences
Sylvano
dsylvano@hotmail.com

"every and each day when I learn something new is a small victory..."

 

[tleish]

Yes, so according to WWebSpider, the replace() function would work for what you want:

<CFSET myString = &quot;Bonita Bay&quot;>

<CFOUTPUT>
#Replace(myString, &quot; &quot;, &quot;&quot;, &quot;ALL&quot;)#
</CFOUTPUT>

or using the Char() function you can do it this way

<CFOUTPUT>
#Replace(myString, Chr(32), Chr(0), &quot;ALL&quot;)#
</CFOUTPUT> - tleish