I have a file with about 1 million addresses. I am trying to filter for addresses that do not contain street numbers. I am easily able to group the streets that are words (ex. cherry street) by sorting the address column a-z but I am having a much harder time with numbered streets (ex. 13th street). I can filter these streets one by one using 'begins with' but that would take forever. I would like to be able to find a query that would let me filter for first word begins with a number (1-0) and ends with 'st' or 'th'. That would give me all of the address I am looking for at once.
Any other suggestions are welcome