How remove special characters and numbers from string

[Giridhar.Prabhu]

Hi @Subbu

I don’t think there is a regex or a replaceall kind of function available in QuickSight currently.

You may need to use a series of replace functions on your field to get what you need. See this thread for an example

Use the replace function with several strings

Hello here, Hope you’re fine! I’d like to replace the string names of an entire column. I know that the ‘replace’ can do it. My question is : how can I use the ‘replace’ function with several strings? Let’s take an example: My column contains '[1 - Paris] - [2 - Rome]. And I would like to replace them by '[1 - France] - [2 - Italy]. How can I do for this please ? Thank you very much ! Best, Paul