Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

awk - set numbers [ 1 ... n] from the 6 line

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting awk - set numbers [ 1 ... n] from the 6 line
# 1  
Old 01-14-2016
awk - set numbers [ 1 ... n] from the 6 line
Hi,

i have a file, where measurement-data is stored in the first column. The file has also a header of 5 lines. I want to set counting up numbers [1, 2, 3, ...] in front of any particular measurement-value; should start at the 6. line with starting number 1.
i try to solve it with ...
Code:
awk 'NR > 6 { print FNR "\t" $0 }' file.dat

..but it will cut the header. Can someone give me a hint, how to give out the complete file?

Thanks in advance,
IMPe
# 2  
Old 01-14-2016
Hello IMPe,

Request you to please always do show sample input and expected sample output too. If I understood correctly your requirement, could you please try following and let me know if that helps.
Code:
###If you want to leave empty line.
awk 'NR > 6 && NF{ print ++i "\t" $0 }'  Input_file
 
###If you want to count each line then following may help.
awk 'NR > 6 { print ++i "\t" $0 }'  Input_file

Thanks,
R. Singh
This User Gave Thanks to RavinderSingh13 For This Post:
IMPe
# 3  
Old 01-14-2016
Some sample always helps! Try (untested)
Code:
awk 'NR>5 {sub(/^/, NR-5)} 1' file

This User Gave Thanks to RudiC For This Post:
IMPe
# 4  
Old 01-14-2016
Quote:
Originally Posted by RavinderSingh13
Hello IMPe,

Request you to please always do show sample input and expected sample output too. If I understood correctly your requirement, could you please try following and let me know if that helps.
Code:
###If you want to leave empty line.
awk 'NR > 6 && NF{ print ++i "\t" $0 }'  Input_file
 
###If you want to count each line then following may help.
awk 'NR > 6 { print ++i "\t" $0 }'  Input_file

Thanks,
R. Singh
Hi RavinderSingh,

thank you for the fast reply. Unfortunately your one-liner (both) work the same way and cut the top of the header like my awk-example, too. The given awk-one-liner, from the following threadpost, of RudiC work propper.

Thank you!
IMPe

---------- Post updated at 06:53 AM ---------- Previous update was at 06:51 AM ----------

Quote:
Originally Posted by RudiC
Some sample always helps! Try (untested)
Code:
awk 'NR>5 {sub(/^/, NR-5)} 1' file

Hi RudiC,

thanks a lot; Your one-liner is working propper and do exactly what i want.

Thank you!
IMPe
# 5  
Old 01-14-2016
Quote:
Originally Posted by IMPe
Hi RavinderSingh,

thank you for the fast reply. Unfortunately your one-liner (both) work the same way and cut the top of the header like my awk-example, too. The given awk-one-liner, from the following threadpost, of RudiC work propper.

Thank you!
IMPe

---------- Post updated at 06:53 AM ---------- Previous update was at 06:51 AM ----------



Hi RudiC,

thanks a lot; Your one-liner is working propper and do exactly what i want.

Thank you!
IMPe
Hello IMPe,

Please try following it should print the headers too, not tested though.
Code:
###If you want to leave empty line.
awk 'NR==1{print;next} NR > 6 && NF{ print ++i "\t" $0 }'  Input_file
 
###If you want to count each line then following may help.
awk 'NR==1{print;next} NR > 6 { print ++i "\t" $0 }'  Input_file

Thanks,
R. Singh
# 6  
Old 01-14-2016
The following prints in cat -n style
Code:
awk 'NR>h {printf "%6s ",NR-h} {print}' h=5 file.dat

# 7  
Old 01-14-2016
Quote:
Originally Posted by MadeInGermany
The following prints in cat -n style
And why don't use cat -n (or less -N, or nl) Smilie

Code:
head -n5 file; (tail -n+6 file | cat -n)

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Efficient awk way to add numbers in line fields

