Home Forums Article Discussions Article Discussions by Author Discuss content posted by RAD Strip Non-numeric characters from string function RE: Strip Non-numeric characters from string function

  • 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]