I might have found a bug in the Rule Engine’s MATCHES function. It seems to not distinguish between substrings separated by spaces and the same substrings separated by periods (full stops).
For example, if the value in Col1 is “Hello world” and the value in Col2 is “Hello.world”, and I apply this rule:
$Col1$ MATCHES $Col2" => TRUE
…the result in the outgoing table is TRUE.
This is not what I would expect. And it is not the result obtained from the Column Comparator or the ‘Compare’ function in the String Manipulation node.
This surely is a bug, right?