Sort a file based on a field whose position is not fixed

[mariraj]

Hi,

I need to sort a file which contains XML records using SORT(either DFSORT/SYNCSORT). The record contains a tag like <CRTS>2012-09-26-01.01.01.000000</CRTS>. I need to sort and filter records based on this timestamp value. Being an XML, the position of this <CRTS> tag keeps varying.
Input file Specifications
RECFM=FB, LRECL=80

Sample data:

Code: Select all

AAAAAAAAAAA<CRTS>2012-09-26-02.01.01.000000</CRTS>BBBBBBBBBBBB
XXXXXXXX<CRTS>2012-09-26-01.01.01.000000</CRTS>HHHHHHHHHHHHH
CCCCCCC<CRTS>2012-02-26-03.01.01.000000</CRTS>BBBBBBBBB

I need to include only records which are within 90 days from current date.

Please let me know how this can be done. If there is a similar post which has already been answered, please let me know.

[NicC]

If there is a similar post which has already been answered, please let me know

What is wrong with using the search facility and finding this out for yourself?

[mariraj]

I tried that Nic but couldn't find any similar question.

[Anuj Dhawan]

I'm little late to the party, however, try this:

Code: Select all

//SORTIN   DD *                                                      
AAAAAAAAAAA<CRTS>2012-09-26-02.01.01.000000</CRTS>BBBBBBBBBBBB       
XXXXXXXX<CRTS>2012-09-26-01.01.01.000000</CRTS>HHHHHHHHHHHHH         
CCCCCCC<CRTS>2012-02-26-03.01.01.000000</CRTS>BBBBBBBBB              
//SORTOUT  DD SYSOUT=*                                               
//SYSIN    DD *                                                      
    INREC PARSE=&#40;%01=&#40;STARTAFT=C'<CRTS>',FIXLEN=10&#41;&#41;,OVERLAY=&#40;81&#58;%01&#41;
                                                                     
    SORT FIELDS=COPY                                                 
    OUTFIL BUILD=&#40;1,80&#41;,                                             
    INCLUDE=&#40;81,10,CH,GT,DATE1&#40;-&#41;-90&#41;                                
//*

[William Collins]

Isn't this a duplicate question from elsewhere?

[dbzTHEdinosauer]

duplicate answer, also.