MVSFORUMS.com

[ranga_subham]

Hi,

I have an input file of 91 bytes.

I want to extract the records based on following criteria:

1). Column 14 to 16 should contain value "ABC".
2). Column 23 to 31 should be spaces
3). Column 65 to 71 should be greater than zero
4). Column 32 to 37 should have any of these values (ARMADA, XANDAR, PUGEOT, BEOHVA, VAJRAN, URAM).

Length of output file is also 91 bytes.

Would you please give me File-Aid/Syncsort code for this

Thanks in Advance.
_________________
Ranga
*****
None of us is as smart as all of us - Ken Blanchard

[CraigG]

Have you tried seaching for the answer, it seems to me that a lots of examples doing the same sort of thing, you may have to adjust position number etc but a little thinking never harmed anyone.

[amargulies]

Try this JCL:

[Frank Yaeger]

Alissa,

FYI, you don't need to code all those blanks for a condition like

[amargulies]

Frank,

You are correct, SyncSort does the same, so the extra blanks are not necessary. It's just my coding style/preference. I like to code the "place holders".
_________________
Alissa Margulies
SyncSort Mainframe Product Services
201-930-8260
zos_tech@syncsort.com

[Frank Yaeger]

[ranga_subham]

Thanks to amargulies.
_________________
Ranga
*****
None of us is as smart as all of us - Ken Blanchard