cancel
Showing results for 
Search instead for 
Did you mean: 

Regular Expressions

fredshepper
8 - Cloud Apps
8 - Cloud Apps

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.

4 REPLIES 4

DRay
Community Team Leader
Community Team Leader

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.

David Raynor (DRay)

fredshepper
8 - Cloud Apps
8 - Cloud Apps

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
Community Team Leader
Community Team Leader

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

David Raynor (DRay)

fredshepper
8 - Cloud Apps
8 - Cloud Apps

Thanks @DRay