Standardize US phone numbers with multiple format options and validation
## Workflow Overview:
This n8n workflow template takes a US phone number as input, validates it, and returns it in multiple standard formats, including handling extensions. It's designed to streamline the process of standardizing phone number data within your automations.
## How it Works:
**Input:** Accepts a phone number string as input. This number can be in various common formats (e.g., `(555) 123-4567`, `555.123.4567`, `+15551234567`, `5551234567x890`).
**Formatting Removal:** Strips all non-numeric characters to isolate the core number and any potential extension.
**Validation:**
- **Country Code Check:** Verifies if the number starts with the US country code (`+1` or `1`) or assumes US if no country code is present and the length is correct.
- **Length Check:** Ensures the main number component consists of exactly 10 digits after stripping formatting and the country code.
**Output Generation (if valid):** If the number passes validation, the workflow outputs the phone number in several standardized formats:
- **Number Only:** 5551234567
- **E.164 Standard:** +15551234567
- **National Standard:** (555) 123-4567
- **Full National Standard:** 1 (555) 123-4567
- **International Standard:** 00-1-555-123-4567
**Extension Handling:** If an extension is detected in the input, it is separated and provided as:
- **Extension (Number):** 890
- **Extension (String):** "890"
**Use Cases:**
- Cleaning and standardizing phone number data in CRM systems.
- Formatting numbers before sending SMS messages via APIs.
- Validating user input from forms.
- Ensuring consistent phone number representation across different applications.
