Phone Number Formatter

Go to Product

This node parses information about phone numbers given in arbitrary string formats and transforms them into a canonical format.

Options

Input
The column which contains the phone numbers.
Default Region
The default region to assume if a phone number does not include region information.
Format
The format into which to transform the number:
  • E164: international format with no further formatting applied, e.g. “+41446681800”.
  • INTERNATIONAL: ITU-T Recommendation E.123 with country prefix, e.g. “+41 44 668 1800”
  • NATIONAL: ITU-T Recommendation without international country prefix, e.g. “044 668 1800”
  • RFC3966: is as per INTERNATIONAL format, but with all spaces and other separating symbols replaced with a hyphen, and with any phone number extension appended with “;ext=”. It also will have a prefix of “tel:” added, e.g. “tel:+41-44-668-1800”.
Output Column Prefix
Prefix to append to the added column names.

Input Ports

Icon
Table which contains a string column with phone numbers.

Output Ports

Icon
Table with appended columns:
  • Valid Number: Boolean flag which indicates if the given number is “valid”. This is determined checking the canonicalized number using patterns – it will not tell you if the number is actually in use.
  • Formatted: The phone number formatted according to the selected format.
  • Region: The region of the phone number, e.g. “Munich, Germany”.
  • Country: The ISO 3166-1 alpha-2 country code for the phone number, e.g. “DE”.
  • Number Type: Type of the phone number (“FIXED_LINE”, “MOBILE”, “FIXED_LINE_OR_MOBILE”, “TOLL_FREE”, “SHARED_COST”, “VOIP”, “PERSONAL_NUMBER”, “PAGER”, “UAN”, “VOICEMAIL”, or “UNKNOWN”)

Popular Predecessors

  • No recommendations found

Popular Successors

  • No recommendations found

Views

This node has no views

Workflows

  • No workflows found

Links

Developers

You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.

Go to Product

Installation

To use this node in KNIME, install the extension Palladian for KNIME from the below update site following our NodePit Product and Node Installation Guide:

v5.2

A zipped version of the software site can be downloaded here.

Plugin provider: palladian.ws
Plugin version: 2.10.0.202403182149
On NodePit since: 2023-12-06
Last update: 2024-04-30
Tags: Streamable
KNIME versions: Since v4.5
NodePit Exclusive Only available on NodePit

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!