Splitting address strings

Hi,

 

 

have a look at the responses here.

 

 

David

I agree with you that I would like to know how to difference characters and numbers.

^(\\d*|[\\da-zA-Z\\s]*,)\\s([a-zA-Z\\s]*|[a-zA-Z\\s]*,\\s[a-zA-Z\\s]*),\\s([A-Z\\s]*),\\s([A-Z0-9\\s]*)$

 

takes care of the first three examples.

 

U then need to expose matched parts 0-4 (5 reports or "captures") if u use the searcher transformer.

 

 

If u use creator u can do

 

[regepx -inline {^(\\d*|[\\da-zA-Z\\s]*,)\\s([a-zA-Z\\s]*|[a-zA-Z\\s]*,\\s[a-zA-Z\\s]*),\\s([A-Z\\s]*),\\s([A-Z0-9\\s]*)$ yourvariable} ..etc. to capture the parts.

 

Then u could use listindexer to grab every captured part (indexes 0,2 etc.)

 

 

Or use tcl caller and create FME_attributes form captures.

 

 

 

You can make similar expressions for

 

 

for the first 3 examples

 

 

The fourth example is all letters and a zip. U can get the parts from the expression i made.

 

 

\\d = digits \\w wordcharacters etc. \\D non digit, \\W non wordcharacters etc.

 

there are lots of very good tcl sites around.

Hi,

 

 

I don't know exact rule of address representations, but there seems to be this rule as long as seeing your examples. 1) Address elements are separated by commas. 2) The first element is "house number (digits) <space> street name" or "house name" (starting with non-digit). 3) Only if the first element is "house name", the second element is "street name". 4) The last element is always "post code". 5) "town name" consists of other one or more element(s).   If it's correct, these steps might help you. 1) Determine the first element is which of "hose number <space> street name" and "house name" with a Tester. address  Matches Regex  ^[0-9]+\\s.+$   2) If the string starts with digits (i.e. house number), insert a comma between "house number" and "street name" using a StringReplacer. Otherwise do nothing. Text to Find: ^([0-9]+)(.+)$ Replacement Text: \\1,\\2 Use Regular Expressions: yes   3) Move the last element (i.e. post code) to head of the string using another StringReplacer. Text to Find: ^(.+),([^,]+)$ Replacement Text: \\2,\\1 Use Regular Expressions: yes   4) Split the srting into 4 elements with a StringSearcher. Regular Expression: ^([^,]+),([^,]+),([^,]+),(.+)$   Every output feature will have a list attribute (named "_matched_parts" by default) which contains these elements. _matched_parts{0} = post code _matched_parts{1} = house number or house name _matched_parts{2} = street name _matched_parts{3} = town name   Then rename and trim them, if necessary.

 

Takashi