I would like use | as a delimiter to split the cells from right to left, but I can not find how to process this.
ABC | SAE | 88964 SE
ABC | CAE |SAE | 88965 SA
ABC | CAC |SAE | SEE | 88966 SA
ABC | SAE
ABC | CAE |SAE
ABC | CAC |SAE | SEE
Welcome to KNIME Forum. See this wf reverse.knwf (18.7 KB). It uses the reverse function in the String Manipulation node twice…
hi @LanceHsu and Welcome,
I case you wanna split all parts separated by “|”, go for @HansS solution.
In case you just want to separate the last part, I would use substr in String manipulation.
Z_035_column split.knwf (7.9 KB)
Thank you, it it workable.
Thanks and it really helps me.
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.