Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Uniq based on first field
Top Forums Shell Programming and Scripting Uniq based on first field Post 302540947 by venummca on Friday 22nd of July 2011 03:54:47 AM
Old 07-22-2011
Quote:
Originally Posted by jim mcnamara
why can you not use sort?
Code:
sort -u -t ',' -k1.1,1.5 infile > outfile

Thanks for the reply. I want to display only the unrepeated lines.
I think -u will give us single line if it founds duplicates.
and here 1.1 to 1.5 means the length of first filed. isn't it?
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Uniq using only the first field

Hi all, I have a file that contains a list of codes (shown below). I want to 'uniq' the file using only the first field. Anyone know an easy way of doing it? Cheers, Dave ##### Input File ##### 1xr1 1xws 1yxt 1yxu 1yxv 1yxx 2o3p 2o63 2o64 2o65 1xr1 1xws 1yxt 1yxv 1yxx 2o3p 2o63 2o64... (8 Replies)
Discussion started by: Digby
8 Replies

2. UNIX for Dummies Questions & Answers

How to uniq third field in a file

Hi ; I have a question regarding the uniq command in unix How do I uniq 3rd field in a file ? original file : zoom coord 39 18652 39 18652 zoom coord 39 18653 39 18653 zoom coord 39 18818 39 18818 zoom coord 39 18840 39 18840 zoom coord 41 15096 41 15096 zoom... (1 Reply)
Discussion started by: babycakes
1 Replies

3. Shell Programming and Scripting

How to use uniq on a certain field?

How can I use uniq on a certain field or what else could I use? If I want to use uniq on the second field and the output would remove one of the lines with a 5. bob 5 hand jane 3 leg jon 4 head chris 5 lungs (1 Reply)
Discussion started by: Bandit390
1 Replies

4. UNIX for Dummies Questions & Answers

find uniq lines in file, using the first field of line

Hello all, new to unix and have just found the forum. I think I will be here quite often, and hope that in time i will be able to provide soem help, role on not being a newbie anymore :) I have a question which iI am hoping someone could help me with. If i have a file with lines in in thus... (8 Replies)
Discussion started by: grom
8 Replies

5. Shell Programming and Scripting

Sort field and uniq

I have a flatfile A.txt 2012/12/04 14:06:07 |trees|Boards 2, 3|denver|mekong|mekong12 2012/12/04 17:07:22 |trees|Boards 2, 3|denver|mekong|mekong12 2012/12/04 17:13:27 |trees|Boards 2, 3|denver|mekong|mekong12 2012/12/04 14:07:39 |rain|Boards 1|tampa|merced|merced11 How do i sort and get... (3 Replies)
Discussion started by: sabercats
3 Replies

6. Shell Programming and Scripting

Printing uniq first field with the the highest second field

Hi All, I am searching for a script which will produce an output file with the uniq first field with the second field having highest value among all the duplicates.. The output file will produce only the uniqs which are duplicate 3 times.. Input file X 9 B 5 A 1 Z 9 T 4 C 9 A 4... (13 Replies)
Discussion started by: ailnilanjan
13 Replies

7. Shell Programming and Scripting

Filter uniq field values (non-substring)

Hello, I want to filter column based on string value. All substring matches are filtered out and only unique master strings are picked up. infile: 1 abcd 2 abc 3 abcd 4 cdef 5 efgh 6 efgh 7 efx 8 fgh Outfile: 1 abcd 4 cdef 5 efgh 7 efxI have tried awk '!a++; match(a, $2)>0'... (32 Replies)
Discussion started by: yifangt
32 Replies

8. Shell Programming and Scripting

awk to adjust coordinates in field based on sequential numbers in another field

I am trying to output a tab-delimited result that uses the data from a tab-delimited file to combine and subtract specific lines. If $4 matches in each line then the first matching sequential $6 value is added to $2, unless the value is 1, then the original $2 is used (like in the case of line... (3 Replies)
Discussion started by: cmccabe
3 Replies

9. Shell Programming and Scripting

Need help in awk: running a loop with one column and segregate data 4 each uniq value in that field

Hi All, I have a file like this(having 2 column). Column 1: like a,b,c.... Column 2: having numbers. I want to segregate those numbers based on column 1. Example: file. a 5 b 9 b 620 a 710 b 230 a 330 b 1910 (4 Replies)
Discussion started by: Raza Ali
4 Replies

10. UNIX for Beginners Questions & Answers

Problem with getting awk to multiply a field by a value set based on condition of another field

Hi, So awk is driving me crazy on this one. I have searched everywhere and read man, docs and every related post Google can find and still no luck. The actual files I need to run this on are sensitive in nature, but it is the same thing as if I needed to calculate weighted grades for multiple... (15 Replies)
Discussion started by: cotilloe
15 Replies

LEARN ABOUT DEBIAN

jzip

JZIP(6) 						 John's Z-code Interpreter Program						   JZIP(6)

NAME

       jzip - execute Infocom v1-5 and Inform v1-5 & v8 game files

SYNOPSIS

       jzip [ options ] z-file-name

DESCRIPTION

       jzip invokes the Z-code Interpreter.

REQUIREMENTS

       jzip  will  run	under  most  (if  not all) flavors of Unix, including AIX, Solaris, SunOS, HP/UX, Linux, Free/NetBSD, IRIX, NeXT Mach, DEC
       OSF/1, and others.

EDITING

       JZip now supports arrowkey editing in UNIX.

       Up/Down
	      selects the previous / next command in history

       Left/Right
	      moves the cursor over the line.

       Backspace
	      deletes

       Typing inserts under the cursor

OPTIONS

       -l n   lines in display

       -c n   columns in display

       -r n   text right margin (default = 1)

       -t n   text top margin (default = 0)

       -v     display version information

       -m     monochrome mode

       -y     set Tandy bit

       -s n   zmachine strict level, from 0 (none), 1 (report once, recommended) to 3.

ENVIRONMENT

       jzip looks for the environment variable INFOCOM_PATH and will use the path found there to look for the story file specified on the  command
       line if the story file cannot be found in the current directory.

CREDITS

       jzip is written and maintained by John Holder (j-holder@home.com), based on the ZIP v2.0 sources by Mark Howell and Olaf 'Olsen' Barthel.

AVAILABILITY

       The most recent version of jzip can be downloaded from one of:

       http://www.jzip.sourceforge.net/

       ftp://ifarchive.org/infocom/interpreters/zip/

FILES

       /usr/games/jzip
	      The Z-Code Interpreter Program

       /usr/lib/games/zfiles
	      Recommended location for Zcode files

RELATED USENET NEWSGROUPS

       Interactive Fiction (IF) authors should check out rec.arts.int-fiction, and IF players should check out rec.games.int-fiction.

2.1																	   JZIP(6)
All times are GMT -4. The time now is 03:19 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy