Have a look at deblock rdw, my favorite for structured fields. In your case you might skip the first 2 bytes to get all halfword lengths. Another cool approach is with parcel and fanintwo. Rob On Aug 26, 2014 6:46 PM, "Gentry, Steve" < [email protected]> wrote:
> 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 >
