Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Name grouping
Top Forums Shell Programming and Scripting Name grouping Post 302925280 by cmccabe on Saturday 15th of November 2014 12:50:28 PM
Old 11-15-2014
Name grouping
Code:
 awk 'FNR==NR {a[$1]; next} $NF in a' genes.txt refseq_exons.txt > output.txt

I can not figure out how to group the same name in $4 together.

Basically, all the SKI together in separate rows and all the TGFB2. Thank you Smilie.

Code:
chr1	2160133	2161174	SKI
chr1	218518675	218520389	TGFB2
chr1	218536675	218536759	TGFB2
chr1	218578510	218578674	TGFB2
chr1	218607423	218607556	TGFB2
chr1	218607679	218607790	TGFB2
chr1	218609311	218609489	TGFB2
chr1	218610684	218610838	TGFB2
chr1	218614545	218617961	TGFB2
chr1	2234416	2234542	SKI
chr1	2234723	2234839	SKI
chr1	2235278	2235541	SKI
chr1	2235731	2236024	SKI
chr1	2237458	2237689	SKI
chr1	2238015	2241652	SKI

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

egrep and grouping

i am using the c shell on solaris. directories i'm working with: ls -1d DIV* DIV_dental/ DIV_ibc/ DIV_ifc/ DIV_index/ DIV_pharm/ DIV_sectionI/ DIV_sectionI-title/ DIV_sectionI-toc/ DIV_sectionII-title/ DIV_sectionII-toc/ DIV_standing/ DIV_standing-toc/ DIV_title/ DIV_vision/ (1 Reply)
Discussion started by: effigy
1 Replies

2. UNIX for Dummies Questions & Answers

grouping and sorting??

how would I write a command line that creates a new file named stuff.txt in the current working directory which contains the number of directories in the current working directory, followed by the number of empty files in the current working directory, followed by the name of the working directory? (3 Replies)
Discussion started by: jorogon0099
3 Replies

3. UNIX for Dummies Questions & Answers

Help with data grouping

Hi all, I have a set data as shown below, and i would like to eliminate the name that no children - boy and girl. What is the appropriate command can i use(other than grep)? Please assist... My input: name sex marital status children - boy children - girl ... (3 Replies)
Discussion started by: 793589
3 Replies

4. UNIX for Advanced & Expert Users

grouping lines

Hi all, I have input lines like below: A;100;Paris;City;10;0;0 A;100;Paris;City;0;10;0 A;100;Paris;City in Europe;0;0;20 B;101;London;City;20;0;0 B;101;London;City;0;20;0 B;101;London;City in Europe;0;0;40 I need to group the above lines to: A;100;Paris;City in Europe;10;10;20... (4 Replies)
Discussion started by: andy2000
4 Replies

5. Shell Programming and Scripting

Grouping each 2 lines

Whats a good way to group (by adding a new integer to the front of each line) pairs of lines, such that lines 1 & 2 are group 1, lines 3 & 4 are group 2, etc... ex input: A B C D etc... ex output: 1A 1B 2C 2D etc... (5 Replies)
Discussion started by: watingo
5 Replies

6. UNIX for Dummies Questions & Answers

Grouping in grep

How do you do grouping in grep? Here's how I tried it at first: egrep 'qualit(y|ies)' /usr/share/dict/words -bash: syntax error near unexpected token `(' I'm using GNUgrep, and I found this on their site. grep regular expression syntax So I tried this: egrep 'qualit\(y\|ies\)'... (2 Replies)
Discussion started by: sudon't
2 Replies

7. Shell Programming and Scripting

Grouping

Hi all, I am using following command: perl program.pl input.txt output.txt CUTOFF 3 > groups_3.txt containing program.pl, two files (input.txt, output.txt) and getting output in groups_3.txt: But, I wish to have 30 files corresponding to each CUTOFF ranging from 0 to 30 using the same... (1 Reply)
Discussion started by: bioinfo
1 Replies

8. Shell Programming and Scripting

Grouping and Calculating

Hi All, I want to read the input file and store the output in the Output file. I pasted the sample Input and Output file below. Help me with this. Input file ================================= ITEM1 AAAAA 1 ITEM1 BBBBB 1 ITEM1 CCCCC 1 ITEM2 AAAAA 5 ITEM2 CCCCC 4... (1 Reply)
Discussion started by: humaemo
1 Replies

9. Shell Programming and Scripting

Grouping and counting

Hello, I would like to group/sort a file of records by a particular field and then count how many records belong in that grouping. For example say I have the following data: 1234|"ZZZ"|"Date"|"1"|"Y"|"ABC"|""|AA ABCD|"ZZZ"|"Date"|"1"|"Y"|"ABC"|""|AA EFGH|"ZZZ"|"Date"|"1"|"Y"|"ABC"|""|BB... (14 Replies)
Discussion started by: Nik44
14 Replies

10. Shell Programming and Scripting

Help with grouping and zipping

Hi can you please help with the below ? source file: Column1,Column2,Column3,Column4 abc,123,dir1/FXX/F19,1 abc,123,dir1/FXX/F20,1 abc,123,dir1/FXX/F23,2 abc,123,dir1/FXX/C25,2 abc,123,dir1/FXX/X25,2 abc,123,dir1/FXX/A23,3 abc,123,dir1/FXX/Z25,3 abc,123,dir1/FXX/Y25,4 I want to... (3 Replies)
Discussion started by: paul1234
3 Replies

LEARN ABOUT DEBIAN

grcompiler

grcompiler(1)															     grcompiler(1)

NAME

       grcompiler - Compile GDL into a TrueType Font

SYNOPSIS

       grcompiler [-d] [-D] [-g] [-n number] [-v number] [-w number] [-wall] [-q] gdl-file font-file [output-file] [output-fontname]

Description
       Grcompiler  compiles  a	Graphite Description Language description of the smarts for a font along with a TrueType Font to create a graphite
       font with graphite tables in it.

       -d     Generate XML debugger file.

       -D     Generate all debugger files.

       -g     Permit and ignore invalid glyph definitions.

       -nnumber
	      Set name table start location.

       -q     Quiet mode (no messages except on error).

       -vnumber
	      Set Silf table version number.

       -wnnnn Ignore warning with the given number. This option may be repeated.

       -wall  Display all warnings.

Environment
       grcompiler makes use of the following environment variables

       GDLPP  Specifies the command to execute to run the GDL preprocessor

Files
       gdlerr.txt
	      Warnings and errors are output to this file.

       dbg_classes.txt
	      Debug file that specifies the classes stored in the font in terms of their GDL source and containing glyph ids in hex.

       dbg_cmap.txt
	      Debug file giving Unicode to glyph mapping of all the glyphs in the font and vice versa.

       dbg_enginecode.txt
	      Debug file containing the action code and constraint code associated with each pass and rule in a pass.

       dbg_fsm.txt
	      Debug file that gives the finite state machines of each pass and the rules referenced. For each pass, a  mapping	is  given  between
	      glyph and column number.

       dbg_glyphattrs.txt
	      Debug file containing all the glyph attributes and their names, along with values specified for each glyph.

       dbg_parsetree.txt
	      Debug file giving the complete parse tree of the GDL source file.

       dbg_ruleprec.txt
	      Debug file that lists the rules in precedence order (order in which they will be tested) for each pass.

       $_temp.gdl
	      Debug file containing the output of gdlpp

Author
       Martin Hosken <mhosken@users.sourceforge.net>

							   $Date: 2012-05-29 11:36:50 $ 					     grcompiler(1)
All times are GMT -4. The time now is 02:56 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy