Question on awk source files Post: 302979541

Sponsored Content

Top Forums Shell Programming and Scripting Question on awk source files Post 302979541 by RavinderSingh13 on Tuesday 16th of August 2016 04:53:38 AM

08-16-2016

Moderator

Quote:

Originally Posted by JSKOBS

Hi Ravinder, i think i confused...
we need the file record count like below, not each line count

PHP Code:


2342343|file.txt
762834623|asdf.txt  
23|lkjh.txt  
9098|bvcx.txt

Hello JSKOBS,

If you want simple and sober line counts the you could use wc command as follows.

Code:

wc -l Input_file1  Input_file2  Input_file3  Input_file4  | grep -v "total"

Output will be as follows.

Code:

  12 Input_file1
   4 Input_file2
   4 Input_file3
   5 Input_file4

If you want your output to be delimited with | and no space in starting as shown in above output then you could do following.

Code:

wc -l Input_file1  Input_file2  Input_file3  Input_file4  | awk '($0 ~ /total/){next}{sub(/^[[:space:]]+/,X,$0);sub(/[[:space:]]/,"|",$0);} 1'

Output will be as follows.

Code:

12|Input_file1
4|Input_file2
4|Input_file3
5|Input_file4

Thanks,
R. Singh

This User Gave Thanks to RavinderSingh13 For This Post:

RavinderSingh13

View Public Profile for RavinderSingh13

Find all posts by RavinderSingh13

10 More Discussions You Might Find Interesting

1. 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. 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...

3. 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...

4. 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...

5. 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

6. 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...

7. 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...

8. 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...

9. 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 >...

10. 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" ...

10 More Discussions You Might Find Interesting

1. OS X (Apple)

open-source driver question

Discussion started by: sjalex

2. Shell Programming and Scripting

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

Discussion started by: yogert909

3. Programming

Vi question for writing source code

Discussion started by: rks171

4. Shell Programming and Scripting

Awk help with source and previous line loop

Discussion started by: Grueben

5. UNIX for Dummies Questions & Answers

Source all files in a directory

Discussion started by: msb65

6. Solaris

Question about SunOS version, how to include in C source

Discussion started by: solaris_user

7. Shell Programming and Scripting

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

Discussion started by: muraliinfy04

8. Shell Programming and Scripting

Awk command with two source files

Discussion started by: palex

9. UNIX for Dummies Questions & Answers

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

Discussion started by: eskay

10. Shell Programming and Scripting

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

Discussion started by: sravanreddy