| |||||||||||
| |||||||||||
help on data retrival Posted by johny (johny), 19 October 2007 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 Posted by admin (Graham Ellis), 19 October 2007 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.This page is a thread posted to the opentalk forum
at www.opentalk.org.uk and
archived here for reference. To jump to the archive index please
follow this link.
|
| ||||||||||
PH: 01144 1225 708225 • FAX: 01144 1225 793803 • EMAIL: info@wellho.net • WEB: http://www.wellho.net • SKYPE: wellho |