Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Strip Non-numeric characters from string function Expand / Collapse
Author
Message
Posted Sunday, October 14, 2007 12:53 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, August 25, 2014 2:30 PM
Points: 96, Visits: 75
Comments posted to this topic are about the item Strip Non-numeric characters from string function


Post #410574
Posted Tuesday, August 11, 2009 4:26 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Sunday, August 3, 2014 3:03 PM
Points: 378, Visits: 2,403
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 »

Add to briefcase

Permissions Expand / Collapse