How truncate a string with a condition?

Hi all, I need a new column in which I start from the ID but I need only one piece of this ID: I want only all values before “#”, like this in yellow column:

image

Some of these ID do not have the # so I can copy them without do anything more…

How can I do? I have tried the string manipulation but I cannot find a way…
Thanks
Giad

Hi @giad

Use the Cell Splitter node.

gr. Hans

5 Likes