| How to get Duplicate rows in a file [message #395726] |
Thu, 02 April 2009 08:10  |
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.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
