Cell Splitter From Right to Left

KNIME Analytics Platform
1

I would like use | as a delimiter to split the cells from right to left, but I can not find how to process this.

e.g.
Original data:

Description
ABC | SAE | 88964 SE
ABC | CAE |SAE | 88965 SA
ABC | CAC |SAE | SEE | 88966 SA

Desired result:

Description
ABC | SAE
ABC | CAE |SAE
ABC | CAC |SAE | SEE

Description_split
88964 SE
88965 SA
88966 SA

2

Hi @LanceHsu

Welcome to KNIME Forum. See this wf reverse.knwf (18.7 KB). It uses the reverse function in the String Manipulation node twice…
Schermafdruk van 2021-10-08 09-33-08
gr. Hans

5 Likes
3

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.
See here…
Z_035_column split.knwf (7.9 KB)

greetz, Tommy

4 Likes
4

Thank you, it it workable.

1 Like
5

Thanks and it really helps me.

2 Likes
6

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.