Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

FileAid to compare(logical operations) 2 fields in one file

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Compuware & Other Tools
View previous topic :: :: View next topic  
Author Message
anand1204

New User


Joined: 16 Jan 2015
Posts: 7
Location: USA

PostPosted: Wed Apr 06, 2016 2:55 am    Post subject: FileAid to compare(logical operations) 2 fields in one file
Reply with quote

Hi,

I have a file & it has date fields in 2 different places (say 1st date filed in 10th Position & 2nd date field in 20th position).
Now i need to compare the dates and write into another file if 10th position date is greater than 20th position date. Can you please help me out??

e.g

Code:
----+----1----+----2----+----3---
         20150102  20150101
         20150102  20150102   <===
         20150103  20150102     
         20150201  20150102     


Now my output file should have only



Code:
----+----1----+----2----+----3---
         20150102  20150101     
         20150103  20150102     
         20150201  20150102     


Thanks,
Anand
[coded]
Back to top
View user's profile Send private message

Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 1730
Location: UK

PostPosted: Wed Apr 06, 2016 4:49 pm    Post subject:
Reply with quote

please use the code tags to present code, data, screenshots and anything else requiring retention of spaces. Did you not notice that your data display did not match your words?

Coded for you this time - but maybe not next time.

With code tags:
Code:
----+----1----+----2----+----3---
         20150102  20150101
         20150102  20150102   <===
         20150103  20150102     
         20150201  20150102     


Without code tags:
----+----1----+----2----+----3---
20150102 20150101
20150102 20150102 <===
20150103 20150102
20150201 20150102
Back to top
View user's profile Send private message
anand1204

New User


Joined: 16 Jan 2015
Posts: 7
Location: USA

PostPosted: Thu Apr 07, 2016 3:58 am    Post subject:
Reply with quote

Thanks Nic, I didnt realize it will not retain spaces.

Nic Clouston wrote:
please use the code tags to present code, data, screenshots and anything else requiring retention of spaces. Did you not notice that your data display did not match your words?

Coded for you this time - but maybe not next time.

With code tags:
Code:
----+----1----+----2----+----3---
         20150102  20150101
         20150102  20150102   <===
         20150103  20150102     
         20150201  20150102     


Without code tags:
----+----1----+----2----+----3---
20150102 20150101
20150102 20150102 <===
20150103 20150102
20150201 20150102
Back to top
View user's profile Send private message
Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 1730
Location: UK

PostPosted: Thu Apr 07, 2016 3:19 pm    Post subject:
Reply with quote

Quote:
I didnt realize it will not retain spaces.


You mean you did not check your post after submitting it? Bad, very bad - not just in a forum but in your work in general.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Compuware & Other Tools All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Formating the Input file sreekusr DFSORT/ICETOOL 3 Fri Feb 17, 2017 10:40 pm
No new posts Sort two file having same field, one ... himanshu malik DFSORT/ICETOOL 7 Thu Feb 02, 2017 10:09 am
No new posts Remove junk values in a file and rite... KP1125 DFSORT/ICETOOL 2 Wed Jan 25, 2017 9:58 pm
No new posts SYNCSORT SEQNUM and FI fields. nartcr SYNCSORT 7 Sat Jan 21, 2017 4:02 am
No new posts SORTJOIN - Copy Matched and Unmatched... Steve Ironmonger DFSORT/ICETOOL 5 Tue Jan 17, 2017 4:26 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us