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

[Frank2323]

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

[izaychik63]

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.

[Frank2323]

Thank you. It works:)

[ipazin]

Actually this is very elegant @izaychik63
Ivan