address-parsingfields-attributesfme
I am trying to split an attribute into its component pieces with FME.
Ex: 1707 WILLINGTON ST, PHILADELPHIA PA 19121
into: 1707 WILLINGTON ST, PHILADELPHIA, PA, and 19121
I am using the AttributeSplitter using a comma Delimiter and I get this:
1707 WILLINGTON ST and PHILADELPHIA PA 19121
How do I get the state – city – ZIP in three separate fields?
Try the Regular Expressions.
It has been some time since I've used FME, but I know a while back they had a Regular Expressions Transformer (or the AttributeSplitter had a Regular Expressions option).
You should be able to use a regular expression to match some form of pattern.
For example, the address:
123 abc st, Sesame Street
could be matched by the regular expression:
"$[0-9]+\w[a-zA-Z]+([st|dr|av])[\wa-zA-Z]+"
Which indicates the pattern as,
NOTE The parenthesis () tag that part of the pattern to an attribute that you can use later on in your FME script.
I hope this gives you some pointers. I'll follow this question to help further if required.
The Feature Merger transformer will allow you to Join by attributes
Using FME Desktop 2012 SP2 here
http://docs.safe.com/fme/pdf/FMEReadersWriters.pdf
Search 'Feature Merger'
A good blog post 'Joiner vs Feature Merger' by Mark Ireland
Best Answer
In FME 2015.1 (used here)
Use the SubStringExtractor
If you need to work out the number of characters for the substringExtractor then use the StringSearcher it will have matched_characters you can use this as parameter for extracting multiple addresses.