Would you please help me out? The below is my requirement.
In a report I have Julian date at 1st position and some text on 17th(9 bytes) column
I would like to get instances of text which is in 14th column, if 3rd position is having yesterdays Julian date.
input
2012/039 RAJU
2012/039 KAVI
2012/039 SHYAM
2012/039 KAVI
2012/039 SHYAM
output
RAJU
KAVI
SHYAM
KAVI
SHYAM
Please help me out in this regards,
Many thanks for your anticipated help.
Regards,
Shailaja