I've run a db2 select within a pipe and I get two words back. Both words have a length field in front of it, in hex. The length of the length field in the first word is 4 bytes long. The length of the length field for the second word is 2 bytes long. So, this is sort of how it looks: """"THIS_IS_FIELD_A ""13000 """"THIS_IS_FIELD_B ""4577
Word 2 is a numeric field. I want the output to look like this and because word 2 is numeric, I want to right justify it. THIS_IS_FIELD_A 13000 THIS_IS_FILED_B 4577 I can do a SPLIT but because the two length fields are 4 and 2 , I can't do a SPECS 5-* 1 ( or SPECS 3-* 1 ). Then there is the issue of JOINing them and getting the formatting (see above) correct. I don't really care about the length fields (unless, of course, it helps with the overall solution). I can do this by writing a REXX STAGE but I prefer to do it all in PIPES. I'm sure it can be done in pipes and probably with specs but I can't come up with a solution. Does anybody have a suggestion? Thanks, Steve
