Re: Help to extract a numeric value from string

KOskooie@xxxxxxxxxxx wrote:

Hello list,

I have a field that is string of 22 positions with a value of 0000317982.
I need to trim the zeros on the left to have only the value of 317982 and
move it to another string field.

I have tried to convert it to numeric but it gives me leading blanks "
317982000000000000".

To get it INTO a numeric field, you need to add or remove leading zeros
to make it the exact length of the target field, then stick it into a
zoned field.

To simply remove leading zeros, on the other hand, try repeatedly
substringing it to cut off the leftmost character until that leftmost
character is a nonzero digit.

--
James H. H. Lampert
Touchtone Corporation

--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.