If ... then ... else statement in Rule Engine

[iCornerstone]

Trying to use the Rule Engine for an if then else statement to manipulate a string

Column A
0/123
2/234
567
2/255

Notice in the 4th row I have 567 and I want to add "0/ " in front of this so that it looks like 0/567

I have used Rule Engine and written

$ColA$ LIKE “/” => $ColA$
NOT ($ColA$ LIKE “/”) => [ ]

in the [ ] brackets I want to enter CONCATENATE ( “0/” , $ColA$)

How do I do this?
Any help much appreciated

[izaychik63]

Rule Engine do not allow data manipulations. Use Column Expression instead.

[iCornerstone]

Thanks for that. Where do I find Column Expression?

[izaychik63]

Column Expressions — NodePit

Or go to HELP/Install New Software menu and look for it to install.

[iCornerstone]

Perfect, Thanks