Deleting all occurences of a duplicate row Post: 302213482

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

sort and semi-duplicate row - keep latest only

I have a pipe delimited file. Key is field 2, date is field 5 (as example, my real file is more complicated of course, but the KEY and DATE are accurate) There can be duplicate rows for a key with different dates. I need to keep only rows with latest date in this case. Example data: ...

2. Shell Programming and Scripting

Delete a row that has a duplicate column

I'm trying to remove lines of data that contain duplicate data in a specific column. For example. apple 12345 apple 54321 apple 14234 orange 55656 orange 88989 orange 99898 I only want to see apple 12345 orange 55656 How would i go about doing this?

3. Shell Programming and Scripting

how to identify duplicate columns in a row

Hi, How to identify duplicate columns in a row? Input data: may have 30 columns 9211480750 LK 120070417 920091030 9211480893 AZ 120070607 9205323621 O7 120090914 120090914 1420090914 2020090914 2020090914 9211479568 AZ 120070327 320090730 9211479571 MM 120070326 9211480892 MM 120070324...

4. Shell Programming and Scripting

Deleting Duplicate Records

Hello, I'm have a file of xy data with over 1000 records. I want to delete both x and y values for any record that has the same x value as any previous record thus removing the duplicates from my file. Can anyone help? Thanks, Dan

5. Shell Programming and Scripting

REMOVE DUPLICATE IN a ROW AFTER CHECKING THE FIRST SIMILAR NAME

Hi all I have a big file like this in rows and columns from 2 column onwards the next column is desciption of previous column means 3rd columns is description of 2 columns and 5 column is description of 4 column. All cloumns are separated by comma ...

6. Shell Programming and Scripting

deleting dupes in a row

Hello, I have a large database in which name homonyms are arranged in a row. Since the database is large and generated by hand, very often dupes creep in. I want to remove the dupes either using an awk or perl script. An input is given below The expected output is given below: As can be...

7. Shell Programming and Scripting

Moving new row and deleting old row to another table

Hi, I want to move a new row to another table if the field from new row doesn't have the first word that I categorized (like: IRC blablabla, PTM blablabla, ADM blablabla, BS blablabla). I already use this script but doesn't work as I expected. CHECK_KEYWORD="$( mysql -uroot -p123456 smsd -N...

8. Shell Programming and Scripting

In php, Moving a new row to another table and deleting old row

Hi, I already succeed moving a new row to another table if the field from new row doesn't have the first word that I categorized (like: IRC blablabla, PTM blablabla, ADM blablabla, BS blablabla). But it can't delete the old row. Please help me with the script. my php script: INSERT INTO...

9. Shell Programming and Scripting

Delete duplicate row

Hi all, how can delete duplicate files in file form, e.g. $cat file1 aaa 123 234 345 456 bbb 345 345 657 568 ccc 345 768 897 456 aaa 123 234 345 456 ddd 786 784 234 263 ccc 345 768 897 456 aaa 123 234 345 456 ccc 345 768 897 456 then i need ouput file1 some,

10. Shell Programming and Scripting

Delete duplicate row based on criteria

Hi, I have an input file as shown below: 20140102;13:30;FR-AUD-LIBOR-1W;2.495 20140103;13:30;FR-AUD-LIBOR-1W;2.475 20140106;13:30;FR-AUD-LIBOR-1W;2.495 20140107;13:30;FR-AUD-LIBOR-1W;2.475 20140108;13:30;FR-AUD-LIBOR-1W;2.475 20140109;13:30;FR-AUD-LIBOR-1W;2.475...

LEARN ABOUT OSF1

diction

diction(1)						      General Commands Manual							diction(1)

NAME

       diction, explain, suggest - Prints wordy sentences and looks them up in an interactive thesaurus.

SYNOPSIS

       diction [-fpattern_file] [-k] [-ma] [-me] [-ml] [-ms] [-n] [file...]

       explain

       suggest

       The  diction command finds all sentences in an English language document that contain phrases from a database of bad or wordy diction.  The
       explain command is an interactive thesaurus for the English language phrases found by the diction command and only for those phrases.

       The diction command reads from standard in if no file operand is provided.

       The suggest command is a synonym for explain.

OPTIONS

       Names a user-created pattern file to be used in addition to the default file.  Passes the -k option to the deroff command.  The	-k  option
       keeps  blocks  of  text	specified nroff by requests or macros; for example, the request.  Passes the -ma option to deroff.  The -ma option
       interprets nroff man macros only.  Overrides the default nroff -ms macro package.  Causes deroff to skip lists; should be used if  a  docu-
       ment  contains  many  lists of nonsentences.  Overrides the default nroff -ms macro package.  Suppresses use of the default file (used with
       -f).  Only the user-created pattern file is used.

DESCRIPTION

       Each phrase found by the diction command is enclosed in [ ] (brackets).	Because diction runs deroff before looking at  the  text,  include
       formatting header files as part of the input.

       Before using the explain command, use the diction command to obtain a list of poorly worded phrases.  When you use the explain command, the
       system prompts you for a phrase and responds with a grammatically acceptable alternative.  You can continue typing phrases, or you can exit
       by pressing the End-of-File key sequence.

       The explain command can also take input redirected from a file. No other command line arguments are valid.

NOTES

       Use of nonstandard formatting macros may cause incorrect sentence breaks.  In particular, diction does not understand -me.

FILES

       Default pattern file.  Thesaurus used by the explain command.

SEE ALSO

       Commands:  deroff(1), nroff(1)

																	diction(1)