Clean Text To Alphanumeric Characters Only
SQL Code to clean strings to alphanumeric characters only. Useful for cleaning survey data and data which may contain special/foreign characters
regexp_replace(
regexp_replace(lower([text]), '[^a-zA-Z ]', ' ') ,
'( ){1,}', ' ')Updated 03-02-2023
