Hi,

I am trying to remove blank spaces between a pipe-delimited file with the SQZ=RIGHT,TRAIL=C'|' option.  But the output still has the blank spaces.

The following statements seem to have done the trick:

  INREC  IFOUTLEN=80,
  IFTHEN=(WHEN=(26,1,CH,EQ,C'|'),
    PARSE=(%01=(ENDBEFR=C'|',FIXLEN=25),
           %02=(ENDAT=C'|',FIXLEN=23),
           %03=(ENDAT=C'|',FIXLEN=8),
           %04=(ABSPOS=59,FIXLEN=20)),
         BUILD=(%01,SQZ=(SHIFT=LEFT,TRAIL=C'|'),
                %02,SQZ=(SHIFT=LEFT,MID=X'00'),
                %03,SQZ=(SHIFT=LEFT,TRAIL=C'|'),
                %04,SQZ=(SHIFT=LEFT,MID=X'00')))
  OUTREC FINDREP=(IN=C' ',OUT=C'')

Any assistance with this matter would be greatly appreciated.

Thank you.

------------------------------
Girish Sajja
------------------------------

I was confused at first by this, because the last line says "Any assistance with this matter would be greatly appreciated."

The only thing you might want to add to your solution is ahead of the INREC line add the line "SORT FIELDS=COPY" because it makes it clear this is a copy/reformat job and not a sort, potentially your solution will abend or throw an error on some systems/configurations, without it.

Hi,

Pardon the confusion.  Right after I posted the question, I was able to figure out that the parsing had to use the variable length syntax.

As per your suggestion, the COPY needs to be specified.  The above statements were part of an ICETOOL step using the COPY function.

Thank you very much.