User Tools

Site Tools


parse

Parse

Parse allows you to analyse and resolve data into its component parts.


Email

Input one or more email addresses to parse the mail box, local part, domain and top-level domain from them. E.g.

Email 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

parse.txt · Last modified: 2023/02/24 15:38 by hayden.law

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki