Parse

Created by Dariusz Szczendzina, Modified on Wed, 12 Jul, 2023 at 11:09 AM by Dariusz Szczendzina

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.

EmailMailboxLocal PartDomainTLD
test@example.comtest@example.comtestexample.comcom

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 NumberCountry Identifier - ISO 2
+447511111111GB
02392111111GB
0344 800 2400GB

Output

Country CodeExtensionNational NumberNumber Type
447511111111MOBILE
442392111111FIXED_LINE
443448002400UAN

URL Address

Parse the host, scheme, host name type, port, path and query from one or more URL's. E.g.

URL AddressHostSchemeHost Name TypePath and QueryPort
https://www.microsoft.com/homewww.microsoft.comhttpsDns/home443
http://www.google.com/example?value=1www.google.comhttpDns/example?value=180

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

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons

Feedback sent

We appreciate your effort and will try to fix the article