IBM Mainframe Forum

How about just squeezing the first parsed field, ENDBEFR the "pipe"? The rest of the record can just be a normal definition, 11,70 for instance.

pjagathis, can you be very exact about your data, please. Can there be multiple blanks between elements of the first field, for instance?

Yes BillyBoyo.

My field have multiple blanks between the fields and each blank will have length 1 byte only.

Hi mfrookie,

Above code replaces spaces in all fields. But i need to remove the spaces only in first field. In the above code if my input is as below then,



Then the output will be,



But the expected output will be as below,




Please advice me..!

Thanks for your help..!

I don't have Syncsort, so I can't try this.

PARSE=(%00=(ENDAT=C'|',FIXLEN=11)),
...
BUILD=(%00,SQZ=(SHIFT=LEFT,MID=C' '),12,68)

If you try something like that, do you get something like what you want?

If your input is fixed-length and you get a problem with output being variable-length, try the affect of IFOUTLEN=n where n is your fixed-length.