Icon

UK postcode extraction

UK postcode extraction

UK postcode extraction

Workflow demonstrating use of Regex Split to extract UK postcode from an address field

UK Postcode matching regex:.*([A-Z]{2}[0-9]{1,2}[A-Z]*\s*[0-9][A-Z]{2}).*|.*([A-Z][0-9][A-Z]\s*[0-9][A-Z]{2}).*|.*([A-Z][0-9]{1,2}\s*[0-9][A-Z]{2}).*This contains 3 "capture groups" (.... ) [A-Z]{2}[0-9]{1,2}[A-Z]*\s*[0-9][A-Z]{2} -> XX9 9XX or XX99 9XX or XX9X 9XX -> column split_0[A-Z][0-9][A-Z]\s*[0-9][A-Z]{2} -> X9X 9XX -> column split_1[A-Z][0-9]{1,2}\s*[0-9][A-Z]{2} -> X9 9XX or X99 9XX -> column split_2 Postcode matchSample Address DataMerge split0 and split1Merge split 0 and split2Postcode Regex Split Excel Reader Column Merger Column Merger Column Rename UK Postcode matching regex:.*([A-Z]{2}[0-9]{1,2}[A-Z]*\s*[0-9][A-Z]{2}).*|.*([A-Z][0-9][A-Z]\s*[0-9][A-Z]{2}).*|.*([A-Z][0-9]{1,2}\s*[0-9][A-Z]{2}).*This contains 3 "capture groups" (.... ) [A-Z]{2}[0-9]{1,2}[A-Z]*\s*[0-9][A-Z]{2} -> XX9 9XX or XX99 9XX or XX9X 9XX -> column split_0[A-Z][0-9][A-Z]\s*[0-9][A-Z]{2} -> X9X 9XX -> column split_1[A-Z][0-9]{1,2}\s*[0-9][A-Z]{2} -> X9 9XX or X99 9XX -> column split_2 Postcode matchSample Address DataMerge split0 and split1Merge split 0 and split2Postcode Regex Split Excel Reader Column Merger Column Merger Column Rename

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: brian
Created at: 2022-01-28
On NodePit since: 2022-01-29
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!