I read someone had difficulties with this function.
Now I am trying to figure out the same thing and I have a suggestion on that:
We currently have String Manipulation (node) > removeChars(str, chars) (function), and some combo of length and substring.
I think it would be great to have removeNChars added as follows:
removeNChars(str, n)
or for better interpretation
removeNChars(str, start/end, n)
where str is the string to manipulate and
n is the number of symbols to remove (trim).
In 1. n>0 would mean “remove n chars from start”; n<0 would mean “remove n chars from end”
in 2. n could follow the current logic (<0 defaults to 0) and start/end would mark from which position the counter should start counting.
In the Column expressions node in the latest version was added the function right() (and also left()) and they behave like in excel … extracts the rightmost (leftmost) characters of a string.