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


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:

and I expect this number after the string manipulation as result: L214637400732

How can I do this?

Thanks a lot.


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.


Thank you. It works:)

1 Like

Actually this is very elegant @izaychik63 :+1:

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