View previous topic :: View next topic
|
Author |
Message |
bnveena
New User
Joined: 29 May 2007 Posts: 50 Location: hyderabad
|
|
|
|
I have an input file like:
Code: |
001122 PIGGOTT HOSPITAL 2009-10-012009-10-01
004017 FT. SMITH RIM & BOW CO.
004951 BANK OF LAKE VILLAGE 2009-10-012009-10-01 |
for the second record at position 42 position there is no data
in my outfile I want only those records which have data at 42 onwards... |
|
Back to top |
|
|
superk
Global Moderator
Joined: 26 Apr 2004 Posts: 4652 Location: Raleigh, NC, USA
|
|
|
|
Can't you just OMIT any records where column 42 is a space? |
|
Back to top |
|
|
bnveena
New User
Joined: 29 May 2007 Posts: 50 Location: hyderabad
|
|
|
|
yeh.... i got it by omiting the records in the sort.. thnks |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Does your solution handle the situation where 42 is blank but 43 has data? Is this even a possibility?
When you post jcl, code, data, screen info, etc it is best to use the "Code" tag. This will preserve alignment and improve readability. The original data has been "Code"d. |
|
Back to top |
|
|
|