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

  • Due to Holi celebrations, our team will have limited availability. While we’ll continue to monitor threads, responses may be slightly delayed. Normal operations will resume on Thursday, 5th March 2026.

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

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