Address parcing

David is right, this can be simple or super hard, it just depends on your requirments. Typically managing your address rules with FME is no problem at all, it gets tricky when you get addresses entered that do not conform to the rules and in those instances you almost have to prodict what the issues might be. For example you may have a few zip codes entered into your Building Number field, in these cases you need to be able to look for something that looks like a zip code (using a regular expression) then put the matched values in the right field, you don't just want to throw data away that is in the wrong field. This type of thing is possible with FME as is carrying out validation to check if that zip code is actually valid against a list of valid codes... etc etc etc!

Tricky. It sounds like you might have to treat each input differently, you are right, so quite a bit of effort and no 1 transformer will give you the silver bullet. I think the best you can do is strip out the county submissions closest to your target schema and deal with those for some quick wins. Then look at the others and for each field decide which fields 'map' yo which fields in your target schema. If you take this approach then certainly the SchemaMapper will be of some use, though you might find that mapping your data to a conflated intermediate schema might be an interesting starting point before you do the cleanse and parsing to the final schema. Best of luck.