hello dear community. Hello dear friends form all over the planet
first of all - this is a great great forum. I like this place to share the ideas. It is so great to see such a supportive place - featuring the knowledge exchange!
today i have the following thing to discuss:
i want to separate the following data that are stored in one column of a calc-spreadsheet:
See the following data: You see that there are the following categories:_
steet,
postal-code,
town
All the data are stored in only one Colum; Well to be honest: i want to separate them into three colums
steet,
postal-code,
town
see the data: what can i do?
note - you see that there are commas inbetween the enties: and besides this we see that we have a postal-code with four digits: that is a good thing. Perhaps we can use this as a marker that helps us to separate the data?! Perhaps
See a data-sample! Here you can see some exceptions: eg. the town that has two words combinde with a "-" ... or somethims without any signs and characters...
see the following... as an example:
Max-Bader-Platz 1, 5620 Schwarzach im Pongau
Pestalozzistraße 4, 9990 Nussdorf-Debant
Schulstraße 4, 5162 Obertrum am See
But i guess that this means no problem... What do you think about this? I am very very interested to get your opinion!
i look forward to hear from you!
regards
see a snipped of the dataset - that is stored in one column -[b]Goal: [/b]i want to separate the datas into three collumns... :
Schulweg 6, 9871 Seeboden
Khevenhüllerstraße 45, 4861 Schörfling
Franz Xaver Rennstr.18, 6460 Imst
Schulstraße 4, 5162 Obertrum am See
Schulweg 6, 7432 Oberschützen
Pestalozzistraße 4, 9990 Nussdorf-Debant
Niederndorf bei Kufstein 53c, 6342 Niederndorf bei Kufstein
Hauptschulstraße 18, 2183 Neusiedl an der Zaya
Seeweg 14, 5202 Neumarkt am Wallersee
Europaplatz 1, 8820 Neumarkt in Steiermark
Schulstraße 7, 4212 Neumarkt im Mühlkreis
Schulstraße 20, 4720 Neumarkt im Hausruckkreis
Bahnhofstr. 10, 4872 Neukirchen an der Vöckla
Schulstraße 5b, 4780 Schärding
Reitbergstraße 2, 4311 Schwertberg
Europaplatz 1, 2320 Schwechat
Am Schulberg 5, 3931 Schweiggers
Waidach 8, 6130 Schwaz
Waidach 8, 6130 Schwaz
Max-Bader-Platz 1, 5620 Schwarzach im Pongau
Markt 29, 2662 Schwarzau im Gebirge
Hofsteigstraße 68, 6858 Schwarzach
Gmundner Straße 7, 4690 Schwanenstadt
Mühlfeldstraße 1, 4690 Schwanenstadt
Mainsdorferstraße 18, 8541 Schwanberg
Jakob Stemer-Weg 3, 6780 Schruns
Obere Umfahrungsstraße 16, 2432 Schwadorf bei Wien
Battloggstraße 54, 6780 Schruns
Schloss-Straße 19, 5020 Salzburg
Schillerplatz 2, 8280 Fürstenfeld
Erzherzog-Johann-Str. 400, 8970 Schladming
Schulgasse 261, 8811 Scheifling
i look forward to hear from you!!
regards