Row Filter: Regex & how to identify rows that contain a specific string

KNIME Analytics Platform
#1

Hi everybody,

First of all sorry because it's pretty possible that this same question has been answered in other posts, but I've been able to find it.

In a 'Row filter', I'm trying to find a regex that allows me to identify the rows that contain the string "REGISTER_WEB". This string can be found in 4 different ways:

- The row only contains "REGISTER_WEB"

- The string can be found in the beginning of the field: "REGISTER_WEB"XXXXXXXXX

- The string can be found in the middle of the field:  XXXXXX"REGISTER_WEB"XXXXXX

- The string can be found in the end of the field: XXXXXX"REGISTER_WEB"

Is there any regular expression that allows me to identify all the possible combinations in which this string can be found in this field?

Thanks in advance for your help!

Best regards,

Nati

#2

How about simply *REGISTER_WEB* (including the astrix) and selecting the contains wil card option.

This is basically anything (including nothing - your string - anything including nothing.

Cheers

Sam

#3

Hi Sam,

Thank you very much! I tried this option but without the astrix, so it didn't work! ;)

Best regards,

Nati