How to find line number?


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting How to find line number?
# 1  
Old 08-22-2013
How to find line number?

I have a data file (which has five columns) from which im finding column count of all the records and writing into separate file say "colcnt.txt". And I find one (or more) records have less column counts (i.e split records). I need to know which record(s) have that split scenario. Is there any way to find out line number from data file which has split records ?

Code:
Datafile.txt
1,abc,mon,589,hi
2,qwe,tue,456,bye
3,mnb,wed,145,pppp
4,asd,thurs
5,lkj,fri,675,hhhh
 
colcnt.txt
5
5
5
3
5
 
Output-
Line number : 4 has less number of columns which is a split record.

Thanks in Advance..!
# 2  
Old 08-22-2013
Assuming if number of fields is less than 4 then it is a split record:
Code:
awk -F"," '{if(NF<4) {print "Line number :  "NR" has less number of columns which is a split record." }}' filename

If you need to count number of fields on each line, use
Code:
awk -F"," '{print NF}' filename

This User Gave Thanks to krishmaths For This Post:
# 3  
Old 08-22-2013
Thanks..thats working..!

But when I tried passing runtime value for column count its not working

Code:
awk -F"," '{if(NF<$ColumnCnt) {print "Line number :  "NR" has less number of columns which is a split record." }}' filename

# 4  
Old 08-22-2013
You need to use awk variables.

Code:
awk -F"," -v v1=$ColumnCnt '{if(NF<v1) {print "Line number :  "NR" has less number of columns which is a split record." }}' filename

This User Gave Thanks to krishmaths For This Post:
# 5  
Old 08-22-2013
Thanks krishmaths and that was working as expected...!
Learned how to declare variable in "awk".
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

How to find encapsulating function name from line number?

I am looking at a log file which just tells me the filename and the line number inside that file that has the Error. What I am interested is knowing the encapsulating function. For example, here are the contents of the log file Error: foo.file on line wxy Error: foo.file... (3 Replies)
Discussion started by: kaaliakahn
3 Replies

2. Shell Programming and Scripting

awk to find number in a field then print the line and the number

Hi I want to use awk to match where field 3 contains a number within string - then print the line and just the number as a new field. The source file is pipe delimited and looks something like 1|net|ABC Letr1|1530||| 1|net|EXP_1040 ABC|1121||| 1|net|EXP_TG1224|1122||| 1|net|R_North|1123|||... (5 Replies)
Discussion started by: Mudshark
5 Replies

3. Shell Programming and Scripting

Find line number

How to find a line number? I have a file: 1 5 8 9 10 15 Is there a simple method to find out on which line for example the 9 is written? (3 Replies)
Discussion started by: jds93
3 Replies

4. Shell Programming and Scripting

How do i find the first number in each line and insert dummy string into the missing columns?

Hi, I have one input file with the following content: MY_inpfile.txt Aname1 Cname1 Cname2 1808 5 Aname2 Cname1 1802 47 Bname1 ? 1819 22 Bname2 Cname1 1784 11 Bname3 1817 9 Zname1 Cname1 1805 59 Zname2 Cname1 Cname2 Cname3 1797 27 Every line in my input file have a 4 digit... (5 Replies)
Discussion started by: Szaffy
5 Replies

5. Shell Programming and Scripting

Find line number of bad data in large file

Hi Forum. I was trying to search the following scenario on the forum but was not able to. Let's say that I have a very large file that has some bad data in it (for ex: 0.0015 in the 12th column) and I would like to find the line number and remove that particular line. What's the easiest... (3 Replies)
Discussion started by: pchang
3 Replies

6. Shell Programming and Scripting

Take each number in table row and find the difference from the corresponding line

I have a two files containing numbers like below. First one contains one number on each line, the other is a table of numbers, each separated by a space. There are the same number of lines in each file. I want to take each number in the row of the table and find the difference from the... (12 Replies)
Discussion started by: kristinu
12 Replies

7. Shell Programming and Scripting

find out line number of matching string using grep

Hi all, I want to display line number for matching string in a file. can anyone please help me. I used grep -n "ABC" file so it displays 6 ABC. But i only want to have line number,i don't want that it should prefix matching context with line number. Actually my original... (10 Replies)
Discussion started by: sarbjit
10 Replies

8. Shell Programming and Scripting

to find the number from a line.

Hi, I need to write a script which will have a text string as a input and the output should find out the number in the text string and add one to it. Eg: Input => asfdosainovih1234lnsiohn Output => 1235 All the numbers in the text will be together and only one time in the line. ... (2 Replies)
Discussion started by: vikings.svnit
2 Replies

9. Shell Programming and Scripting

how to find the line number of a pattern of first appearance??

Hi, I am doin a project in shell script please answer the above question..... waiting........ (2 Replies)
Discussion started by: shivarajM
2 Replies

10. UNIX for Dummies Questions & Answers

Script to find the number of tab delimiters in a line

Hi, I need to find the number of tab delimiters in the first line of a file.So using word=`head -1 files.txt` I have extracted the first line of file into a variable word.It has 20 tab delimted columns.So can anyone help me in finding the number of delimiters? I am using csh and I am a... (5 Replies)
Discussion started by: poornimajayan
5 Replies
Login or Register to Ask a Question