Try:
<CFSET Output = ReReplace(Input, "[^0-9]", "", "ALL")>
This actually kills any non-numeric character.
At 12:17 AM +1000 7/22/00, AustralianAccommodation.com Pty. Ltd. wrote:
>I need to eliminate the blank spaces between numbers in phone numbers so
>that 07 987 635 can be converted to 07987635
>
>the code needs to read the value in the phone variable from the database
>table and then remove the blank spaces as indicated above
>
>your assistance in this matter would be appreciated
>
>
>Kind Regards
>
>Claude Raiola (Director)
>AustralianAccommodation.com Pty. Ltd.
>Website: www.AustralianAccommodation.com
>Email: [EMAIL PROTECTED]
>
>------------------------------------------------------------------------------
>Archives: http://www.mail-archive.com/[email protected]/
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_tal
>k or send a message to [EMAIL PROTECTED] with
>'unsubscribe' in the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
