Is there a way to specify using regex to show results not containing specific text

Question

Is there a way to specify using regex to show results not containing specific text.Something similar to

Select * from table where id not in {3,4,6};

As in a negative lookahead? http://www.regular-expressions.info/lookaround.html — Chrispresso, Jul 28 '14 at 20:43
There is, but you should be more specific on what you need. Usually `^` is used for small regular expressions. — Mateva, Jul 28 '14 at 20:45

score 1 · Accepted Answer · answered Jul 28 '14 at 20:46

1

[^346] -any character except 3,4,6. Is this what you asked?

answered Jul 28 '14 at 20:46

lucian.marcuta

1,250
1
16
29

score 0 · Answer 2 · answered Jul 28 '14 at 20:50

0

How about simply looking for the text, and use the not operator on the result?

List<String> list = ...
list = list.stream()
    .filter(string -> !string.matches("[346]")) // note the !
    .collect(Collectors.toList());

answered Jul 28 '14 at 20:50

Ypnypn

933
1
8
21

score 0 · Answer 3 · answered Jul 28 '14 at 20:51

In keeping with your example, consider this code:

Stream.of("13","11","3","33","3a")
  .filter(s -> s.matches("(?!3$|4$|6$)\\d+"))
  .forEach(System.out::println);

It will select only those strings which are pure digits, but do not match "3", "4" or "6".

The key feature of the regular expression is

(?!3$|4$|6$)

This is the negative lookahead, and it matches the exact strings "3", "4", and "6". Since it's negative, the whole expression matches when this part does not match.

Is there a way to specify using regex to show results not containing specific text

3 Answers3