Question on awk source files


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Question on awk source files
# 8  
Old 08-16-2016
Some more awk
Code:
[akshay@localhost tmp]$ for i in test.csv debug.txt cruise_reports.csv; do wc -l $i; done 
1083 test.csv
24 debug.txt
1083 cruise_reports.csv

Code:
[akshay@localhost tmp]$ awk '{l[FILENAME]++}END{for(i in l)print l[i],i}' OFS='|' test.csv debug.txt cruise_reports.csv 
1083|cruise_reports.csv
1083|test.csv
24|debug.txt

# 9  
Old 08-16-2016
Another solution:

Code:
printf "%s|%s\n" $(wc -l file.txt  asdf.txt  lkjh.txt  bvcx.txt|sed '$d') >> temp.txt


Last edited by pilnet101; 08-16-2016 at 10:20 AM..
This User Gave Thanks to pilnet101 For This Post:
# 10  
Old 08-16-2016
Quote:
Originally Posted by pilnet101
Another solution:

Code:
printf "%s|%s\n" $(wc -l file.txt  asdf.txt  lkjh.txt  bvcx.txt) >> temp.txt

I think it shows total as well Smilie
This User Gave Thanks to Akshay Hegde For This Post:
# 11  
Old 08-16-2016
Thanks Akshay - Amended now!
# 12  
Old 08-17-2016
hi Akshay, Thanks for the reply.
issue with your command: its not listing the files which have zero records....
Code:
awk '{l[FILENAME]++}END{for(i in l)print l[i],i}' OFS='|' test.csv debug.txt cruise_reports.csv

# 13  
Old 08-17-2016
Quote:
Originally Posted by JSKOBS
hi Akshay, Thanks for the reply.
issue with your command: its not listing the files which have zero records....
Code:
awk '{l[FILENAME]++}END{for(i in l)print l[i],i}' OFS='|' test.csv debug.txt cruise_reports.csv

Oh thanks, I didn't test, meanwhile you may try what pinet101 suggested or this

Code:
[akshay@localhost tmp]$ grep -c  ^ test.csv mm.csv debug.txt cruise_reports.csv
test.csv:1083
mm.csv:0
debug.txt:24
cruise_reports.csv:1083

Code:
[akshay@localhost tmp]$ grep -c  ^ test.csv mm.csv debug.txt cruise_reports.csv | awk 'BEGIN{FS=":";OFS="|"}{print $2,$1}'
1083|test.csv
0|mm.csv
24|debug.txt
1083|cruise_reports.csv

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Error files count while coping files from source to destination locaton as well count success full

hi All, Any one answer my requirement. I have source location src_dir="/home/oracle/arun/IRMS-CM" My Target location dest_dir="/home/oracle/arun/LiveLink/IRMS-CM/$dc/$pc/$ct" my source text files check with below example.text file content $fn "\t" $dc "\t" $pc "\t" ... (3 Replies)
Discussion started by: sravanreddy
3 Replies

2. UNIX for Dummies Questions & Answers

Concatenate files and delete source files. Also have to add a comment.

- Concatenate files and delete source files. Also have to add a comment. - I need to concatenate 3 files which have the same characters in the beginning and have to remove those files and add a comment and the end. Example: cat REJ_FILE_ABC.txt REJ_FILE_XYZ.txt REJ_FILE_PQR.txt >... (0 Replies)
Discussion started by: eskay
0 Replies

3. Shell Programming and Scripting

Awk command with two source files

Hello, I have two source files: sourcefile1.dat: 12345 xxx yyy zzz 23456 qqq ttt rrr 34567 ppp jjj ggg 45678 fff ddd sss 56789 nnn mmm ccc sourcefile2.dat: 12345.gif 34567.gif I want to obtain a simple awk one linger to obtain the following: xxx yyy zzz 12345.gif qqq ttt rrr... (15 Replies)
Discussion started by: palex
15 Replies

4. Shell Programming and Scripting

need a shell script to extract the files from source file and check whether those files existonserve

Hi, I am new to shell scripting.Please help me on this.I am using solaris 10 OS and shell i am using is # echo $0 -sh My requirement is i have source file say makefile.I need to extract files with extensions (.c |.cxx |.h |.hxx |.sc) from the makefile.after doing so i need to check whether... (13 Replies)
Discussion started by: muraliinfy04
13 Replies

5. Solaris

Question about SunOS version, how to include in C source

Sorry if here is the wrong place to put this question, but for college we develop small programs in C using Solaris. Most of time is OK for us not to document nothing, until now. Every time program is executed must print OS name. Does Solaris has some predefined macros which I can include... (3 Replies)
Discussion started by: solaris_user
3 Replies

6. UNIX for Dummies Questions & Answers

Source all files in a directory

Hi everyone, Is there an efficient way to source all of the files contained in a directory? Theoretically I could create a FOR loop and successively source each file, but I just wanted to check if there was a cleaner method. Thanks! Mike (3 Replies)
Discussion started by: msb65
3 Replies

7. Shell Programming and Scripting

Awk help with source and previous line loop

Hello, I've written a ksh awk script to ping multiple servers and write the results to a file. That part is working ok. I then want to extract the names of only the server which are available. This is indicated by '1 packets received'. The server name actually appears above that line so I found... (4 Replies)
Discussion started by: Grueben
4 Replies

8. Programming

Vi question for writing source code

Hi guys, I'm modifying an old f77 code using vi. I'm modifying the code remotely from my windows machine using xming using vi. I'm using tabs to move past the first 6 columns of the code and to keep my loops and if statements neat, but when I hit the tab key, vi displays a big red block which is... (7 Replies)
Discussion started by: rks171
7 Replies

9. Shell Programming and Scripting

noob question - is awk the tool to clean dirty text files?

Hi, nevermind. I think I've found the answer. It appears I was looking for index, match, sub, and gsub. I want to write a shell script that will clean the html out of a bunch of files and format the data for import into excel. Awk seems like a powerful tool, but it seems oriented to... (1 Reply)
Discussion started by: yogert909
1 Replies

10. OS X (Apple)

open-source driver question

Hi, I'm a linux guy and have used netbsd, openbsd, freebsd etc in the past but never tangled with the kernel or drivers outside of Linux. My mother has fried her ethernet port on her iMac (G4 I think); I recently sent her a silicom USB U2E (usb 2 ethernet) dongle which is evidently not... (2 Replies)
Discussion started by: sjalex
2 Replies
Login or Register to Ask a Question