Regex, different behaviour

I was using EXTRACT with Regex to extract a word between (). As I was unable to get it, I went to Tableau Desktop and used REGEXP_EXTRACT([Vehicle ID],“((.*))”) [vehicle ID is the field to parse]. I got what I was looking for, but as always, I prefer to use EDT. Tried to use EXTRACT with regex, using the same regex expression, but it didn’t work, I don’t know why, any idea?

If the expression you are trying to extract contains () chars, you have to ‘escape’ them with a \. This is standard regex behavior.

For example you can use[^(]*\(([^)]*)\).* to turn:



There may be a simpler expression. I’m not an expert in regex.