Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: How to remove duplicated based on longest row & largest value in a column
Top Forums UNIX for Dummies Questions & Answers How to remove duplicated based on longest row & largest value in a column Post 302352560 by Manabhanjan on Friday 11th of September 2009 10:27:54 PM
Old 09-11-2009
you are telling this is your out put but i am confused by seeing some records of your output


SIG 2007 3 24 4 35 45.80 5.2600 94.3100 58 0 5.20 0 0.00 5.00 0.00 0 0.00 5.20 0
SSS 2007 3 24 9 3 37.40 36.5600 71.4800 152 0 4.70 0 0.00 0.00 0.00 0 0.00 4.70 0


PDE-Q 2009 7 5 9 45 48.77 36.4600 71.0700 248 0 4.90 0 0.00 0.00 0.00 0 0.00 4.90 0
PDE-Q 2009 7 5 12 25 37.44 1.3300 99.7800 185 0 4.50 0 0.00 0.00 0.00 0 0.00 4.60 0

but in this the 2nd,3rd,4th fields are same .(please write properly your requirement,it is really confusing).

---------- Post updated at 07:57 AM ---------- Previous update was at 07:57 AM ----------

you are telling this is your out put but i am confused by seeing some records of your output


SIG 2007 3 24 4 35 45.80 5.2600 94.3100 58 0 5.20 0 0.00 5.00 0.00 0 0.00 5.20 0
SSS 2007 3 24 9 3 37.40 36.5600 71.4800 152 0 4.70 0 0.00 0.00 0.00 0 0.00 4.70 0


PDE-Q 2009 7 5 9 45 48.77 36.4600 71.0700 248 0 4.90 0 0.00 0.00 0.00 0 0.00 4.90 0
PDE-Q 2009 7 5 12 25 37.44 1.3300 99.7800 185 0 4.50 0 0.00 0.00 0.00 0 0.00 4.60 0

but in this the 2nd,3rd,4th fields are same .(please write properly your requirement,it is really confusing).
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

ITERATION: remove row based on string value

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

2. Shell Programming and Scripting

How to print column based on row number

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)
Discussion started by: Surabhi_so_mh
2 Replies

3. Shell Programming and Scripting

duplicate row based on single column

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)
Discussion started by: mitr
2 Replies

4. Shell Programming and Scripting

need to remove duplicates based on key in first column and pattern in last column

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)
Discussion started by: script_op2a
13 Replies

5. Shell Programming and Scripting

Sort a the file & refine data column & row format

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)
Discussion started by: ckaramsetty
7 Replies

6. Shell Programming and Scripting

Deleting a row based on fetched value of column

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)
Discussion started by: swasid
2 Replies

7. Shell Programming and Scripting

Remove duplicates within row and separate column

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)
Discussion started by: manigrover
1 Replies

8. Shell Programming and Scripting

Find smallest & largest in every column

Dear All, I have input like this, J_15TEST_ASH05_33A22.13885.txt: $$ 1 MAKE SP1501 1 1 4 6101 7392 2 2442 2685 18 3201 4008 20 120 4158 J_15TEST_ASH05_33A22.13885.txt: $$ 1 MAKE SP1502 1 1 4 5125 6416 2 ... (4 Replies)
Discussion started by: attila
4 Replies

9. Shell Programming and Scripting

Trying to remove duplicates based on field and row

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)
Discussion started by: newbie2010
6 Replies

10. Shell Programming and Scripting

How to remove duplicated column in a text file?

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 DEBIAN

gspectrum

GSPECTRUM(1)						       gnome-chemistry-utils						      GSPECTRUM(1)

NAME

       gspectrum - a small spectrum viewer application

SYNOPSIS

       gspectrum [OPTION(S)...] [FILE...]

DESCRIPTION

       gspectrum is a simple spectrum visualizer. It is only able to display files in the JCAMP-DX format.

OPTIONS

       The following options are accepted:

       -?, --help
	   Show application help options.

       --help-all, --help-*
	   Print all or just a group of help options. These options are not documented here. Instead see gtk-options(7) and gnome-options(7).

       -v, --version
	   Print gspectrum version information.

SEE ALSO

       gnome-options(7), gtk-options(7)

AUTHORS

       Jean Brefort <jean.brefort@normalesup.org>
	   Program author.

       Daniel Leidert <daniel.leidert@wgdd.de>
	   Manpage author.

COPYRIGHT

       Copyright (C) 2002-2007 Jean Brefort
       Copyright (C) 2004-2007 Daniel Leidert

       Permission is granted to copy, distribute and/or modify this document under the terms of the GNU General Public License, Version 2 or any
       later version published by the Free Software Foundation.

gcu 0.12				      $Date: 2009-03-19 10:53:47 +0100 (jeu. 19 mars 2009) $				      GSPECTRUM(1)
All times are GMT -4. The time now is 07:09 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy