replace special chars in string

Reply
Highlighted
Yellow Belt

replace special chars in string

I tried to specify /[^a-zA-Z0-9 ]/g and /[&\/\\#,+()$~%.'":*?<>{}]/g  in replace tile both did not work. 

 

However /s to remove space worked....

Tags (1)

Accepted Solutions
Highlighted
Major Red Belt

Hi @Yogesh 

 

How did your regular expressions not work? Is there some anonymized data you can share? Have you played around with a regular expression editor like https://regex101.com/ ? Can you post a screen shot of your tile with the regular expressions in it?



**Was this post helpful? Click the heart icon**

**Did this solve your problem? Accept it as a solution!**

View solution in original post


All Replies
Highlighted
Major Red Belt

Hi @Yogesh 

 

How did your regular expressions not work? Is there some anonymized data you can share? Have you played around with a regular expression editor like https://regex101.com/ ? Can you post a screen shot of your tile with the regular expressions in it?



**Was this post helpful? Click the heart icon**

**Did this solve your problem? Accept it as a solution!**

View solution in original post

Highlighted
Yellow Belt

Hello @GrantSmith , Thanks for the reply. I used the site regex101.com and found that /g at the end was the issue. Without the /g the regex replace works.

Announcements
Domopalooza 2021 Call for Presenters: We want to hear how Domo is revolutionizing the way you do business!

Click here to submit your story.