Hey guys I am trying to figure out how to clean up some data before using the google geocoder transformer. Is there anyway to drop text from my address column that is messing up the geocoder, i.e. apt or suite number?
I was thinking some kind of string splitter or something, but not sure. I have attached a screengrab below, thanks!
Best answer by itay
Hi @heidtmer one way would be to use something like this in the StringReplacer (naturally Attributes would be your address attribute and not empty as shown)
Hope this helps.
+16Hi @heidtmer one way would be to use something like this in the StringReplacer (naturally Attributes would be your address attribute and not empty as shown)
Hope this helps.
Awesome! I started playing around with it and changed the text to match column to ;.{1,} and it dropped everything after the semi colon. Can you explain what this syntax means?
thank you!
+16Awesome! I started playing around with it and changed the text to match column to ;.{1,} and it dropped everything after the semi colon. Can you explain what this syntax means?
thank you!
Before the 2016 with the regular expression window in the transformers I used (and still do) http://rubular.com/ for checking my syntax
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
