How to extract Phone Number from the user submitted numbers.

Status
Not open for further replies.
Lot of people submit their numbers in different formats like:

1) 9876543211
2) +919876543211
3) 919876543211
4) 91-9876543211
5) 09876543211



Step 1: Extract Number only from the string. This will eliminate dashes and blank spaces from the user submitted number.

1616902185283.png




Step 2: Map the result from the Extract Number step to pick 10 values from the right.

If you always want the right number to be captured. You can capture the last 10 numbers counted from the RIGHT. You can extract the numbers according to your need.

1616902337797.png
 

Attachments

  • 1616901958431.png
    1616901958431.png
    487.4 KB · Views: 37
  • 1616902043279.png
    1616902043279.png
    52.8 KB · Views: 38

Shlomo Z

Member
These are really useful tips!
regarding tip #2:
If I choose to Extract 10 from the right, but there are only 9 numbers in total, would that mess up the entire formula, or would the formula simply spit out the 9 numbers?
 
Status
Not open for further replies.
Top