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

KNIME Analytics Platform
1

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

2

This is not elegant solution but has to work. Use String manipulation node with the next set of functions
replace(strip(replace($column1$,“0” ," " )), " ", “0”)

Replace column1 with your field name.

3

Thank you. It works:)

4

Actually this is very elegant @izaychik63 :+1:
Ivan