Awk selective printing


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Awk selective printing
# 1  
Old 02-10-2011
Awk selective printing

Hi,

i need help to print number from different field

Code:
INPUT:

Student1 10 20
Student2 30 40
Student3 50 60
Student4 70 80

Desired Output:
1 20-30
2 40-50
3 60-70

Thank you!
# 2  
Old 02-10-2011
Code:
>:cat Stud
Student1 10 20
Student2 30 40
Student3 50 60
Student4 70 80

>:more Stud | nawk '{print substr($0,8) $2"-"$3}'
1 10-20
2 30-40
3 50-60
4 70-80
>:


Last edited by 47shailesh; 02-10-2011 at 02:56 PM..
This User Gave Thanks to 47shailesh For This Post:
# 3  
Old 02-10-2011
Code:
awk '{print $2,$3"-"$4}' FS="nt| "

This User Gave Thanks to yinyuemi For This Post:
# 4  
Old 02-10-2011
Hi 47Shailesh and Yinyuemi,

Thanks for your help. But still i am not able to get the desired output. It doesn't matter even if the output is not numbered.
Code:
20-30
40-50
60-70

# 5  
Old 02-10-2011
Code:
awk 'NR==1{start=$NF;next} {print ++i,start"-"$2;start=$NF}' infile

This User Gave Thanks to rdcwayx For This Post:
# 6  
Old 02-10-2011
Thanks!
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Continued trouble matching fields in different files and selective field printing ([g]awk)

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

2. Shell Programming and Scripting

awk Selective printing of fields

Hi Gurus, I have following input file. I tried multiple awk combinations to print selected columns without success. HEX ID Name ver FLRGT Start Time Total Shared End Date ----- -------- --- ------ ------------------------ -------------- -------... (4 Replies)
Discussion started by: shunya
4 Replies

3. Shell Programming and Scripting

Selective printing based on matched record

Hi, I have file with thousands of lines somewhat similar to the below 6 lines 06MXXXXXXXXXXXXXXXX 0328 003529 J27300022 MICROSOFT *MSN 06<1 000000001344392 JPN151-85830 MSBILL.INFO F 06<A17087454000328651551 MSBILL.INFO ... (16 Replies)
Discussion started by: dsid
16 Replies

4. Shell Programming and Scripting

Selective printing

I have the following contents in a file ---- CRITICAL: altered for /usr/bin/bin1 ---- OK: /usr/sbin/bin2 result fine ---- OK: /usr/sbin/bin3 result fine ---- CRITICAL: altered for /usr/bin/bin4 ---- OK: /usr/bin/bin5 result fine ---- OK: /usr/bin/bin6 result fine ---- CRITICAL: altered for... (9 Replies)
Discussion started by: anil510
9 Replies

5. Shell Programming and Scripting

selective printing

hi all from below text "abcd,SYS_12345,xyz,PQR, ," I want to print only "abcd,SYS,xyz,PQR, ," i.e. taking only first three 3 chars from 2 string of comma separated file thanks (4 Replies)
Discussion started by: JoeColeEPL9
4 Replies

6. Shell Programming and Scripting

Perl: selective printing of lines

Hi, I have a file with lines like this. 2 7 18 ggcgt anna 2 7 18 hhchc sam 3 7 18 hhdjcc ross 4 7 18 hhcjd jenny 0 8 21 jjdhs sam 3 8 21 kkok bush 2 9 24 kosss BrenhamIf the values of the second column are equal, print only those lines with the least first column value. So in... (5 Replies)
Discussion started by: polsum
5 Replies

7. Shell Programming and Scripting

sed selective printing

Hi, I have an xml file having serveral smiliar lines as below <INPUT VAR1 ="" DATATYPE ="number(p,s)" VAR2 ="" VAR3 ="3" VAR4="0" VAR5 ="ELEMITEM" VAR6 ="NO" VAR7 ="NOT A KEY" VAR8 ="17" LEVEL ="0" NAME ="UNIX" NULLABLE ="NOTNULL" OCCURS ="0" OFFSET ="19" PHYSICALLENGTH ="15"... (3 Replies)
Discussion started by: dips_ag
3 Replies

8. Shell Programming and Scripting

Selective remove awk-bash

Hi I have a folder that contain up to 1000 subfolder. Genereally i need just 2 or 3 of them and i can know apriori the name of the subfolder i want to keep. I'd like to erase all the unnecessary subfolders. I've tried with: ls -l | awk '$8 !~ /name_fold/{print "rm -r " $8}'| sh and it... (4 Replies)
Discussion started by: Dedalus
4 Replies

9. Shell Programming and Scripting

selective printing of lines

Hi all , i need to grep for a string in a text file and print the string and the 3rd line above it. As always , Thanks. (4 Replies)
Discussion started by: okiedokie
4 Replies

10. Shell Programming and Scripting

selective printing awk

Hi there my file looks like this 1 a b c d e f 2 a b b c d e f f g h e t t 3 a c b d e f 4 a b c i want to print the line which has the fields containing ONLY a b c, in this case the line 4. How can i awk it !!!? Many Thanks in advance! (8 Replies)
Discussion started by: saint2006
8 Replies
Login or Register to Ask a Question