Regex case insensitive in column expression

Hi,
I’m trying regexMatcher on the following and need it to be case insensitive so I tried this
“.opticw./i” but it fails to capture on this list:

Number Redirection - Insdsl (ae)
Blabla OpticWave
Blabla opticwave
Blabla opTicwave
Opticw blabla

Hi,

This matches any string containing “opticw” and is case insensitive:
(?i).*opticw.*

Best,
Armin

3 Likes

Thanks armingrudd,
How can find documentation on how Regex is implemented in Knime? This version only seems to work in Knime

This is not only for KNIME.
Here is the documentation to turn modes on or off in regex:
https://www.regular-expressions.info/modifiers.html
This website is great to learn regex.

Armin

2 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.