I am trying to figure out if there is a way in KNIME to check if the last character in a string is 0 and delete it, and if it is not, the last character should stay as it is. For example:
Value 1: 20 → 0 at the end should be deleted (new Value: 2)
Value 2: 18 → both number/characters stay as it doen’t end with a 0
I would be grateful if someone can help me with this issue.
After that you can use one of your favorite splitters. i.e. Up == True / Down == False
Math Formula in the Upper
$value$ + 2
Concatenate back the both branches of the Split
BR
PS. After writing this I realized ‘last character in string’, then take @Thyme 's approach. This post can stay, as if someone else looking for the same challenge with numeric format