hi there
after a pivot I like to clear the agregated column “+Sr_Num” linked to the original column name.
Using the Column rename Node I can clean the Sr_Num but not the damm + sign… is there a way to get rid of this?
Grüezi,
you’ll have to escape the +
with a \
. So if you’d want to strip away the plus sign and all what follows, you’d use the following pattern:
(.+)\+.*
– Philipp
besten Dank Philipp!
simply putting +.* in the search string did the trick!
schöne Grüsse Dieter
1 Like