Query errors in Data Analyzer and Analytics

[bbuchler]

Hi, 

We are trying to use the regexp_replace feature in the data analyzer and are getting an error. The first regexp works as expected. 

Query: select
u.customproperty59 regexp '%|\[|#|!|\*|&|\(|\)|~|`|'' | { | \ ^ | } | \ \ | \ / | \ ? | > | < |,|;|: | "|\+|=|]|ä|ë|ö|ü', regexp_replace(u.customproperty59,'%|\[|#|!|\*|&|\(|\)|~|`|'' | { | \ ^ | } | \ \ | \ / | \ ? | > | < |,|;|: | "|\+|=|]|ä|ë|ö|ü','') as t1,u.username, u.email, u.customproperty59
from users u
where u.username=99990290

Error: 

I have also tried running directly in a standard SQL analytic and am getting a different error. 

Error: 

Thanks,

Brandon 

[rushikeshvartak · Accepted solution]

regexp_replace is not supported. use saviynt database functions

SELECT
u.customproperty59,
FN_EIC_REPLACE(customproperty59,null)s,
u.username,
u.email
FROM
users u
WHERE
u.username = 137658;

https://docs.saviyntcloud.com/bundle/EIC-Admin-v2022x/page/Content/Chapter02-Identity-Repository/Dat...

[bbuchler]

@rushikeshvartak  This worked thank you!