Hi Myriam,

I don't think this is something we support, but I'd like to know more details as to what you're specifically looking to do here.

When you say you want to use a tilde for a string comparison, what were you hoping to do a comparison against?

Can you write us an example of how you're hoping the data will appear based on what you'd like it to do?

The regex_replace function is usable in LabKey SQL, but it is very specific in its job to replace values rather than trying to do comparisons alone.

Regards,

Jon

Hi Jony,

Thank you for your reply.

For instance, here is typically what I would like to do with SQL in Labkey :

 * Comparing dates :
SELECT mydate
FROM mytable
WHERE mydate ~ '(\d{2}\/){2}\d{4}'

 * Comparing strings :
SELECT myfield
FROM mytable
WHERE myfield ~* '[A-Z]\d{5}._[a-z]+'


Is it possible to do this or something similar with reports, modules or wiki pages ?

For the moment i'm using the alternative of the "LIKE" syntax (WHERE mydate NOT LIKE 'NK/%/%' AND mydate NOT LIKE 'ND/%/%').
I am therefore obliged to know all the possibilities i've to delete with my query. But when these possibilities will are unknown to me in advance, this alternative will no longer help me ..


Regards

Myriam

Thanks for the examples Myriam.

Our operators are limited and I'm finding any kind of RegEx case-sensitive/case-insensitive option to use.

I've passed your additional info to our developers to see if there is anything that I might have missed or I might not be aware of.

Regards,

Jon

Hello Jony,

Thanks a lot for your efficiency.
Okay, i'm waiting for your news for any suggestions.

Regards,

Myriam