Change 1st letter of each word in a string to CAPS

[dv8er88]

I have a database and a lot of the info is all lower case like (8975 nw 5th ave, boca raton. fl).

How can I loop through and change each of the first letters in a word to Caps? (8975 Nw 5th Ave, Boca Raton. Fl).

Thanks

 

[FALCONSEYE]

<cfset myAddress = '8975 nw 5th ave, boca raton. fl'>
<cfset myNewAddress = ''>
<cfloop index="i" list ="#myAddress#" delimiters=" ">
<cfset myUCase = Left(UCase("#i#" ), 1) & Right(#i#, Len(#i#)-1)>
<cfset myNewAddress = myNewAddress & myUCase & ' '>
</cfloop>
<cfoutput>#myNewAddress#</cfoutput>


hope it helps...

http://www.jetansolutions.com

 

[GUJUm0deL]

dv8er88, FALCONSEYE's example will do the trick. But if you want to use this feature over and over again on different pages and whatnot, consider thus UDF instead

http://www.cflib.org/udf.cfm?ID=9

____________________________________
Just Imagine.

http://www.imajinarts.com

 

[imstillatwork]

CSS...

text-transform: capitalize

Kevin

http://www.lot-o-nothin.com/cfml/

Phase 1: Read the CFML Reference
Phase 2: ???
Phase 3: Profit!