Hi

I have internal tool command when run against an user which gives the below result i wanna capture the the first field and third field with the max of third field (that is date)

command is :

system("intclmd | grep janab | grep 2007")

Client janab_test  2007/05/16  root C:\p4\testdep  'Created by janab. '
Client janab_prast 2007/8/16 root C:\p4\prastdep 'Created by janab. '
Client janab_crest 2007/7/16 root C:\p4\crestdep 'Created by janab. '

the result what i want is as the 2007/8/16 is the max in this case.
Client janab_prast 2007/8/16 root C:\p4\testdepot 'Created by janab. '

How can i get this perl.

Thanx in advance.
Johny


Run the command in backquotes and save it to a scalar, split the results at the new line character into a list, and loop through the list analysing each line in turn.  As the dates are in year/month/day format, you can simply remove the slashes and compare the numbers - though you will need to add code to handle the inconsistency of the number of digits in the month and perhaps day that you show in your example.

---