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.
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.
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
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
Thanks DRay
