Removing leading characters

KNIME Analytics Platform
1

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?

2

Hi there!

For removing leading spaces there is stripStart function and for removing leading zeroes you can use regexReplace function. Both functions are available in String Manipulation node.

Take a look at this example.
2019_03_01_Remove_Leading_Zeroes_And_Spaces.knwf (10.0 KB)

Br,
Ivan

3 Likes