Straßennamen und Hausnummer aus einer Spalte extrahieren

Hallo dswup,

kann mann ziemlich einfach in FME schaffen… in half english and german !

1. Reader/featureReader as text format (*.txt)
2. AttributeSplitter
   1. attribute to split = text_line_data
   2. and the delimiter is  spacedashspace 

      

       

   3. not to drop empty parts
3. Place an AttributeManager and expose the 2 list indexes. You will then set the value to that of the _list from the last transformer 

   

   

    

4. From here we need to clean the PostAnzahl (if that's what it is) to keep the first 4 characters

5. 

   To use Strassenamen and extract the HausNummer could use StringSearcher using a regular expression. Research these on the web or use the Assist tool 

   1. \b\d{1,4}[a-zA-Z]?(-\d{1,4}[a-zA-Z]?)?\b

   2. 

       

6. A stringReplacer does the opposite of searcher and will remove the number from Strassenamen
7. There is however a number of irregularities in these address, so perhaps another AttributeSplitter based on the decimal, then perform the same as above

https://support.safe.com/hc/en-us/articles/25407744438797-Regular-Expressions-and-FME

Viel Glueck !