Filter cells with house numbers

[JamesDB]

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.

[bensilv]

You're most welcome - remember to mark the messaged as solved if that's all 🙂