Home » Infrastructure » Unix » How to get Duplicate rows in a file (unix,HP-UX)
How to get Duplicate rows in a file [message #395726] Thu, 02 April 2009 08:10 Go to next message
raghu.iv85
Messages: 13
Registered: December 2008
Location: banglore
Junior Member
Hi all,

I have written one shell script. The output file of this script is having sql output.

In that file, I want to extract the rows which are having multiple entries(duplicate rows).
For example, the output file will be like the following way.

===============================================================
<SH12_MC30_CE_VS_NY_HIST_T>
===============================================================
397 44847
400 33653
401 46455
===============================================================
<SH12_MC30_CE_VS_NY_HIST_T_BKP>
===============================================================
397 44847
398 40107
399 39338
400 33653


In this output, I want numeric duplicate rows only. Suppose this file is having lines to separate the values, those lines also considered as duplicate rows. So I want only the out put from this file which is having more than one entry and which is related to numbers.

Can anyone please tell me the command?
Thanks in advance.

Regards,
Raghu.
Re: How to get Duplicate rows in a file [message #395732 is a reply to message #395726] Thu, 02 April 2009 08:29 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This question bears no connection with Oracle.
Please find a more appropriate forum.
The topic is locked.

Regards
Michel
Previous Topic: Crontab Not Fire (merged)
Next Topic: What's the maximal memory of PGA in Oracle 10g R2 on Solaris 9 or Linux
Goto Forum:
  


Current Time: Thu Mar 28 13:26:39 CDT 2024