You can translate the question and the replies:

regexp no argument for repetition operator: ?'

I have the following regexp function: ` SELECT TRIM(REGEXP(REGEXP(REGEXP(CUSTOMER_NAME_COLUMN, '[,\.]\s*', ' '), '\s+\w(?=\s+|$)', ' '), '\s{2,}', ' ')) AS CUSTOMER_NAME_CLEAN FROM TABLE ` When trying to run this, I get the following error: [JDBC ROUTE] [ERROR] Received exception with message 'Invalid regular expression: '\s+\w(?=\s+|$)', no argument for repetition operator: ?' Does Denodo's REGEXP not have positive lookahead? Any ideas why this is happening?
user
27-04-2021 13:32:21 -0400

1 Answer

Hi, I am able to use the RegEx you have provided as written over a few JDBC sources in my environment. However, the exact syntax poses an issue for Snowflake, as it makes use of a ‘non-capturing group’ which is known to be unsupported at this time. See [related Snowflake ticket](https://community.snowflake.com/s/question/0D50Z00007ENLKsSAP/expanded-support-for-regular-expressions-regex) for some potential workarounds or re-writes. I would direct subsequent questions around this issue to [Snowflake support](https://community.snowflake.com/s/#SUPPORT). Hope this helps!
Denodo Team
28-04-2021 17:36:11 -0400
You must sign in to add an answer. If you do not have an account, you can register here