How to strip whitespace in elements of table columns?

[azsb1g19]

Is it possible to use the String Manipulation (Multi Column) node for this purpose? Rather than something like this: Strip white space from all columns in table

I’m confused by the syntax:

This is not correct:

[ScottF]

Hi @azsb1g19 -

Instead you need to use the special $$CURRENTCOLUMN$$ keyword, selecting the relevant columns in the exclude/include dialog box at the top:

[mlauber71]

@azsb1g19 it could look something like this:

Tree Ensemble Learner does not recognize newlines in column names (include/exclude filter does)

@tims you could use a regex function and a “Insert Column Header” node to clear your variable names. The logic is you remove everything that is not explicitly permitted. In this case a blank is OK. You might edit that to your needs. regexReplace($Column Name$,"[^a-zA-Z0-9 ]","") [image]

(you might have to edit it to your needs)