Entering edit mode
5.7 years ago
dev
•
0
Hi, I'm new to perl and working on a small task using excel. I've a excel data like two columns 1)STATUS and 2) ID as follows
STATUS ID
Pending 123
Completed 456
Expired 789
Completed 987
Open 654
Closed 321
Completed 159
Rejected 753
I want the 'STATUS' column to filter for 'Completed' and then get the ID's associated to 'completed' only. The fetched ID's should be moved to new variable.
Let say a new variable 'Var' should contain 456,987 and 159. Please help me on this using perl script