Resolved! trim leading zeros from text '0000000-4005-1' ?
Here's another little puzzler - I'm trying to trim the leading zeros from this string '0000000-4005-1' - I can't just replace zeros w/ nulls because '4005' still needs its zeros. ( also, the field won't always contain a dash so I can't use that in m...