We are trying to create a regex expression to add an underscore for space in a text and then remove some characters (for example a ?). We are able to create the regex express easily for the underscores, but how do we create the second expression to remove a character, like a question mark? We tried to use dot notation, but that seems to be unsupported. Here is our current code, assuming the title is: “What did you eat this morning?” This becomes, “what_did_you_eat_this_morning?”. But then how do we get rid of the question mark?
lower(regex_replace(field("title"), " ", "_"))
How do we add second regex to this regex, to get rid of characters, like a question mark (?)?