I can't solve this.
id name address
1 cristine New York
2 murray Redmond
3 kumar Sunnyvale
This is 'samples.xlsx' file-Excel type.
'id' string in A1, 'name' in B1, 'address' in C1 column in excel file.
Create a Perl script to store the information about student using the header as in raw 1.
The Perl script should be able to provide data of any student using the id or name or address.
For example: If I need details that who is the person lives in Sunnyvale, the Perl script should give me back the result as Kumar.
Try out usage of GetOptions in Perl script.
How can I manage duplicate data if any...?