Removing punctuation from voicenumbers
1. If you want to remove all the hyphens then use: Update clients set voicephone=replace(voicephone,’-‘,’’) 2. If you want to replace comma’s in the voicephone field Update clients set voicephone=replace(voicephone,’,‘,’’) 3. If you want to replace space’s in the voicephone field Update clients set voicephone=replace(voicephone,’ ‘,’’) 4. If you want to replace round braces in the voicephone field Update clients set voicephone=replace(voicephone,’(‘,’’) Update clients set voicephone=replace(voicephone,’)’,’’)Related Articles
- Enabling and Using Alternate Number Dialing in SPD Pro
- List Won't Import (ListMaker Pro)
- Scrubbing Lists Against Each Other
Attachments
No attachments were found.Visitor Comments
No visitor comments posted. Post a commentPost Comment for "Removing punctuation from voicenumbers"
To post a comment for this article, simply complete the form below. Fields marked with an asterisk are required.Article Details
Last Updated
20th of August, 2008
