How remove special characters and numbers from string

[Subbu]

My questions is i have dataset having multiple categories names like
1000 Bakeware (79)
1000 Bakeware
0900 GM/HBC (325)
i wanted to replace it as
Bakeware
Bakeware
GM/HBC

from above values.

How can we do in quicksight?

We perform this in Java: category.replaceAll(“^\d+|\d+$|\([0-9]+\)$”, “”)
Tried do somthing simlar in QS not able to do? Any help?

[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

[Subbu]

But i have more than 200 values in the category field. Which end up writing 200 replace statements. Is there any other way?

[Brett]

Hi @Subbu,
It’s been awhile since last communication on this thread, checking in to see if you had any remaining questions or if you were able to find a work around for your case?

If we do not hear back within the next 3 business days, I’ll go ahead and close out this topic.

Thank you!

[Brett]

Hi @Subbu,
Since we haven’t heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for relevant information that may be needed.

Thank you!