record count

dr46014 · #1 (**permalink**) 12-11-2007

i have a file named file_names.dat where there are several files along with their path.
exp:
/data1/dir1/CTA_ACD_20071208.dat
/data1/dir1/CTA_DFG_20071208.dat

i want to write a script which will create a csv file with the name of the file and record count of that file

the output file should look like
/data1/dir1/CTA_ACD_20071208.dat,2500
/data1/dir1/CTA_DFG_20071208.dat,5633

please help me writing the script

vgersh99 · #2 (**permalink**) 12-11-2007

what is a 'record'?
what's the "structure" of the files?

dr46014 · #3 (**permalink**) 12-11-2007

each record is terminated by a newline character \n
wc -l /data1/dir1/CTA_ACD_20071208.dat

vgersh99 · #4 (**permalink**) 12-11-2007

Code:

#!/bin/ksh

(while read file
do
  echo "${file},$(wc -l < ${file}" 
done < 'file_names.dat') > 'file_name.csv'

shamrock · #5 (**permalink**) 12-11-2007

Code:

awk '
{
  "wc -l <"$0 | getline cnt
  print cnt,$0
}' file

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
how to get a file name & record count of csv file	sirik	UNIX for Dummies Questions & Answers	2	03-06-2008 02:55 PM
How count number of fields in a record	sureshg_sampat	Shell Programming and Scripting	5	01-07-2008 06:30 AM
splitting a record and adding a record to a file	rsolap	Shell Programming and Scripting	1	08-13-2007 01:58 PM
Need help with Isql record count	johnu122	Shell Programming and Scripting	4	11-18-2006 12:31 PM
How to count the record count in an EBCDIC file.	oracle8	UNIX for Dummies Questions & Answers	1	07-26-2006 07:22 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by