Removing all leading zeros from string

[KimNgoc]

Hi everyone,

i have 2 columns like that. Now i need to do delete all zeros at the beginning of string.
Can you help me, pls ?

[ArjenEX]

Hi @KimNgoc

Have a look around on the forum, this topic has been covered a few times with various solutions available.

Remove zeros left and right of a number but not in the middle

Hello, I want to remove all zeros left and right of a number but not between. Ist this with a string manipulation possible? The length of the number is always different. For example the initial number is: 000L214637400732000 and I expect this number after the string manipulation as result: L214637400732 How can I do this? Thanks a lot. Greetings

Removing leading characters

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?

[aworker]

Hi @KimNgoc & welcome to the KNIME forum community

Complementary to @ArjenEX’s links to solutions, please find below a workflow who is answering your question too:

20220914 Pikairos Removing all leading zeros from string – pikairos

The first solution is using as trick the replacement of zeros “0” by blank characters " " and then using the “stripStart” function in the string manipulation node, as follows:

replaceChars(stripStart( replaceChars($String with Leading Zeros$, "0" , " ")), " ", "0")

Much easier solution is used in the second -String Manipulation- node, based on a very simple regular expression:

regexReplace( $String with Leading Zeros$,"^0+", "")

Hope it helps.

Best,
Ael

[KimNgoc]

thank u so much. It is very helpful for me ^^

[KimNgoc]

Thank @aworker . It works very well ^^

[Daniel_Weikert]

I immediately thought regex but I really like the trick with the “replace twice”
THanks for sharing @aworker
br