Filtering Table Names - how to regex with negative search?

Hi All,

Filter does not work:

^(?!prefix).*

What am I doing wrong?

Thanks, Anton

Looks like Heidi is not supporting such kind of regular expressions. Even (?:a) gives an error.

www.heidisql .com/forum.php?t=24518

In this thread they write that it works.

But I also have an example from this topic "[^ 0-9]" also does not work.

AFAIK negative look ahead and behind is not something that is done for pascal. There is no library for that.

In fact it presumably is https://www.regular-expressions.info/delphi.html but no success implementing it in lazarus ...

www.heidisql .com/forum.php?t=24518 In this thread they write that it works.

Nope Negating character class [^ab]c = any character other than 'a' and 'b' followed by 'c'. find 'cc', but NOT 'ac' or 'bc' is not the same as Lookahead negative assertions (?!ab)c = find 'c' only if is is not preceded by 'ab' string. find 'ccc', 'aac', 'bbc', 'bac', but NOT 'abc'

[^ab]c is works fine in Heidi. I entered ^[^a] in Table filter and Heidi hides tables started from 'a' character.

HeidiSQL uses SynRegExpr from SynEdit, which again is based on TRegExpr, so the documentation on regexpstudio.com is the right place to look after that.

That library is also at GitHub, where we could file an issue report for that missing look ahead support.