Showing results for 
Search instead for 
Did you mean: 
Community Team Member
Community Team Member
SQL Code to clean strings to alphanumeric characters only. Useful for cleaning survey data and data which may contain special/foreign characters

regexp_replace(lower([text]), '[^a-zA-Z ]', ' ') ,

'( ){1,}', ' ')
Version history
Last update:
‎03-02-2023 08:58 AM
Updated by:
Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Developers Group:

Product Feedback Forum:

Need additional support?:

Submit a Support Request

The Legal Stuff

Have a question about the Sisense Community?

Email [email protected]

Share this page: