Table of Contents
Parse
Parse allows you to analyse and resolve data into its component parts.
Input one or more email addresses to parse the mail box, local part, domain and top-level domain from them. E.g.
| Mailbox | Local Part | Domain | TLD | |
|---|---|---|---|---|
| test@example.com | test@example.com | test | example.com | com |
Phone Number
Parse the country code, extension, national number and number type from a phone number via inputting a phone number and a country identifier. E.g.
Input
| Phone Number | Country Identifier - ISO 2 |
|---|---|
| +447511111111 | GB |
| 02392111111 | GB |
| 0344 800 2400 | GB |
Output
| Country Code | Extension | National Number | Number Type |
|---|---|---|---|
| 44 | 7511111111 | MOBILE | |
| 44 | 2392111111 | FIXED_LINE | |
| 44 | 3448002400 | UAN |
URL Address
Parse the host, scheme, host name type, port, path and query from one or more URL's. E.g.
| URL Address | Host | Scheme | Host Name Type | Path and Query | Port |
|---|---|---|---|---|---|
| https://www.microsoft.com/home | www.microsoft.com | https | Dns | /home | 443 |
| http://www.google.com/example?value=1 | www.google.com | http | Dns | /example?value=1 | 80 |
Custom Functions
DQ.PARSE_PHONE_NUMBER
The DQ.PARSE_PHONE_NUMBER function parses phone number details.
Parameters:
phoneNumber (string), phone number to be parsed
country (string), country identifier, preferred format is ISO2, otherwise the service will attempt to derive country from the input
spillDown (boolean), if true results will spill down instead of right
returns (string[][]), returns spill of country code, extension, national number, number type
DQ.PARSE_EMAIL
The DQ.PARSE_EMAIL function parses email details.
Parameters:
email (string), email to be parsed
spillDown (boolean), if true results will spill down instead of right
returns (string[][]), returns spill of mailbox, local part, domain, tld
DQ.PARSE_URL
The DQ.PARSE_URL function parses URL details.
Parameters:
url (string), URL to be parsed
spillDown (boolean), if true results will spill down instead of right
returns (string[][]), returns spill of host, scheme, host name type, path and query, port