View previous topic :: View next topic
|
Author |
Message |
Bijesh
New User
Joined: 05 Dec 2017 Posts: 1 Location: USA
|
|
|
|
Hi,
My requirement is as below. There are two records shown below starting with Line 1 as rec 1 and next Line 1 as rec 2. Each Line 1 is the beginning of a record. I need to take 3 bytes from the row starting with REPORT (20:3) and merge with DATA rows(only if the fields from 78:20 in the DATA row is having a certain value).
INPUT
Code: |
Line 1
Line 2
REPORT: XXXXXX-YY CAY M#$
ROW 1
ROW 2
ROW 3
HEADER
BLANK
DATA1(120 LENGTH- IDENTIFIER FIELD 78:20 )
DATA2(120 LENGTH- IDENTIFIER FIELD 78:20 )
...
Line 1
Line 2
REPORT: XXXXXX-YY WIX M#$
ROW 1
ROW 2
ROW 3
HEADER
BLANK
DATA(120 LENGTH- IDENTIFIER FIELD 78:20 ) |
OUT Put needs to be
Code: |
CAYDATA1
CAYDATA2
WIXDATA |
We can do it via a cobol program but would it be feasible via a sort or ice tool ? Please let me know.
EDIT: Code'd |
|
Back to top |
|
|
sergeyken
Senior Member
Joined: 29 Apr 2008 Posts: 2022 Location: USA
|
|
|
|
Bijesh wrote: |
Hi,
We can do it via a cobol program but would it be feasible via a sort or ice tool ? Please let me know. |
FYI: Yes, it is possible.
1) RTFM, and/or search in Forum/Google
2) Try
3) Post your results |
|
Back to top |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006 Posts: 2481 Location: @my desk
|
|
|
|
Bijesh,
Welcome to the forums. Look for 'WHEN=GROUP' examples here. You could OMIT unwanted records and use WHEN=GROUP to identify the 'groups' starting with 'REPORT' and PUSH the 3-byte field across the group. INCLUDE only the 'DATA' records in your OUTFIL and rearrange the fields as needed in your BUILD.
Use Code tags(Code button in the editor) and do a Preview before posting code/data. Good luck! |
|
Back to top |
|
|
|