Removing leading zeros in an address field

[almaroc]

I am trying to remove the leading zeros from an address field. i.e
data: 00123 Elm st
result: 123 elm st.

[Rabbit]

Get the characters before the first space, convert it to a number, convert it back to a string, and append everything after the first space.

[almaroc]

thanks Rabbit. Good idea.