How to pass special characters on Analytics query?

[Miko]

Hello Saviynt,

Can you please advise how to use special characters on analytics report query?

select customproperty15 from users where customproperty15 REGEXP '^abc[0-9]+$'

We want to use regex and it is displaying error.

Thanks,

[rushikeshvartak]

$ keyword is not allowed. 
workaround

• write simple query without $
• export report
• update $ keyword in zip
• import report again 

[Miko]

Hello,

with tested it with \$ and on analytic query report and it works.

Regards,

Michael