Hi folks,
My query relates to house numbers and how to filter them out when they also have a letter or special character.
In the screen grab attached I want to filter out records 2 to 4 so that I can then concatenate the remaining records so that they form 1 address line e.g. 1-2 Wesley Gate or 10a The Market or 11-12 Critchett Terrace, so that they look similar to 10 Union Court.
There are some records, such as screen grab 2 where the order is different e.g. building 4.
I've have tried numerous things but the closest I've got to cracking it is:
if REGEX_Match([Building Name], ".*\d.*\w")
then [Building Name] + " " + [Dependent Thoroughfare & Descriptor]
else Null()
endif
but it is concatenting records that I don't want to such as those in screen grab 3.
Any help would be greatly appreciated.
Solved! Go to Solution.
You're most welcome - remember to mark the messaged as solved if that's all 🙂