Clean Text To Alphanumeric Characters Only

[intapiuser]

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,}', ' ')