Page 1 of 1

Selective reformatting

PostPosted: Fri May 24, 2013 9:12 pm
by deva_048
Hi all,
Am facing the issue while validating the fields. If you see scroll down the output below after validation it should not show 'JOB ETA:02:30:00 NOTE: NO DELAY' how to avoid this... When AAA feed of first two numbers is greater than or equal to 01 it should show JOB ETA:INPROG NOTE: JOB DELAY along with input file contents.
When BBB FEED of first two numbers is less than 01 it should show JOB ETA:02:30:00 NOTE: NO DELAY along with input file contents.

Please help me to resolve this. I am struggling a lot ....

Input file
JOB LIST
DDD FEED RECEIVED AT  23.26.03
BBB FEED RECEIVED AT  00.41.22
CCC FEED RECEIVED AT  00.40.59
AAA FEED RECEIVED AT  01.28.26


Sort card
SORT FIELDS=COPY                                           
INREC IFTHEN=(WHEN=(1,3,CH,EQ,C'AAA',AND,23,2,CH,GE,C'01'),
    OVERLAY=(35:C'JOB ETA:INPROG',50:C'NOTE: JOB DELAY')), 
      IFTHEN=(WHEN=(1,3,CH,EQ,C'BBB',AND,23,2,CH,LT,C'01'),
    OVERLAY=(35:C'JOB ETA:02:30:00',53:C'NOTE: NO DELAY')) 


Output:
JOB LIST                                               
DDD FEED RECEIVED AT  23.26.03                                     
BBB FEED RECEIVED AT  00.41.22    JOB ETA:02:30:00  NOTE: NO DELAY
CCC FEED RECEIVED AT  00.40.59                                     
AAA FEED RECEIVED AT  01.28.26    JOB ETA:INPROG NOTE: JOB DELAY   

Re: Reformat input file

PostPosted: Fri May 24, 2013 9:43 pm
by deva_048
Sorry , also forgot to mention , is it possible to put these below notes in end of the file instead of right while doing validation when each of the inrec condition matches...

JOB ETA:INPROG NOTE: JOB DELAY

JOB ETA:02:30:00 NOTE: NO DELAY

Re: Reformat input file

PostPosted: Sat May 25, 2013 12:28 pm
by deva_048
Did anyone tried on my request ??

Thanks in advance.

Re: Reformat input file

PostPosted: Sat May 25, 2013 1:19 pm
by NicC
This is what can happen when people tag a new request onto a previous problem - you said it was resolved so people stop looking. Now you add that there is a further problem but no one is looking. Further to that - soliciting for replies is rude and against the rules. People answer on their own time, if they are interested and want to, and free of charge. And now it is the weekend so many will be leaving their computers alone and try to be 'normal' people again.

Re: Selective reformatting

PostPosted: Wed May 29, 2013 2:26 am
by dick scherrer
Hello,

This topic has been split from where it was originally appended.

If the new topic title i made up is not what you want, please post what you would rather see.