Thanks a lot lot its working some what correctly but deletes most of my data.For above data its working.
but if i hav data like given below included with the data as above the output i want is shown.
The data included with above data is
THe output should be like
Help me out if anyone knows...
Its like its checking for duplicates in columns 2,3,4 together & largest value in column 19 & longest row i mean with more number of values in that row.
But as per your sort command it deletes all the rows of 2009 or any other number in column 2 & just retains one row of column2. I want to check duplicates for 2,3,4 column together not seperately just column2.
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)
Hi,
I want to print column value based on row number say multiple of 8.
Input file:
line 1 67 34
line 2 45 57
. . .
. . .
line 8 12 46
. . .
. . .
line 16 24 90
. . .
. . .
line 24 49 67
Output
46
90
67 (2 Replies)
I am a newbie to shell scripting ..
I have a .csv file. It has 1000 some rows and about 7 columns...
but before I insert this data to a table I have to parse it and clean it ..basing on the value of the first column..which a string of phone number type...
example below..
column 1 ... (2 Replies)
Given a file such as this I need to remove the duplicates.
00060011 PAUL BOWSTEIN ad_waq3_921_20100826_010517.txt
00060011 PAUL BOWSTEIN ad_waq3_921_20100827_010528.txt
0624-01 RUT CORPORATION ad_sade3_10_20100827_010528.txt
0624-01 RUT CORPORATION ... (13 Replies)
cat file1.txt
field1 "user1":
field2:"data-cde"
field3:"data-pqr"
field4:"data-mno"
field1 "user1":
field2:"data-dcb"
field3:"data-mxz"
field4:"data-zul"
field1 "user2":
field2:"data-cqz"
field3:"data-xoq"
field4:"data-pos"
Now i need to have the date like below.
i have just... (7 Replies)
Hi,
I have a file which consists of two columns but the first one can be varying in length like
123456789 0abcd
123456789 0abcd
4015 0 0abcd
5000 0abcd
I want to go through the file reading each line, count the number of characters in the first column and delete... (2 Replies)
Hi all
I have following kind of input file
ESR1 PA156 leflunomide PA450192 leflunomide
CHST3 PA26503 docetaxel Pa4586; thalidomide Pa34958; decetaxel docetaxel docetaxel
I want to remove duplicates and I want to separate anything before and after PAxxxx entry into columns or... (1 Reply)
I am trying to see if I can use awk to remove duplicates from a file. This is the file:
-==> Listvol <==
deleting /vol/eng_rmd_0941
deleting /vol/eng_rmd_0943
deleting /vol/eng_rmd_0943
deleting /vol/eng_rmd_1006
deleting /vol/eng_rmd_1012
rearrange /vol/eng_rmd_0943
... (6 Replies)
Dear all,
How can I remove duplicated column in a text file?
Input:
LG10_PM_map_19_LEnd 1000560 G AA AA AA AA AA GG
LG10_PM_map_19_LEnd 1005621 G GG GG GG AA AA GG
LG10_PM_map_19_LEnd 1011214 A AA AA AA AA GG GG
LG10_PM_map_19_LEnd 1011673 T TT TT TT TT CC CC... (1 Reply)
Discussion started by: huiyee1
1 Replies
LEARN ABOUT OSF1
dc
dc(7) Miscellaneous Information Manual dc(7)NAME
dc - serial line/mouse/keyboard
SYNOPSIS
controller dc0 at ibus0 slot 0 vector dcintr
DESCRIPTION
The dc serial line controller provides DECstation 2100, DECstation 3100, DECstation 5000, and DECstation 5100 computer systems with key-
board, mouse, and serial communications interfaces. The serial communications interfaces on the DECstation 2100 and DECstation 3100 provide
partial modem control. The serial communications interfaces on the DECstation 5000 provide full modem control. The device special file
/dev/tty01 on a DECstation 5100 provides full modem control, while the remaining ports provide no modem control at all. All serial commu-
nications interfaces operate at baud rates from B50 to B9600, excluding B200.
The dc ports are used as follows: Usage Graphics device keyboard at 4800 BPS Mouse or tablet at 4800 BPS Communications port 1 (w/modem
control)/local terminal Communications port 2 (w/modem control)/local terminal
On all systems except the DECstation 5100, serial port 2 is used for the system console port in server (that is, non-graphics) configura-
tions. On DECstation 5100s, the serial port labeled 3 on the back of the system is always the system console port. The serial system con-
sole port always operates at 9600 BPS, 8-bits, no parity; modem control is not supported.
RESTRICTIONS
Data communications equipment attached to the console serial port in server configurations must be set to 9600 BPS, 8-bits, no parity. The
scc driver enforces this restriction.
FILES
console terminal local terminal local terminal local terminal (DECstation 5100 only)
RELATED INFORMATION console(7), devio(7), tty(7), MAKEDEV(8) delim off
dc(7)