using %char and removing leading blanks
I have a 6 pos serial number, ex(000022) that I need to CAT onto a qualifier of UN. so the final result should be UN22. I would like to do this using %char. I thought I could do it in one line, but I am having issues with not being able to remove the leading blanks. My result ends up being "UN 22".
Software/Hardware used:
AS400 DB2
Software/Hardware used:
AS400 DB2
ASKED:
May 5, 2010 8:29 PM
UPDATED:
May 5, 2010 9:03 PM
RELATED QUESTIONS
- How to remove specific lines from a text files using either vbs or bat.
- CPYTOIMPF removed leading zeros from numeric field
- How to easily perform date conversions in RPGLE (Including Substringing!)
- %char(month_field) yields just '1' and not '01'
- converting numeric field to a character field and show leading zeros
Answer Wiki:
Dobie,
You need to include %trim...
Result = 'UN' + %trim(%char(srlnbr))
HTH...
Scott
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
