Forum Discussion

FaustoLiceaga's avatar
FaustoLiceaga
Qrew Trainee
2 days ago

RegEx replace

Hello, 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!

formulas

3 Replies

Sort By
  • Mez's avatar
    Mez
    Qrew Assistant Captain
    40 minutes ago

    @EstherLaVielle, any thoughts on who to ping on this?

  • FaustoLiceaga's avatar
    FaustoLiceaga
    Qrew Trainee
    6 hours ago

    Answer 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. 

  • Mez's avatar
    Mez
    Qrew Assistant Captain
    7 hours ago

    Image 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.