Deleting Duplicate Values in Excel

stallion has asked for the wisdom of the Perl Monks concerning the following question:

Im a newbie to perl .There is an excel sheet which has the o/p as below:

s.no     tags

check1   init
check2   hi
check1   init
check3   fun
check2   hi
check3   sun
check4   data
[download]

How to delete duplicate values using perl? is it possible?

pls help...

the output should be like this

s.no     tags

check1   init
check2   hi
check3   fun
check4   data
[download]

Comment on Deleting Duplicate Values in Excel Select or Download Code

Replies are listed 'Best First'.
Re: Deleting Duplicate Values in Excel by marto (Cardinal) on Feb 08, 2012 at 13:59 UTC
Take a look at RFC Tutorial - Deleting Excel Rows, Columns and Sheets. That said if you're driving excel via Win32::OLE you may be able to filter by the unique records. The text in bold is a hint, use this as the basis for a search.	[reply]
Re: Deleting Duplicate Values in Excel by Ratazong (Monsignor) on Feb 08, 2012 at 14:05 UTC
Hi Stallion Where do you have problems? identifying unique values? that is here in the FAQ deleting rows in Excel? this is explained here: RFC Tutorial - Deleting Excel Rows, Columns and Sheets HTH, Rata	[reply]
Re: Deleting Duplicate Values in Excel by InfiniteSilence (Curate) on Feb 08, 2012 at 14:13 UTC
Open the spreadsheet with one of the Excel modules you can find in CPAN Read the values in the range into a hash as keys `$hash{'s_no/tags'}++` Iterate over hash keys and split them again like `perl -e '%hash = (q\|check1/init\|=>3,q\|check2/hi\|=>4); for(keys %hash){print join qq\|\n\|,split qq\|\/\|,$_};'` Celebrate Intellectual Diversity	[reply] [d/l] [select]