Removing lines that are (same in content) based on columns

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Removing duplicate lines on first column based with pipe delimiter

Hi, I have tried to remove dublicate lines based on first column with pipe delimiter . but i ma not able to get some uniqu lines Command : sort -t'|' -nuk1 file.txt Input : 38376KZ|09/25/15|1.057 38376KZ|09/25/15|1.057 02006YB|09/25/15|0.859 12593PS|09/25/15|2.803...

2. Shell Programming and Scripting

Removing duplicates from delimited file based on 2 columns

Hi guys,Got a bit of a bind I'm in. I'm looking to remove duplicates from a pipe delimited file, but do so based on 2 columns. Sounds easy enough, but here's the kicker... Column #1 is a simple ID, which is used to identify the duplicate. Once dups are identified, I need to only keep the one...

3. Shell Programming and Scripting

Copying lines from multiple logfiles, based on content of the line

d df d d

4. UNIX for Advanced & Expert Users

Removing files based on name and content

Consider i have 2 directories a1 and a2. under a1, i have below files test1 test2 test3. Under a2,i have below files. test1 test2 test3 test4 test5My requirement is i will pass the directory names(2 parameters) and directory in which files needs to be removed.(3rd parameter) a)first...

5. Shell Programming and Scripting

Concatenating more than two lines into one based on some columns

Hi, I need to concatenate some lines in a file based on the First 4 coloumns of a file .. (For Eg.) Consider a file ... I,01,000002,0666,00000.00,000,00,000,000, ,0 I,01,000002,0667,00000.00,000,00,000,000, ,0 I,01,000002,0666,00056.10 I,01,000002,0667,00056.10 I,01,000002,0666,00001...

6. UNIX for Dummies Questions & Answers

remove duplicate lines based on two columns and judging from a third one

hello all, I have an input file with four columns like this with a lot of lines and for example, line 1 and line 5 match because the first 4 characters match and the fourth column matches too. I want to keep the line that has the lowest number in the third column. So I discard line 5....

7. UNIX for Dummies Questions & Answers

Removing Lines based on matching first column

I have a file1 that looks like this: File 1 a b b c c e d e and a file 2 that looks like this: File 2 b c e e Note that file 2 is the right hand column from file1. I want to remove any lines from file1 that begin with the column in file2. In this case the desired output...

8. Shell Programming and Scripting

awk : extracting unique lines based on columns

Hi, snp.txt CHR_A SNP_A BP_A_st BP_A_End CHR_B BP_B SNP_B R2 p-SNP_A p-SNP_B 5 rs1988728 74904317 74904318 5 74960646 rs1427924 0.377333 0.000740085 0.013930081 5 ...

9. Shell Programming and Scripting

finding duplicates in columns and removing lines

I am trying to figure out how to scan a file like so: 1 ralphs office","555-555-5555","ralph@mail.com","www.ralph.com 2 margies office","555-555-5555","ralph@mail.com","www.ralph.com 3 kims office","555-555-5555","kims@mail.com","www.ralph.com 4 tims...

10. Shell Programming and Scripting

Help removing lines with duplicated columns

Hi Guys... Please Could you help me with the following ? aaaa bbbb cccc sdsd aaaa bbbb cccc qwer as you can see, the 2 lines are matched in three fields... how can I delete this pupicate ? I mean to delete the second one if 3 fields were duplicated ? Thanks

LEARN ABOUT DEBIAN

oggz-diff

oggz-diff(1)						      General Commands Manual						      oggz-diff(1)

NAME

       oggz-diff -- Hexdump the packets of two Ogg files and output differences

SYNOPSIS

       oggz-diff [options]  [OGGZDUMP_OPTIONS]	[DIFF_OPTIONS] file1.ogg file2.ogg

       options: [--verbose ]  [-v  | --version ]  [-h  | --help ]

       OGGZDUMP_OPTIONS:  [-b  | --binary ]  [-x  | --hexadecimal ]  [-c content-type  | --content-type content-type ]	[-s serialno  | --serialno
       serialno ]  [-O	| --hide-offset ]  [-S	| --hide-serialno ]  [-G  | --hide-granulepos ]  [-P  | --hide-packetno ]

       DIFF_OPTIONS: [-q  | --brief ]  [-C NUM	| --context[=NUM] ]  [-u  | -U NUM  | --unified[=NUM] ]  [-e  | --ed ]	[--normal ]  [--rcs ]  [-y
       | --side-by-side ]  [-l	| --paginate ]

Description
       oggz-diff  is a sh script which uses oggz-dump to generate hexadecimal packet dumps of each input file, then outputs the difference between
       these dumps using diff.

Options
       oggz-diff forwards a subset of options accepted by oggz-dump and diff.  See oggz-dump(1) and diff(1) for more detail.

   oggz-dump format options
       -b, --binary
		 Generate a binary dump of each packet

       -x, --hexadeciaml
		 Generate a hexadecimal dump of each packet

   oggz-dump filtering options
       -c content-type, --content-type content-type
		 Dump only the logical bitstreams for a specific content-type.	Run oggz-known-codecs(1) for a full list of codecs  known  by  the
		 installed version of oggz.

       -s serialno, --serialno serialno
		 Dump only the logical bitstream with specified serialno.

       -O, --hide-offset
		 Hide the byte offset field of the preamble for each packet dumped. This is particularly useful when comparing Ogg bitstreams that
		 differ only in page structure.

       -S, --hide-serialno
		 Hide the serialno field of the preamble for each packet dumped. This is particularly useful when comparing  Ogg  bitstreams  that
		 differ only in serialno assignment.

       -G, --hide-granulepos
		 Hide the granulepos field of the preamble for each packet dumped.

       -P, --hide-packetno
		 Hide the packetno field of the preamble for each packet dumped.

   diff options
       The -w (--ignore-all-space) option to diff   is always implied.

       -q, --brief
		 Output only whether files differ.

       -C NUM, --context[=NUM]
		 Output NUM lines of copied context.

       -u, -U NUM, --unified[=NUM]
		 Output NUM (default 3) lines of unified context.

       -e, --ed  Output an ed script.

       --normal  Output a normal diff.

       --rcs	 Output an RCS format diff.

       -y, --side-by-side
		 Output in two columns.

       -l, --paginate
		 Pass the output through pr to paginate it.

   Miscellaneous options
       --verbose Display verbose messages.

       -v, --version
		 Display version information and exit.

       -h, --help
		 Display usage information and exit.

AUTHOR

       Conrad Parker

COPYRIGHT

       Copyright (C) 2003 CSIRO Australia

SEE ALSO

       oggz-dump(1), diff(1), patch(1)

																      oggz-diff(1)

UNIX for Dummies Questions & Answers