Knowledge Base Article

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
No CommentsBe the first to comment