Regular Expressions

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.

Fred Ortmann

Posted 1 year ago·Last reply 1 year ago

4 comments

Fred Ortmann

OP1 year ago

Thanks DRay

DRay

·1 year ago

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

Fred Ortmann

OP1 year ago

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

·1 year ago

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.