Hi All - can anyone help me in splitting cells with special character? I’m using the cell splitter node but nothing happens. below is my sample
9431 - GLOBAL HAIR CARE HEADQUA
I want to split this into 2 columns. I’m using “-” as my delimiter but nothing happens.
1 Like
ipazin
March 1, 2019, 2:23pm
2
Hi there!
Do you put quotation marks? I just tried it and it works with only - as delimiter.
Br,
Ivan
2 Likes
KNIME_project.knwf (429.8 KB)
Hi Ivan - I attached a sample of my workflow. Yes, I’m just putting - as delimiter
1 Like
on the first screenshot on column GOCOA PC that’s the cell i want to split.
on the second screenshot that’s my configure using cell splitter node.
and on the last is the output table in splitter node. reflecting nothing.
Appreciate your help on this!
1 Like
ScottF
March 1, 2019, 7:56pm
5
Hi @Yan_Dri -
If you scroll all the way to the right in your output table, you’ll see that a new column has been created as a List.
Maybe the easiest thing to do is to change the output option from “as list” to “as new columns”. Then scroll over in your output, and you should see the properly split columns.
3 Likes
Tyler
March 2, 2019, 12:16am
6
Hello, nice to meet you.
If you want to split to column, select the output “as new columns.”
Today, you’re selecting “as list”…
I think you’re looking to split the cell on the character though, not build an array at the cell level.
Attaching workflow from screenshot, that shows the difference between the settings too.
Split or list.knwf (9.0 KB)
Hopefully this helps, sorry I’m still pretty new here!
Best,
Tyler
3 Likes
system
Closed
March 9, 2019, 12:39pm
8
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.