Rule Engine Node : Problems with MATCHES

[USCHUKN1ME]

Hello,

i want to change a String “A8 Angebotsaktualisierung” in a Column called $STATUS$ to “A8*=*Angebotsaktualisierung”

I’ve successfully done this with Rule Engine Node in another example, but it doesn’t work this time. Could it be the blank?

input table

Rule Engine

Output

I thank you in advance for a tip

[ArjenEX]

Hi @USCHUKN1ME

The space should not matter. I copied the terms you mentioned in your post directly into the Rule Engine node and get the desired result.

Using:

$column1$ MATCHES "A8 Angebotsaktualisierung" => "A8=Angebotsaktualisierung"
TRUE => $column1$

I would double check your MATCH statement.

[USCHUKN1ME]

Hi @ArjenEX ,

i try - but the result is the same

OUTPUT

[USCHUKN1ME]

Hi @ArjenEX again,

I copied the string A8 Angebotsaktualisierung from the original Excel table and inserted it into the Rule Engine Node.

It works now!

This probably means that something in the string was different from what I entered.

Thank you.

[badger101]

Hi @USCHUKN1ME Your spelling in the Rule Engine didn’t match with the raw data. You missed the letter i when you did it the first time around.

[USCHUKN1ME]

Small cause, big effect - sorry

[badger101]

Perhaps it’s time to buy spectacles Just kidding