I am new to perl scripting. I am having some problem to write a program.
I have a number of files containing same type of data with same header.
File is like this.
SN. Cities temperature Humidity rainfall
1 abc 33 66 23
2 ghi 36 83 12
3 xyz 23 78 11
......
I want to extract temperature and humidity for all cities from each file to a new file.
File names are like 1.txt, 2.txt, 3.txt, 4.txt.........
Please help me to solve this problem.
Thanks in advance.
~NaraN
What have you tried so far?
If the source data is in excel file, you can make use of
Spreadsheet::ParseExcel and
Spreadsheet::WriteExcel. If it is text file, then you should be able to do it using split() function.
However, we will not be able to help you unless you post your code.