Hi All,
Requirement:
i have 4 excel files, each file will have this line
i need to search for this line & extract this line then print it another excel file.
INPUT file look like this:
Filenamerstat-Ls-20080118-2000.xls
OUTPUT file should look like this:
Filenamerstat-Ls-20080118-2000.xls (in differnt location)
haven't started scripting for this, as i have struck on how to gohead with this.
first i thought read the file line by line then delete the line till i get some values in LAVG_1min but this won't give me the required output
Is this a good idea to go head ???
can anyone help me on how to do this ??
hope i think i have made requirements clear !!!!
Regards,
Raghavanv
Requirement:
i have 4 excel files, each file will have this line
Code:
18/01/2008 20:00:00 5.31 5.48 5.33
i need to search for this line & extract this line then print it another excel file.
INPUT file look like this:
Filenamerstat-Ls-20080118-2000.xls
Code:
DD/MM/YYYY HH:MM:SS PID USERNAME LAVG_1min LAVG_5min LAVG_15min
18/01/2008 20:00:00 24992 vappr
18/01/2008 20:00:00 24989 vappr
18/01/2008 20:00:00 24992 vappr
18/01/2008 20:00:00 24989 vappr
18/01/2008 20:00:00 24990 vappr
18/01/2008 20:00:00 24989 vappr
18/01/2008 20:00:00 5.31 5.48 5.33
18/01/2008 20:00:00 24989 vappr
18/01/2008 20:00:00 24990 vappr
18/01/2008 20:00:00 24989 vappr
18/01/2008 20:00:30 3.31 1.48 7.33
OUTPUT file should look like this:
Filenamerstat-Ls-20080118-2000.xls (in differnt location)
Code:
DD/MM/YYYY HH:MM:SS LAVG_1min LAVG_5min LAVG_15min
18/01/2008 20:00:00 5.31 5.48 5.3
18/01/2008 20:00:30 3.31 1.48 7.33
first i thought read the file line by line then delete the line till i get some values in LAVG_1min but this won't give me the required output
Is this a good idea to go head ???
can anyone help me on how to do this ??
hope i think i have made requirements clear !!!!
Regards,
Raghavanv