• Instructions to Ask a Question

    For any assistance, please click the "Ask a Question" button and select the Pabbly product for which you require support.

    We offer seven comprehensive applications designed to help you efficiently manage and grow your business:

    Our support team endeavors to respond within 24 business hours (Monday to Friday, 10:00 AM to 6:00 PM IST). We appreciate your understanding and patience.

    🚀 Exclusive Lifetime Offers 🚀

    We invite you to take advantage of our special one-time payment plans, providing lifetime access to select applications:

    • 🔥 Pabbly Connect — Lifetime Access for $249View Offer
    • 🔥 Pabbly Subscription Billing — Lifetime Access for $249View Offer
    • 🔥 Pabbly Chatflow — Lifetime Access for $249View Offer

    Make a one-time investment and enjoy the advantages of robust business management tools for years to come.

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

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