How to make regex expression of a street address?

Hi team, I am working on a scenario where I want to filter street address like this:

1234 abc line abc beach

i want to delete all those street addresses other than the above mentioned one for example

123 abc road abc beach FL 12345-1234

Any help in this regard will be highly appreciated
Thank you

Correct me if am wrong .

You need only this kinds of address and remove all the address which is not same as above

Regards
Gokul

is this street address going to be static or dynamic?

yes I want to remove addresses which contain 5 digits, like 12345 or only digits in the street column

its an example it will be dynamic

Try with this regex

Regards
Gokul

1 Like

I hope the above regex will get only the address you need remaining will not be matched in your original input

Try and let us know

1 Like

will let you know if it works

@Gokul001
thank you for your quick response, there is much variation in the data: let me add a description the address contain 3 digits or 4 digits and in some cases there are only digits in the street column. I want to delete addresses which contains only digits like 1234 or 123456 or any combination of digits and street addresses that contain alphanumeric address with 5 digits