+15
I have an address field with an address value of 1244 Deep Creek Road
I want to use the AttributeSplitter to separate this value in a List so it comes out like this
List{0} = 1244
List{1} = Deep Creek
List{2} = Road
My question:
What delimiter do I need to use that would split the 1244 into a separate list, but keep the "Deep Creek" together in List{1}? (Note that there are other streets with two names, I use "Deep Creek" as an example)
Best answer by daveatsafe
View original
+17
Hi @timh,
The AttributeSplitter is not sophisticated enough to do that type of separation, but the StringSearcher can do it it using Regular Expressions. Please try the StringSearcher with the following Settings:
The Regular expression to use is:
([0-9]+) ((?:\w+ )+)(\w+$)This will result in a list of three parts, with the first part being the street number, the last part being the last word, and the middle part being all the words between the other two.
The Regular Expressions are very powerful for this sort of splitting. There is great RegEx experimentation site that I use a lot at https://regexr.com/.
+30
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
