Frosty the Coder
Legendary Poster
List,
I have a legacy table where ORDER# is in an alpha field, left justified, zero suppressed.
LINE# is split into two alpha fields, one for each side of the decimal, left justified, zero suppressed.
I have to try to marry this to F4211 and do it quickly.
I've tried using the DIGITS operand, to convert F4211_mnDOCO to an alpha
but this does not zero suppress, and therefore doesn't match Legacy_szDOCO.
Query, and WorldWriter don't have "PAD" or "TRIM" operands to make this easy.
I may be having a "can't see the forest due to the trees" moment, but I can't figure out
how to do this w/out coding an RPG (which I've been told NOT to do).
Thoughts?
I have a legacy table where ORDER# is in an alpha field, left justified, zero suppressed.
LINE# is split into two alpha fields, one for each side of the decimal, left justified, zero suppressed.
I have to try to marry this to F4211 and do it quickly.
I've tried using the DIGITS operand, to convert F4211_mnDOCO to an alpha
but this does not zero suppress, and therefore doesn't match Legacy_szDOCO.
Query, and WorldWriter don't have "PAD" or "TRIM" operands to make this easy.
I may be having a "can't see the forest due to the trees" moment, but I can't figure out
how to do this w/out coding an RPG (which I've been told NOT to do).
Thoughts?