Sponsored Content
Full Discussion: File manipulation via awk
Top Forums UNIX for Dummies Questions & Answers File manipulation via awk Post 302637887 by verse123 on Wednesday 9th of May 2012 01:02:35 PM
Old 05-09-2012
File manipulation via awk

Hello,

I am having issues generating the output file below from this input file:
Quote:
g_name Program X 2833 2966 . + . ID=Jan172736
g_name Program X 2976 3165 . + . ID=Jan172736
g_name Program X 3195 3941 . + . ID=Jan713953
Basically, what I want is if the ID= matches with the line below to print the first value in column 3 and the last value of column 4 for the matching ID's. The ID's can repeat more than twice, however, they will always be in order and not scattered throughout the file.

This is the output I want:

Quote:
g_name Program X 2833 3165 . + . ID=Jan172736
g_name Program X 3195 3941 . + . ID=Jan713953


I have generated the code below so far but it has proven unsuccessful since it sums up the values column 3 and 4 and does not print simply the first match of column 3 and last of match of column 4 for matching ID's

Code:
 awk '$3=="exon" && $9~/^ID/{sub(/_T.*/,"",$9);L[substr($9,4)]print $5-$4+1}END{for(i in L){print i,L[i]}}' filename > out


any ideas?
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk manipulation

Hi , what a wonderful command but so hard to maintain ! i have a file like that : 03/07/2006 05:58:45 03/07/2006 06:58:45 03/07/2006 07:58:50 03/07/2006 08:58:50 and i want to read it and keep only the lines with 3rd field less than 07:00:00 writing it in a second file ! ... (2 Replies)
Discussion started by: Nicol
2 Replies

2. Shell Programming and Scripting

File manipulation using AWK

Hi All, I have a file having content, $ cat data1.txt 20060620 142 62310 959400 A 5.00 20060620 142 62310 959400 B 3.00 20060620 143 62310 959401 A 7.00 20060620 143 62310 959401 B 4.00 20060620 144 62310 959402 A 8.00 20060620 144 62310... (6 Replies)
Discussion started by: rinku11
6 Replies

3. Shell Programming and Scripting

File manipulation with awk

Could you please help me to achieve the below: In a file I need to convert the multiple lines whose filed 1 and field 5 values are same into a single line but with the field 4 values comma separed as mentioned below. Fileds after 5 shall be discarded. Also here by default all other remaining... (6 Replies)
Discussion started by: dhams
6 Replies

4. Shell Programming and Scripting

$0 manipulation in awk

OK, so if $0 represent the entire record... can I change $2 and will that be reflected back in $0? I think the following answers that YES, it does work. But is there anything I should be thinking about prior to doing this? What I am actually doing is part of 5 pages of scripting and awk... (1 Reply)
Discussion started by: joeyg
1 Replies

5. Shell Programming and Scripting

File manipulation with AWK and SED

Hello How do i check that correct input files are used while using AWk and SED for file manipulation? e.g awk '/bin/ {print $0 }' shell.txt sed 's/hp/samsung/' printers.txt how do i ensure that the correct input files I am working with are used? (5 Replies)
Discussion started by: Pauline mugisha
5 Replies

6. Shell Programming and Scripting

SED/AWK file read & manipulation

I have large number of data files, close to 300 files, lets say all files are same kind and have extension .dat , each file have mulitple lines in it. There is a unique line in each file containing string 'SERVER'. Right after this line there is another line which contain a string 'DIGIT=0',... (4 Replies)
Discussion started by: sal_tx
4 Replies

7. Shell Programming and Scripting

File manipulation in awk

I have got a sample file below(colon(:) is the field separator) . The data is like col1:col2:col3:col4:col5:col6:col7:col8:col9:col10 11:12:012:aa:a a a:10::111:12: 311:321:320:caad::321:31:3333:: 2:22:222::bbb::cads::2222:20 :::::12:1234::12: :5:55::555:5555::::55550 Now I want to find... (9 Replies)
Discussion started by: rinku11
9 Replies

