|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
AWK : Add Fields of lines with matching field
Post 302488284 by m.d.ludwig on Sunday 16th of January 2011 01:09:46 PM
01-16-2011
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi.
I have a tab separated file that has a couple nearly identical lines. When doing:
sort file | uniq > file.new
It passes through the nearly identical lines because, well, they still are unique.
a)
I want to look only at field x for uniqueness and if the content in field x is the... (1 Reply)
Discussion started by: rocket_dog
1 Replies
2. Shell Programming and Scripting
Dear List,
I have a file of csv data which has a different line per compliance check per host. I do not want any omissions from this csv data file which looks like this:
date,hostname,status,color,check
02-03-2012,COMP1,FAIL,Yellow,auth_pass_change... (3 Replies)
Discussion started by: landossa
3 Replies
3. Shell Programming and Scripting
Hi experts,
I need to print the first field first then last two fields should come next and then i need to print rest of the fields.
Input :
a1,abc,jsd,fhf,fkk,b1,b2
a2,acb,dfg,ghj,b3,c4
a3,djf,wdjg,fkg,dff,ggk,d4,d5
Expected output:
a1,b1,b2,abc,jsd,fhf,fkk... (6 Replies)
Discussion started by: 100bees
6 Replies
4. Shell Programming and Scripting
In the tab-delimited input below I am trying to use awk to -10 from $2 and +10 to $3. Something like
awk -F'\t' -v OFS='\t' -v s=10 '{split($4,a,":"); print $1,$2-s,$3+s,a,$5,$6} | awk {split(a,b,"-"); print $1,$2-s,$3+s,b-s,b+s,$5,$6}' input
should do that. I also need to -10 from $4... (2 Replies)
Discussion started by: cmccabe
2 Replies
5. Shell Programming and Scripting
awk to combine all matching fields in input but only print line with largest value in specific field
In the below I am trying to use awk to match all the $13 values in input, which is tab-delimited,
that are in $1 of gene which is just a single column of text.
However only the line with the greatest $9 value in input needs to be printed.
So in the example below all the MECP2 and LTBP1... (0 Replies)
Discussion started by: cmccabe
0 Replies
6. Shell Programming and Scripting
I am trying to remove all the lines and spaces where the count in $4 or $5 is greater than 1 (more than 1 letter). The file and the output are tab-delimited. Thank you :).
file
X 5811530 . G C NLGN4X
17 10544696 . GA G MYH3
9 96439004 . C ... (1 Reply)
Discussion started by: cmccabe
1 Replies
7. Shell Programming and Scripting
In the awk below I am trying to print the entire line, along with the header row, if $2 is SNV or MNV or INDEL. If that condition is met or is true, and $3 is less than or equal to 0.05, then in $7 the sub pattern :GMAF= is found and the value after the = sign is checked. If that value is less than... (0 Replies)
Discussion started by: cmccabe
0 Replies
8. UNIX for Beginners Questions & Answers
I apologize in advance, but I continue to have trouble searching for matches between two files and then printing portions of each to output in awk and would very much appreciate some help.
I have data as follows:
File1
PS012,002 PRQ 0 1 1 17 1 0 -1 3 2 1 2 -1 ... (7 Replies)
Discussion started by: jvoot
7 Replies
9. Shell Programming and Scripting
In the awk I am trying to add :p.=? to the end of each $9 that matches the pattern NM_. The below executes andis close but I can not seem to figure out why the :p.=? repeats in the split as in the green in the current output. I have added comments as well. Thank you :).
file
... (4 Replies)
Discussion started by: cmccabe
4 Replies
10. Shell Programming and Scripting
The awk below produces the current output, which will add +1 to $3. However, I am trying to add the length of the matching characters between $5 and $6 to $3. I have tried using sub as a variable to store the length but am not able to do so correctly. I added comments to each line and the... (4 Replies)
Discussion started by: cmccabe
4 Replies
LEARN ABOUT PHP
udm_get_res_field
UDM_GET_RES_FIELD(3) 1 UDM_GET_RES_FIELD(3) udm_get_res_field - Fetch a result field SYNOPSIS
string udm_get_res_field (resource $res, int $row, int $field) DESCRIPTION
Fetch a mnoGoSearch result field. PARAMETERS
o $res -$res - a link to result identifier, received after call to udm_find(3). o $row -$row - the number of the link on the current page. May have values from 0 to $UDM_PARAM_NUM_ROWS-1. o $field -$field - field identifier, may have the following values: o UDM_FIELD_URL - document URL field o UDM_FIELD_CONTENT - document Content-type field (for example, text/html). o UDM_FIELD_CATEGORY - document category field. Use udm_cat_path(3) to get full path to current category from the categories tree root. (This parameter is available only in PHP 4.0.6 or later). o UDM_FIELD_TITLE - document title field. o UDM_FIELD_KEYWORDS - document keywords field (from META KEYWORDS tag). o UDM_FIELD_DESC - document description field (from META DESCRIPTION tag). o UDM_FIELD_TEXT - document body text (the first couple of lines to give an idea of what the document is about). o UDM_FIELD_SIZE - document size. o UDM_FIELD_URLID - unique URL ID of the link. o UDM_FIELD_RATING - page rating (as calculated by mnoGoSearch). o UDM_FIELD_MODIFIED - last-modified field in unixtime format. o UDM_FIELD_ORDER - the number of the current document in set of found documents. o UDM_FIELD_CRC - document CRC. RETURN VALUES
udm_get_res_field(3) returns result field value on success, FALSE on error. PHP Documentation Group UDM_GET_RES_FIELD(3)