06-10-2010
remove row if string is same as previous row
I have data like:
Blue Apple 6
Red Apple 7
Yellow Apple 8
Green Banana 2
Purple Banana 8
Orange Pear 11
What I want to do is if $2 in a row is the same as $2 in the previous row remove that row. An identical $2 may exist more than one time.
So the out file would look like:
Blue Apple 6
Green Banana 2
Orange Pear 11
I'm new and don't really have any idea about the type of code that would work or if this would require something like Perl.
Thank you for your help.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I would like to know value for previous row, in addition to current row.
How would I will get value for previous row? How can I perform this with awk? (2 Replies)
Discussion started by: videsh77
2 Replies
2. Shell Programming and Scripting
It is my first post, hoping to get help from the forum.
In a directory, I have 5000 multiple files that contains around 4000 rows with 10 columns in each file containing a unique string 'AT' located at 4th column.
OM 3328 O BT 268 5.800 7.500 4.700 0.000 ... (9 Replies)
Discussion started by: asanjuan
9 Replies
3. Shell Programming and Scripting
Dear masters,
I stuck again in a very tricky situation,so need your valuable inputs. I have a file having rows as below:
_Db
_Database 1023 1 1 1 17.0B 0.2 1.0
_Field
_Field-Name 3 2 2 11 56.2K 64.1 ... (5 Replies)
Discussion started by: patric2326
5 Replies
4. Shell Programming and Scripting
Hello,
I want to add a new row to a file to insert data without deleting the previous data there.
Example:
file
a
b
c
d
Output
a
b
newtext
c (6 Replies)
Discussion started by: joseamck
6 Replies
5. Shell Programming and Scripting
HI Guys,
I have Below Input :-
RepigA_hteis522 ReptCfiEtrBsCll_aofe
MSL04_MSL2_A25_1A 0 9
MSL04_MSL2_A25_1B 0 9
MSL04_MSL2_A25_1C 0 9
RepigA ReptCfiEtrBsCll
hteis522 aofe
MSL04_MSL2_A25_1A 0 9
MSL04_MSL2_A25_1B 0 9
MSL04_MSL2_A25_1C 0 9
Split Data in two first row... (2 Replies)
Discussion started by: pareshkp
2 Replies
6. UNIX for Beginners Questions & Answers
My original files are like this below and I distinguish them from the AP_ID (file1 has 572 and file2 has 544). Also, the header on file1 has “G_” pre-pended. NOTE: these are only snippets of very large files and much of the data is not present here.
Original File 1:
... (36 Replies)
Discussion started by: aachave1
36 Replies
7. Shell Programming and Scripting
Hi,
I am trying to extract data where first field unique value and 4th field of next row is grater than first row 4th field.
input data is a below:
7035719974,20-jul-2016 07:42:51,07:42:51,074251,1
7035719974,20-jul-2016 07:43:57,07:43:57,074357,2
7399206761,20-jul-2016... (2 Replies)
Discussion started by: rramkrishnas
2 Replies
8. Shell Programming and Scripting
Hi ALL,
We have requirement in a file, i have multiple rows.
Example below:
Input file rows
01,1,102319,0,0,70,26,U,1,331,000000113200000011920000001212
01,1,102319,0,1,80,20,U,1,241,00000059420000006021
I need my output file should be as mentioned below. Last field should split for... (4 Replies)
Discussion started by: kotra
4 Replies
9. Shell Programming and Scripting
Hi,
I have the following content in file
ABBR DESC COL3 COL4 COL5 COL6
AAA text desc aaa text text text text
text text text text
text text text text
BBB text desc bbb text text text text
text text text text
CCC ... (10 Replies)
Discussion started by: bobbygsk
10 Replies
10. UNIX for Beginners Questions & Answers
This is a question that is related to one I had last August when I was trying to sort/merge two files by millsecond time column (in this case column 6).
The script (below) that helped me last august by RudiC solved the puzzle of sorting/merging two files by time, except it gets lost when the... (0 Replies)
Discussion started by: aachave1
0 Replies
LEARN ABOUT SUSE
xkbaddgeomkey
XkbAddGeomKey(3) XKB FUNCTIONS XkbAddGeomKey(3)
NAME
XkbAddGeomKey - Add one key at the end of an existing row of keys
SYNOPSIS
XkbKeyPtr XkbAddGeomKey (XkbRowPtr row);
ARGUMENTS
- row row to be updated
DESCRIPTION
Xkb provides functions to add a single new element to the top-level keyboard geometry. In each case the num_ * fields of the corresponding
structure is incremented by 1. These functions do not change sz_* unless there is no more room in the array. Some of these functions fill
in the values of the element's structure from the arguments. For other functions, you must explicitly write code to fill the structure's
elements.
The top-level geometry description includes a list of geometry properties. A geometry property associates an arbitrary string with an
equally arbitrary name. Programs that display images of keyboards can use geometry properties as hints, but they are not interpreted by
Xkb. No other geometry structures refer to geometry properties.
Keys are grouped into rows. XkbAddGeomKey adds one key to the end of the specified row. The key is allocated and zeroed. XkbAddGeomKey
returns NULL if row is empty or if it was not able to allocate space for the key. To allocate space for an arbitrary number of keys to a
row, use XkbAllocGeomKeys.
STRUCTURES
typedef struct _XkbKey { /* key in a row */
XkbKeyNameRec name; /* key name */
short gap; /* gap in mm/10 from previous key in row */
unsigned char shape_ndx; /* index of shape for key */
unsigned char color_ndx; /* index of color for key body */
} XkbKeyRec, *XkbKeyPtr;
SEE ALSO
XkbAllocGeomKeys(3)
X Version 11 libX11 1.3.2 XkbAddGeomKey(3)