delete leading and trailing spaces in a row

KNIME Analytics Platform
1

Hello;
In a column in the data I get in Excel, I have a different number of spaces at the beginning and end of the data and I can’t filter the column for this reason. How do I solve the initial and trailing spaces in cells?

the number of initial and trailing blank characters in each row is different (I can’t filter)

I’m trying to select from there when I see the (Row filter) information in the column doesn’t work.

image
image1366×768 135 KB

2

Hi,

you can use the String Manipulation’s strip(…) function:

Strips any whitespace characters from the beginning and end of given strings.

Best,
Philipp

3

Well
Is this formula-like solution applicable in excel?

=PROPER(Text)

image
image830×353 48.3 KB

4

You’ll need LowerCase and Capitalize functions used together.