10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Hi all,
I have a issues while loading a flat file to the DB. It is taking much time.
When analyzed i found out that there are duplicates entry in the flat file.
There are 2 type of Duplicate entry.
1) is entire row is duplicate. ( i can use sort | uniq) to remove the duplicated entry.
2) the... (4 Replies)
Discussion started by: samjoshuab
4 Replies
2. Shell Programming and Scripting
Hi some one please help me to remove duplicates from a pipe delimited file based on first two columns.
123|asdf|sfsd|qwrer
431|yui|qwer|opws
123|asdf|pol|njio
Here My first record and last record are duplicates.As per my requirement I want all the latest records into one file.
I want the... (12 Replies)
Discussion started by: ginrkf
12 Replies
3. UNIX for Dummies Questions & Answers
Hi,
I have a tablular separated file and I want to remove all the rows that have duplicates. The diuplicates I need to check are in column 13.
I have tried to use awk but I have no Idea how to keep the duplicate file.
awk 'FNR==NR{a++;next}(a> 1)' tomodify.txt tomodify.txt > new.txt
... (4 Replies)
Discussion started by: flacchy
4 Replies
4. Shell Programming and Scripting
I have unix file like below
>newuser
newuser
<hello
hello
newone
I want to find the unique values in the file(excluding <,>),so that the out put should be
>newuser
<hello
newone
can any body tell me what is command to get this new file. (7 Replies)
Discussion started by: shiva2985
7 Replies
5. UNIX for Dummies Questions & Answers
Can u tell me how to remove duplicate records from a file? (11 Replies)
Discussion started by: saga20
11 Replies
6. Shell Programming and Scripting
Hi,
This is a bit lengthy problem, i will try to keep explaining it simple.
I have got a file say file1 that contains the following in it,
------------------------------------------------------------------------ r201463 | ngupta@gmail.com | 2012-06-19 22:02:20 +0530 (Tue, 19 Jun 2012) |... (3 Replies)
Discussion started by: Kashyap
3 Replies
7. Shell Programming and Scripting
All,
I have a file 1181CUSTOMER-L061411_003500.dat.Z having duplicate records in it.
bash-2.05$ zcat 1181CUSTOMER-L061411_003500.dat.Z|grep "90876251S"
90876251S|ABG, AN ADAYANA COMPANY|3550 DEPAUW BLVD|||US|IN|INDIANAPOLIS||DAL|46268||||||GEN|||||||USD|||ABG, AN ADAYANA... (3 Replies)
Discussion started by: Oracle_User
3 Replies
8. Shell Programming and Scripting
Hi,
I need to remove duplicates from a file. The file will be like this
0003 10101 20100120 abcdefghi
0003 10101 20100121 abcdefghi
0003 10101 20100122 abcdefghi
0003 10102 20100120 abcdefghi
0003 10103 20100120 abcdefghi
0003 10103 20100121 abcdefghi
Here if the first colum and... (6 Replies)
Discussion started by: gpaulose
6 Replies
9. Shell Programming and Scripting
1/p
----
A
B
C
A
C
o/p
---
B
A
C
From input file it should remove duplicates from end without changing order (5 Replies)
Discussion started by: lavnayas
5 Replies
10. Shell Programming and Scripting
hi.. i have a file in the following format :-
name-a
age -12
address-123
age-12
phone-22222
============
name-ab
age -11
address-123
age-11
phone-222223
=============
name-abc
age -12
address-1234
age-12
phone-2222223
============= (2 Replies)
Discussion started by: nipun_garg
2 Replies
DUFF(1) BSD General Commands Manual DUFF(1)
NAME
duff -- duplicate file finder
SYNOPSIS
duff [-0HLPaeqprtz] [-d function] [-f format] [-l limit] [file ...]
duff [-h]
duff [-v]
DESCRIPTION
The duff utility reports clusters of duplicates in the specified files and/or directories. In the default mode, duff prints a customizable
header, followed by the names of all the files in the cluster. In excess mode, duff does not print a header, but instead for each cluster
prints the names of all but the first of the files it includes.
If no files are specified as arguments, duff reads file names from stdin.
Note that as of version 0.4, duff ignores symbolic links to files, as that behavior was conceptually broken. Therefore, the -H, -L and -P
options now apply only to directories.
The following options are available:
-0 If reading file names from stdin, assume they are null-terminated, instead of separated by newlines. Also, when printing file names
and cluster headers, terminate them with null characters instead of newlines.
This is useful for file names containing whitespace or other non-standard characters.
-H Follow symbolic links listed on the command line. This overrides any previous -L or -P option. Note that this only applies to
directories, as symbolic links to files are never followed.
-L Follow all symbolic links. This overrides any previous -H or -P option. Note that this only applies to directories, as symbolic
links to files are never followed.
-P Don't follow any symbolic links. This overrides any previous -H or -L option. This is the default. Note that this only applies to
directories, as symbolic links to files are never followed.
-a Include hidden files and directories when searching recursively.
-d function
The message digest function to use. The supported functions are sha1, sha256, sha384 and sha512. The default is sha1.
-e Excess mode. List all but one file from each cluster of duplicates. Also suppresses output of the cluster header. This is useful
when you want to automate removal of duplicate files and don't care which duplicates are removed.
-f format
Set the format of the cluster header. If the header is set to the empty string, no header line is printed.
The following escape sequences are available:
%n The number of files in the cluster.
%c A legacy synonym for %d, for compatibility reasons.
%d The message digest of files in the cluster. This may not be combined with -t as no digest is calculated.
%i The one-based index of the file cluster.
%s The size, in bytes, of a file in the cluster.
%% A '%' character.
The default format string when using -t is:
%n files in cluster %i (%s bytes)
The default format string for other modes is:
%n files in cluster %i (%s bytes, digest %d)
-h Display help information and exit.
-l limit
The minimum size of files to be sampled. If the size of files in a cluster is equal or greater than the specified limit, duff will
sample and compare a few bytes from the start of each file before calculating a full digest. This is stricly an optimization and
does not affect which files are considered by duff. The default limit is zero bytes, i.e. to use sampling on all files.
-q Quiet mode. Suppress warnings and error messages.
-p Physical mode. Make duff consider physical files instead of hard links. If specified, multiple hard links to the same physical file
will not be reported as duplicates.
-r Recursively search into all specified directories.
-t Thorough mode. Distrust digests as a guarantee for equality. In thorough mode, duff compares files byte by byte when their sizes
match.
-v Display version information and exit.
-z Do not consider empty files to be equal. This option prevents empty files from being reported as duplicates.
EXAMPLES
The command:
duff -r foo/
lists all duplicate files in the directory foo and its subdirectories.
The command:
duff -e0 * | xargs -0 rm
removes all duplicate files in the current directory. Note that you have no control over which files in each cluster that are selected by -e
(excess mode). Use with care.
The command:
find . -name '*.h' -type f | duff
lists all duplicate header files in the current directory and its subdirectories.
The command:
find . -name '*.h' -type f -print0 | duff -0 | xargs -0 -n1 echo
lists all duplicate header files in the current directory and its subdirectories, correctly handling file names containing whitespace. Note
the use of xargs and echo to remove the null separators again before listing.
DIAGNOSTICS
The duff utility exits 0 on success, and >0 if an error occurs.
SEE ALSO
find(1), xargs(1)
AUTHORS
Camilla Berglund <elmindreda@elmindreda.org>
BUGS
duff doesn't check whether the same file has been specified twice on the command line. This will lead it to report files listed multiple
times as duplicates when not using -p (physical mode). Note that this problem only affects files, not directories.
duff no longer (as of version 0.4) reports symbolic links to files as duplicates, as they're by definition always duplicates. This may break
scripts relying on the previous behavior.
If the underlying files are modified while duff is running, all bets are off. This is not really a bug, but it can still bite you.
BSD
January 18, 2012 BSD