Display LineNo Incase Total Number Of Delimiter Does matches in a given variable


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Display LineNo Incase Total Number Of Delimiter Does matches in a given variable
# 1  
Old 10-23-2009
Display LineNo Incase Total Number Of Delimiter Does Not Not matches in a given variable

I have many files .dat extension.

requirement is to display line no
if no of delimiter does not matches in a given variable

lets say

File: REF_BETOS.dat

HCPCS_OR_CPT_CODE~BETOS_CODE~TERMINATION_DATE
0001F~Z2~
0003T~I4~B20061231
0005F~Z2~~~
0008T~P8~B20061231
0008T~P8~B20061231~feess
00100~P0~

Delimiter=2

Output should display the filename and lineno

your help is appreciated

I am trying with statment
awk -F"$Delimiter" '{print NR NF-1}';

OutPut should look like

File Name Line No
REF_BETOS.dat 4
REF_BETOS.dat 6

Last edited by ainuddin; 10-23-2009 at 11:29 AM.. Reason: Thread tital should be "Delimiter Does Not matches"
# 2  
Old 10-23-2009
Code:
awk -F'~' -v nd="$Delimiter" 'NF!=nd+1{print FILENAME, FNR}' *.dat

Hope it's not a homework assignment.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Display text is string matches below.

I have not idea how I would accomplish this. I have a script that scans for CDP neighbours. I get the results in a file. I am interested in CDP Neighbor Details if name BSWITCH shows up. If BSWITCH is not present then skip. CDP Neighbor Details for 10.200.21.1... (1 Reply)
Discussion started by: mrlayance
1 Replies

2. Shell Programming and Scripting

Display all the matches lines in one line using awk

Please can you let me know how to print all the matching lines from a file in one single line using awk. Thanks I have the following data in the input file data1 voice2 voice1 speech1 data2 data3 ... ... voice4 speech2 data4 and the output should be as follows data1 data2... (4 Replies)
Discussion started by: Sudhakar333
4 Replies

3. Shell Programming and Scripting

Shell script to put delimiter for a no delimiter variable length text file

Hi, I have a No Delimiter variable length text file with following schema - Column Name Data length Firstname 5 Lastname 5 age 3 phoneno1 10 phoneno2 10 phoneno3 10 sample data - ... (16 Replies)
Discussion started by: Gaurav Martha
16 Replies

4. Shell Programming and Scripting

Awk script to sort and display total occurancies

Hi I am not a good awk programer but the below code serving my purpose Input process 12936 user-name 15u IPv4 7438309 0t0 TCP prdabc.cesi.com:42016->efh.ijk.com:50002 (ESTABLISHED) process 12942 user-name 13u IPv4 7764990 0t0 TCP abc.abc.com:9402->192.168.1.1:63919... (2 Replies)
Discussion started by: rakeshkumar
2 Replies

5. Shell Programming and Scripting

Number of matches in 2 strings

Hello all, I have a file with column header which looks like this. C1 C2 C3 A A G T T A G C CI want to make columnwise (and bitwise) comparison of strings and calculate the number of matches. So the number of matches between C1 and C2 will be comparing ATG and ATC. Here there are... (5 Replies)
Discussion started by: newbie83
5 Replies

6. UNIX for Dummies Questions & Answers

Display total hard disk size?

Hi, Using Redhat, how do I display total hard disk size? I know how to do that in Solaris, you can type, format. It will show how big the disks are. This is what I did so for. $ df -t ext3 -h Filesystem Size Used Avail Use% Mounted on /dev/mapper/VolGroup00-LogVol00 ... (1 Reply)
Discussion started by: samnyc
1 Replies

7. Shell Programming and Scripting

Help with sum total number of record and total number of record problem asking

Input file SFSQW 5192.56 HNRNPK 611.486 QEQW 1202.15 ASDR 568.627 QWET 6382.11 SFSQW 4386.3 HNRNPK 100 SFSQW 500 Desired output file SFSQW 10078.86 3 QWET 6382.11 1 QEQW 1202.15 1 HNRNPK 711.49 2 ASDR 568.63 1 The way I tried: (2 Replies)
Discussion started by: patrick87
2 Replies

8. Emergency UNIX and Linux Support

Grab total page read from webalizer display in html

Hi, I need a way to grab the total combines since inception, total pages read from webalizer on my centos server or any other location (as long as since inception) and display the result live on my website So with each visit it would be increasing, or perhaps live (ajax) not sure But can... (0 Replies)
Discussion started by: lawstudent
0 Replies

9. Shell Programming and Scripting

Get line number when matches a string

If I have a file something like as shown below, ARM*187878*hjhj BAG*88778*jjjj COD*7777*kkkk BAG*87878*kjjhjk DEF*65656*89989*khjkk I need the line numbers to be added with a colon when it matches the string "BAG". Here in my case, I need something like ARM*187878*hjhj... (4 Replies)
Discussion started by: Muthuraj K
4 Replies

10. Shell Programming and Scripting

ls I do not want to display total with ls

I'm trying to write the filenames only to a file. The following line works: ls -l /home/alex >> log/filetrack.log But the file filetrack.log also contains the "total" i.e. the first line is total 3462984 Also, I would like only the filename, date and size to be listed. However, my main... (3 Replies)
Discussion started by: rx82000
3 Replies
Login or Register to Ask a Question