Icon

Parse Telephone Number Ranges

OriginalStringSplit subscriberranges using -Extract area code,exchange code,subscriber number rangesArea code and exchange code to top;subscriber numbers to bottomHow many new rows?$To$-$From$+1Create new rowsGroup by FromLag counter columnby 1Generate next numberin sequenceJoin area code,exchange code,subscriber numbersReplace spacewith dashTable Creator Counter Generation Cell Splitter Regex Extractor Row Splitter Math Formula Column Rename One Row to Many Group Loop Start Lag Column Column Filter Column Expressions Column Filter Loop End String Manipulation String Manipulation Column Filter Table Rowto Variable OriginalStringSplit subscriberranges using -Extract area code,exchange code,subscriber number rangesArea code and exchange code to top;subscriber numbers to bottomHow many new rows?$To$-$From$+1Create new rowsGroup by FromLag counter columnby 1Generate next numberin sequenceJoin area code,exchange code,subscriber numbersReplace spacewith dashTable Creator Counter Generation Cell Splitter Regex Extractor Row Splitter Math Formula Column Rename One Row to Many Group Loop Start Lag Column Column Filter Column Expressions Column Filter Loop End String Manipulation String Manipulation Column Filter Table Rowto Variable

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: Loic
Created at: 2022-01-19
On NodePit since: 2022-01-20
Last update: 2024-04-27
Created with KNIME version: v4.5.0

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

Try NodePit Runner!