Knowledge Base DocsChevronRightIconCDTChevronRightIconClean 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 charactersregexp_replace( regexp_replace(lower([text]), '[^a-zA-Z ]', ' ') , '( ){1,}', ' ')ByintapiuserPosted 3 years ago 0 commentsComment Newest