Doing this with a node

Hi everyone!

I got this working:

But I would like to have the same results with another node, I mean, without using Java code.

Can you give me any suggestions?

Thanks!

You can use the Rule Engine node for that (and do the trimming with a String Manipulation node in advance)

1 Like

Any idea if this can be handled in a single node?

You could use a regex within the Rule Engine to take care of the trimming … probably (untested):

\s*0?1\s*

Rules:

$column$ MATCHES "\s*0?1\s*" => "1"
TRUE => "2"
1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.