8. Shell Programming and Scripting

Awk to convert a text file to CSV file with some string manipulation

Hi , I have a simple text file with contents as below: 12345678900 971,76 4234560890 22345678900 5971,72 5234560990 32345678900 71,12 6234560190 the new csv-file should be like: Column1;Column2;Column3;Column4;Column5 123456;78900;971,76;423456;0890... (9 Replies)
Discussion started by: FreddyDaKing
9 Replies

9. Shell Programming and Scripting

awk manipulation

Hallo Family, I have csv file which has over a million records in it. All i want to do is to change field 2 to have the same value as field 10. sample file:Now 0860093239,Anonymous,unconditional,+27381230283,Anonymous,unconditional,y,public,,2965511477:0A Desired output: ... (2 Replies)
Discussion started by: kekanap
2 Replies

10. Shell Programming and Scripting

awk manipulation

hello I have example file AA 11 BB 22 CC 33 And what I expect to have -a AA=11 -a BB=22 -a CC=33 can anyone help how I have this using awk? (1 Reply)
Discussion started by: vikus
1 Replies
__PPC_SET_PPR_MED(3)					     LinuxProgrammer's Manual					      __PPC_SET_PPR_MED(3)

NAME
__ppc_set_ppr_med, __ppc_set_ppr_very_low, __ppc_set_ppr_low, __ppc_set_ppr_med_low, __ppc_set_ppr_med_high - Set the Program Priority Reg- ister SYNOPSIS
#include <sys/platform/ppc.h> void __ppc_set_ppr_med(void); void __ppc_set_ppr_very_low(void); void __ppc_set_ppr_low(void); void __ppc_set_ppr_med_low(void); void __ppc_set_ppr_med_high(void); DESCRIPTION
These functions provide access to the Program Priority Register (PPR) on the Power architecture. The PPR is a 64-bit register that controls the program's priority. By adjusting the PPR value the programmer may improve system throughput by causing system resources to be used more efficiently, especially in contention situations. The available unprivileged states are cov- ered by the following functions: * __ppc_set_ppr_med() sets the Program Priority Register value to medium (default). * __ppc_set_ppr_very_low() sets the Program Priority Register value to very low. * __ppc_set_ppr_low() sets the Program Priority Register value to low. * __ppc_set_ppr_med_low() sets the Program Priority Register value to medium low. The privileged state medium high may also be set during certain time intervals by problem-state (unprivileged) programs, with the following function: * __ppc_set_ppr_med_high() sets the Program Priority to medium high. If the program priority is medium high when the time interval expires or if an attempt is made to set the priority to medium high when it is not allowed, the priority is set to medium. VERSIONS
The functions __ppc_set_ppr_med(), __ppc_set_ppr_low() and __ppc_set_ppr_med_low() are provided by glibc since version 2.18. The functions __ppc_set_ppr_very_low() and __ppc_set_ppr_med_high() first appeared in glibc in version 2.23. ATTRIBUTES
For an explanation of the terms used in this section, see attributes(7). +---------------------------+---------------+---------+ |Interface | Attribute | Value | +---------------------------+---------------+---------+ |__ppc_set_ppr_med(), | Thread safety | MT-Safe | |__ppc_set_ppr_very_low(), | | | |__ppc_set_ppr_low(), | | | |__ppc_set_ppr_med_low(), | | | |__ppc_set_ppr_med_high() | | | +---------------------------+---------------+---------+ CONFORMING TO
These functions are nonstandard GNU extensions. NOTES
The functions __ppc_set_ppr_very_low() and __ppc_set_ppr_med_high() will be defined by <sys/platform/ppc.h> if _ARCH_PWR8 is defined. Availability of these functions can be tested using #ifdef _ARCH_PWR8. SEE ALSO
__ppc_yield(3) Power ISA, Book II - Section 3.1 (Program Priority Registers) GNU C Library 2017-09-15 __PPC_SET_PPR_MED(3)
All times are GMT -4. The time now is 04:42 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy