IBM Mainframe Forum

Hi all,
Need your help/advice please…
how do I remove the data(variable) before and including the ‘=’ symbol from this line of text with DFSORT/ICETOOL/ICEMAN? The data resides in PDS member.

before change
XXXXXXXXXX=QQQQQQQ AAAAAAAAA | 9999999999

after change
QQQQQQQ AAAAAAAAA | 9999999999

Is the data to be removed variable or is the length of the data variable (or both)?

Hi Nic, both the data and the length is variable.

Use PARSE to assign the first field to %0 and the rest to %1 and use %1 to create your output dataset.

Thank you Nic, let me try that

NicC wrote:Use PARSE to assign the first field to %0 and the rest to %1 and use %1 to create your output dataset.

In order just to skip any unneeded part of data in PARSE the dummy option '%=(. . .)' can be used, rather than parameter '%n=(. . .)'

But then I would have to look up the manual to see if the first named %x starts at 0 or 1 (or maybe it can be another number)!

thank you very much guys...
I managed to get my desired result by using the following...

INREC PARSE=(%0=(STARTAFT=C'=',FIXLEN=80),
%1=(ENDAT=BLANKS,FIXLEN=80)),
BUILD=(%0,%1)
SORT FIELDS=COPY

NicC wrote:But then I would have to look up the manual to see if the first named %x starts at 0 or 1 (or maybe it can be another number)!

The number(s) %n used in PARSE must be used also in BUILD, exactly as is. Any number(s) can be used: %9, %03, %0, %01, ...

Dummy parameters %=(...) are used ONLY to parse across unneeded parts of input data.

There is no need to look up the manual to find out the used number.

I was saying to "look up the manual to get the correct syntax". If they had DFSort for the PC then I may have played further. I do most things from (failing!) memory now that I am retired.