I posted a while back to parse out characters in between 'DOC' and 'INDEX' for a fixed 80 byte record and this is what I received:
SORT FIELDS=COPY
INCLUDE COND=(1,3,CH,EQ,C'DOC')
INREC PARSE=(%01=(STARTAFT=C'DOC',ENDBEFR=C'INDEX',FIXLEN=80)),
BUILD=(%01,JFY=(SHIFT=LEFT))
I now need to accomplish a similar task but am using a variable length record instead of fixed. This time I'd like to take what's in between 'DocumentId</EventAttributeName> <EventAttributeValue>' and '</EventAttributeValue>' and I'm not sure how it changes the above control card for a variable length file.
Here is what the input looks like and what I want to strip out of it and sort:
Input:
DocumentId</EventAttributeName> <EventAttributeValue>RENEW70D</EventAttributeValue>
Output:
RENEW70D
Any help is greatly appreciated.