Hello community, in my table I would like to eliminate the leading zero values until the first numerical value or letter appears. [eleminate leading ZERO Values] eliminete leading ZERO Values.xlsx (13.3 KB) As a newbie, can you please help me with this (supposedly very simple) problem?

Hi @ARock1980 See this topic. [image] Removing leading characters KNIME Analytics Platform Hi, I am trying to remove leading zeros and leading spaces. For example: 000000123 000123002 ABC DG Expected Output: 123 123002 ABC DG Probably I need two nodes for zeros and spaces. Regarding zeros I tried string manipulation node but didn’t get it managed. Is there another node better? gr. Hans

eliminate leading Zero-Values in a string column

KNIME Analytics Platform

HansS June 22, 2022, 11:41am 2

Hi @ARock1980

See this topic.

gr. Hans

2 Likes