Strip Non-numeric characters from string function

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

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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply