How to use String Strip Function Multi-column

Hi all, I’m trying to eliminate blank spaces using the Strip function for Multicolumn but I’ve been getting the following error. I’m new to Knime, and could not find good resources on how to properly use the strip function.

Screenshot 2023-01-29 115315

Hi @DiegoCorreiaXTL

Welcome to the KNIME Community!

The strip function can only be applied to columns of type string. You have integers in your list and probably also doubles based on the error. If you only have string columns in the list, the node will work.

3 Likes

Hi @ArjenEX,
Got it. Thank you for the help.
I’m not getting the error anymore, but when I execute the node, it replaces all my DATA. Am I missing anything?

Yes, $$CURRENTCOLUMN$$ is a variable. It does not require to be within quotes.

strip($$CURRENTCOLUMN$$) is the correct syntax.

3 Likes

That’s great! It worked now. Thank you so much for the help

2 Likes

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