I am trying to clean up an address table with thousands of records.
REGEXP_SUBSTR(ADDR_LINE1, '^[^@]+ ')
REGEXP_SUBSTR(ADDR_LINE1, '^[^&]+ ')
I've been able to clean up the addresses that had an @ or & in the middle of addressline1, delete the character and anything after.
Now I need to go through it and do the same for Double spaces ' ' or certain keywords. like
This will allow our software to properly geocode these addresses.
the trick with the previous is that unlike @ and &, i do not want to delete the words ST (just what comes afterwords)
I do however want to delete the words BETWEEN and anything that comes afterwords.
thank you for reading