• Instructions to Ask a Question

    Click on the "Ask a Question" button and select the application for which you would like to ask questions.

    We have 5 different products namely - Pabbly Connect, Pabbly Subscription Billing, Pabbly Email Marketing, Pabbly Form Builder, Pabbly Email Verification.

    The turnaround time is 24 hrs (Business Hours - 10.00 AM to 6.00 PM IST, Except Saturday and Sunday). So your kind patience will be highly appreciated!

    🚀🚀Exclusive Discount Offer

    Just in case you're looking for any ongoing offers on Pabbly, you can check the one-time offers listed below. You just need to pay once and use the application forever -
     

    🔥 Pabbly Connect One Time Plan for $249 (🏆Lifetime Access) -  View offer 

    🔥 Pabbly Subscription Billing One Time Plan for $249 (🏆Lifetime Access) - View offer

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: 162
  • 1616902043279.png
    1616902043279.png
    52.8 KB · Views: 152

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