Expression RegEX

It works in Rule Engine
$ColumnName$ MATCHES “[0-9]*.\d+” => $ColumnName$

It doesn’t work in the Expression node
“token recognition error”
if(
regex_match($[“ColumnName”], “[0-9]*.\d+”) = TRUE,
$[“ColumnName”],
“”
)

Hi @Christopher41,

in the Expression language, \ is used to escape characters in strings, similar to Java (and in contrast to the Rule Engine, it seems). So your single \ escapes the d, which the node does not recognize as a special token. If you escape the \ with a second backslash, it is a literal backslash and works:

2 Likes