List Duplicate file name based on the rows

Microsoft Windows xp professional w/sp2
March 1, 2010 at 23:43:42
Specs: Windows XP
Hi,

I have a requirement to read all the .dat files in a folder and rows in the each file. If I found any duplicate entry in any of the file need to move in a separate folder ("DuplicateFiles"). Could you please help me provide any solution you come across using bat file. I am using Win XP OS.


See More: List Duplicate file name based on the rows

Report •

#1
March 2, 2010 at 00:11:22
duplicated in one file, or across files?
(f/e, file1 line #1: 010203 file1 line #5: 010203
or:
file1: anyline: 010203
file2: anyline: 010203

"exact" or "sub-string"
etc.
pls give details


Report •

#2
March 2, 2010 at 00:32:22
Duplicates may exists across the files. For example :

File1 has the below entries : 3 Records

"2010-01-19 13:50:00",9740,"NS",274.2223,4935.901,11,873,40.62
"2010-01-19 13:55:00",9741,"NS",278.557,3106.458,7,645.6,42.7
"2010-01-19 14:00:00",9742,"NS",370.196,890.1749,2,780.5,41.76


File2 has the below entries : 5 Records


"2010-01-19 13:50:00",9740,"NS",274.2223,4935.901,11,873,40.62
"2010-01-19 13:55:00",9741,"NS",278.557,3106.458,7,645.6,42.7
"2010-01-19 14:00:00",9742,"NS",370.196,890.1749,2,780.5,41.76
"2010-01-19 13:55:00",9741,"NS",278.557,3106.458,7,645.6,42.7
"2010-01-19 14:00:00",9742,"NS",370.196,890.1749,2,780.5,41.76


In File2 we have two duplicate rows at the end(i.e., 4 & 5 rows).


I need to to remove the 4, 5th lines from the second file and move them into separate folder with "Duplicate Files" with filename "File2". This file has to have only the last two rows (which are duplicate entries).

Please let me know if you need further information.


Report •

#3
March 2, 2010 at 20:44:07
Hi Experts,

Could any one give solution on this please.


Report •
Related Solutions


Ask Question