468,544 Members | 1,767 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,544 developers. It's quick & easy.

Removing leading zeros in an address field

48
I am trying to remove the leading zeros from an address field. i.e
data: 00123 Elm st
result: 123 elm st.
Jan 12 '12 #1

✓ answered by 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.

2 1814
Rabbit
12,513 Expert Mod 8TB
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.
Jan 12 '12 #2
almaroc
48
thanks Rabbit. Good idea.
Jan 13 '12 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by kumu | last post: by
5 posts views Thread by samik_tanik | last post: by
1 post views Thread by mmmgood1 | last post: by
6 posts views Thread by Clint Stowers | last post: by
5 posts views Thread by OneDay | last post: by
reply views Thread by NPC403 | last post: by
1 post views Thread by UniDue | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.