Strip Non-numeric characters from string function

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by RAD » Strip Non-numeric characters from string...

Strip Non-numeric characters from string function

Rate Topic

Display Mode

Topic Options

Author

Message

RAD

Posted Sunday, October 14, 2007 12:53 AM

SSC Journeyman

Group: General Forum Members
Last Login: Monday, March 25, 2013 10:14 AM
Points: 96, Visits: 56

Comments posted to this topic are about the item Strip Non-numeric characters from string function

Post #410574

Mazharuddin Ehsan

Posted Tuesday, August 11, 2009 4:26 AM

Old Hand

Group: General Forum Members
Last Login: 2 days ago @ 11:55 AM
Points: 378, Visits: 2,378

It worked fine for me for the task as follows. The Phone numbers in a table in two fields as shown in the below example was required to be changed as follows.

from +1 (250) 813 3241 to +1-250-813-3241

from 553599112 to +966-55-3599112

I took the below steps:
1. Used the function fnStripNonnumericChars to remove non numeric characters from the strings.
2. Updated the values as required.

Thanks for the marvellous creation.

Regards,

-----------------------------------------------------------
Time Is Money
Calculating the Number of Business Hours Passed since a Point of Time
Calculating the Number of Business Hours Passed Between Two Points of Time

Post #768473

« Prev Topic | Next Topic »

Permissions