Hello All,
I am into Knime for about a week now, so looking still at the very basics yet and trying to get my head around how it works. So far quite pleased...
I have a task I need to do and ask myself if Knime is the right tool for this.
I have a list of adress data (ca. 5000 lines) which I need to split.
The returned adress from the source file is a single (SQL?!) string which is very inconsistant as it is from various countries-so no chance to use e.g split by position or blank/delimiter.
I need to split it always to
Street name
House number
Post code
Town
Country.
Unfortunately the positions and lenghts of the elements are always different, as are the formats like e.g. in one case "15 test-road" as e.g. in France/UK and then "testroad 15" in e.g. Germany (not to speak about different post code lenghts and formats).Also an element can consist of a different number of words, e.g. "Teststraat" vs. "Rue de Test"
I have found smth about the steps to do test mining, but much of it is still chinese to me and I struggle what values to set in the nodes, e.g. for the tagging.
SAMPLE DATA:
10 FLEET PLACE LONDON EC4M 7RB United Kingdom
KAPELANIELAAN 8 9140 TEMSE Belgium
VIA SILVIO PELLICO N 6/8 20089 ROZZANO MI Italy
VIA BRIGATA REGGIO 27 42124 REGGIO NELL'EMILIA RE Italy
PORTE DES BÂTISSEURS(EST) 20 7730 ESTAIMPUIS Belgium
BOOMSESTEENWEG 957 2610 ANTWERPEN Belgium
Prumyslová 1428/10 PRAHA 15 - HOSTIVAR 102 00 PRAHA 102 Czech Republic
P O BOX 79 SWALLOWDALE LANE HEMEL HEMPSTEAD HERTS HP2 7HA United Kingdom
MERWEDEWEG 00007 3336LG ZWIJNDRECHT The Netherlands
Elektrárenská 4 83104 Bratislava 3 - Nové Mesto Slovakia
VIA GALILEO GALILEI 40 20092 CINISELLO BALSAMO MI Italy
2 MIDLAND WAY BARLBOROUGH LINKS DERBYSHIRE S43 4XA United KIngdom
VIA ALBERTO BERGAMINI 50 00159 ROMA RM United Kingdom
VIA CAMILLO OLIVETTI 2 20864 AGRATE BRIANZA MB Italy
VIA CARPINETANA NORD SNC 00034 COLLEFERRO RM Italy
VIA GIUSEPPE VERDI 0004 20090 ASSAGO MI Italy
VIA DESENZANO 7 20146 MILANO MI Italy
101 RUE BONGARDE 92230 GENNEVILLIERS France
PARC D'AFFAIRES ROOSEVELT 9 RUE DE LA PERLERIE 69120 VAULX EN VELIN Italy
Areal EDWARDS 101 RUE BONGARDE 92230 GENNEVILLIERS France
Any help or tips are welcome :-)
Jürgen