How does the Trim Node work in Data360 Analyze?

In 3.4.0 the node trims characters from either end of the incoming string, based on what characters you put in the "TrimCharacters" property, and in that order. So if you have this on the input:

test.xls
test2.xxls

Then in TrimCharacters specify xls it first looks for the letter x and trims that off, then l and so on
So, in the example data above, there is no letter x on the end of the values, so it stops.
You could reverse the order, so in TrimCharacters specify slx in which case you'd get the following:

test.
test2.x

In 3.5.x you can specify that the value TrimCharacters is to be treated as a string. This is done via a new property called TrimCharactersAsString -  When we set to True the node behaves in the way you want it to.
The property allows you to optionally specify whether you want to trim the string value entered in the TrimCharacters property to remove a prefix, a suffix or both.

a) When set to True, the node will trim the string entered in the TrimCharacters property.

b) When set to False, the node will remove all occurrences of the specified characters. The default value is False.