Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: File manipulation via awk
Top Forums UNIX for Dummies Questions & Answers File manipulation via awk Post 302637921 by verse123 on Wednesday 9th of May 2012 02:21:49 PM
Old 05-09-2012
Unfortunately that did not work. It went from

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
to

Quote:
g_name Program X 2833 2966 . + . ID=Jan172736
g_name Program X 3195 3941 . + . ID=Jan713953
but it needs to print the first number of the first match of column 3 and the second matches column 4

---------- Post updated at 02:21 PM ---------- Previous update was at 02:11 PM ----------

So the idea is to basically group every line based on the ID= and print the first number in col3 (which should be the smallest ) and the last number of col4 (which should be the largest).
 

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

LEARN ABOUT DEBIAN

psreport

PSREPORT(1)							   User Commands						       PSREPORT(1)

NAME

       psreport: - report on the packets in a Program Stream

SYNOPSIS

       psreport [switches] <infile>

DESCRIPTION

	      TS tools version 1.11, psreport built Nov 11 2008 17:15:47

	      Report on the packets in a Program Stream.

   Files:
       <infile>
	      is an H.222 Program Stream file (but see -stdin)

   Switches:
       -stdin Input from standard input, instead of a file

       -verbose, -v
	      Output packet data as well.

       -max <n>, -m <n>
	      Maximum number of PS packets to read

       -dvd   The PS data is from a DVD. This is the default.  This switch has no effect on MPEG-1 PS data.

       -notdvd, -nodvd
	      The  PS  data  is  not  from  a DVD.  The DVD specification stores AC-3 (Dolby), DTS and other audio in a specialised manner in pri-
	      vate_stream_1.

	      TS tools version 1.11, psreport built Nov 11 2008 17:15:47

	      Report on the packets in a Program Stream.

   Files:
       <infile>
	      is an H.222 Program Stream file (but see -stdin)

   Switches:
       -stdin Input from standard input, instead of a file

       -verbose, -v
	      Output packet data as well.

       -max <n>, -m <n>
	      Maximum number of PS packets to read

       -dvd   The PS data is from a DVD. This is the default.  This switch has no effect on MPEG-1 PS data.

       -notdvd, -nodvd
	      The PS data is not from a DVD.  The DVD specification stores AC-3 (Dolby), DTS and other audio  in  a  specialised  manner  in  pri-
	      vate_stream_1.

SEE ALSO

       The full documentation for psreport is maintained as a Texinfo manual.  Please check http://tstools.berlios.de for more information.

psreport 1.11							   November 2008						       PSREPORT(1)
All times are GMT -4. The time now is 10:41 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy