Strip Non-numeric characters from string function

• RAD

  SSChasing Mays

  Points: 646

  More actions

  October 14, 2007 at 12:53 am

  #182997

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

• Mohammad Mazharuddin Ehsan

  SSCarpal Tunnel

  Points: 4552

  More actions

  August 11, 2009 at 4:26 am

  #1037309

  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,

  -----------------------------------------------------------[font=Arial Black]Time Is Money[/font][font=Arial Narrow]Calculating the Number of Business Hours Passed since a Point of Time[/url][/font][font=Arial Narrow]Calculating the Number of Business Hours Passed Between Two Points of Time[/font]