data.now: blah1,dah,blaha,sweet,games.log,5297484456,nagios-toin,529748456,on__host=93 SERVICE__ALERT_=51 Warning___The__results__of__service=16 Warning___on__host=92 Auto_save__of__retention__data__completed=1 Warning___Return=68 PASSIVE__SERVICE__CHECK_=53 ,1026--1313,1... (12 Replies)
Discussion started by: SkySmart
12 Replies

2. Shell Programming and Scripting

awk : Filter a set of data to parse header line and last field of multiple same match.

Hi Experts, I have a data with multiple entry , I want to filter PKG= & the last column "00060110" or "00088150" in the output file: ############################################################################################### PKG= P8SDB :: VGS = vgP8SOra vgP8SDB1 vgP8S001... (5 Replies)
Discussion started by: rveri
5 Replies

3. Shell Programming and Scripting

awk script to filter the numbers which are around the set value

Hi All, I have one sensor output(over the same) for a set value of 20. Time(in Sec), Data 1, 16 2, 20 3, 24 4, 22 5, 21 6, 20 7, 19.5 8, 20 9, 20.5 10, 20 11, 20 12, 19.5 Here we can see like after 5 sec of time the data value reaches to 20+-0.5 range. So I... (7 Replies)
Discussion started by: ks_reddy
7 Replies

4. Shell Programming and Scripting

awk command to compare a file with set of files in a directory using 'awk'

Hi, I have a situation to compare one file, say file1.txt with a set of files in directory.The directory contains more than 100 files. To be more precise, the requirement is to compare the first field of file1.txt with the first field in all the files in the directory.The files in the... (10 Replies)
Discussion started by: anandek
10 Replies

5. Shell Programming and Scripting

Compute the median of a set of numbers with AWK?

Is there a way in awk to compute the median of a set of numbers in a file in the following format. 34 67 78 100 23 45 67 (3 Replies)
Discussion started by: Lucky Ali
3 Replies

6. Shell Programming and Scripting

Assign Line Numbers to each line of the file

Hi! I'm trying to assign line numbers to each line of the file for example consider the following.. The contents of the input file are hello how are you? I'm fine. How about you? I'm trying to get the following output.. 1 hello how are you? 2 I'm fine. 3 How about you? ... (8 Replies)
Discussion started by: abk07
8 Replies

7. Shell Programming and Scripting

How to take set of numbers?

I have to take a list of numbers from the keyboard and not by passing arguments. How will I read a set of numbers in such a way that I can use any number I wish to operate upon. Is there any specific command to do so. As said before I dont want to pass the numbers as arguments from command line.... (3 Replies)
Discussion started by: VishBoy
3 Replies

8. UNIX for Dummies Questions & Answers

seperating records with numbers from a set of numbers

I have two files one (numbers file)contains the numbers(approximately 30000) and the other file(record file) contains the records(approximately 40000)which may or may not contain the numbers from that file. I want to seperate the records which has the field 1=(any of the number from numbers... (15 Replies)
Discussion started by: Shiv@jad
15 Replies

9. UNIX for Advanced & Expert Users

Add line numbers to end of each line

Hi i would like to add line numbers to end of each line in a file. I am able to do it in the front of each line using sed, but not able to add at the end of the file. Can anyone suggest The following code adds line number to start of each line sed = filename | sed 'N;s/\n/\t/' how can i... (5 Replies)
Discussion started by: rudoraj
5 Replies

10. Programming

How to set constrain on random numbers in c

Hi, I am currently trying to generate multiple random numbers in C for different variable:- die1=1+(rand()%5); die2=1+(rand()%5); die3=1+(rand()%5); die4=1+(rand()%5); But I need to contrain the total of die1, die2,die3 and die4 to be 5 as well. If i insert die1+die2+die3+die4=5, i do... (6 Replies)
Discussion started by: ahjiefreak
6 Replies
Login or Register to Ask a Question