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:


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…

Hi @giad

Use the Cell Splitter node.

gr. Hans


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