Split Cell with special characters

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

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

image

image

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! :slight_smile:

1 Like

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

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

Thank you all! :slight_smile:

3 Likes

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