Why not just remove all spaces?
<CFSET Zip = REReplace(Zip,"[[:space:]]*","","ALL")>
=======================================================================
Raymond Camden, Principal Spectra Compliance Engineer for Macromedia
Email : [EMAIL PROTECTED]
ICQ UIN : 3679482
"My ally is the Force, and a powerful ally it is." - Yoda
> -----Original Message-----
> From: Rich Tretola [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, August 14, 2001 4:59 PM
> To: CF-Talk
> Subject: Remove spaces
>
>
> What function do I use to remove spaces in the middle of a string?
> I have a zipcode field where international users are leaving spaces in the
> zipcode which is causing errors in the shipping calculator.
> Thanks,
> Rich
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
