Regular Expressions

[fredshepper]

Does anybody know if regex is an option in Sisense custom tables? Can't find any documentation and it's not listed in available functions. I know I can use it in MySQL tables, but having it in custom tables will be very useful.

We are using Sisense Cloud Services.

[DRay]

Hello @fredshepper,

Thank you for reaching out. I was only able to find this blog post that mentions Regex, https://www.sisense.com/blog/string-parsing-in-sql/. Does that help? If not, please let me know and I can dig into this further.

Thank you.

[fredshepper]

Hi @DRay,

Thanks for your reply. The methods mentioned don't work unfortunately.

We are not sure regular expressions are even a feature of custom tables, but wanted to check here first before suggesting it as a feature.

Best Wishes,

Fred

[DRay]

Hi @fredshepper,

Understood, thank you for the clarification. Regex is not currently supported for custom table. As a work-around, you could use a custom import query. https://docs.sisense.com/main/SisenseLinux/importing-data-with-custom-queries.htm

[fredshepper]

Thanks @DRay