+2Hello, I'm trying to implement a regex replace to remove all special characters from a field. However, it's not working as expected. The result still shows certain special characters and line breaks. Here is an example.
Could you provide the regex pattern you're using and the example text? This will help me understand the issue better and offer a more precise solution.
RegexReplace([field_name],"[^A-Za-z0-9 ]", "")
If you have any ideas on how I can refactor my formula, I'd love to hear them!
+7Image is raw text input on left, regex result on right?
The regex looks good to exclude alphanumeric including space from removal, replacing with nothing. It's removing nearly everything except a few more characters.
Have you tried one of the online regex parsers on your raw text input?
Maybe this is an implementation question for quickbase.
+2Answer your questions:
1)Yes
2)I modifed to include the space in the raw text for the result.
3)Yes I share the SS for regex101.com and the results works.
4) I submit a support case to QB but I don't know if can elevate for an implemetation case.
5) They send me another implementation for this formula:
And I showed them that it isn't working as they claimed.
so I waiting a follow up.
+7@EstherLaVielle, any thoughts on who to ping on this?
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
