help on data retrival
Posted by johny (johny), 19 October 2007Hi
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.
Posted by admin (Graham Ellis), 19 October 2007Run 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.
PH: 01144 1225 708225 • FAX: 01144 1225 899360 • EMAIL: email@example.com • WEB: http://www.wellho.net • SKYPE: wellho