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

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.

4 Likes

Thank you. It works:)

1 Like

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

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.