Wildcard syntax...

KNIME Analytics Platform
1

Hi

I understand that there are 2 possible syntax’s to use for a wildcard, which are * and ?

I am trying to filter thousands of UK postcodes in a csv file which begin with NN

If I use a row filter and either NN1? or NN1* the result includes all NN postcodes whether they are NN1, NN11, NN12 etc.

I only require those postcodes that have a postcode beginning and ending with NN1 ie NN1 1HJ

Is the syntax i’m using correct?

thanks

2

Hi,

you can include the blank in your pattern: “NN1 *”

For example
image

Would be filtered to:
NN1 123

1 Like