prepending number of records on top of each file

[navink123]

I am extracting data from a table and putting it into a number of text files. While doing this, I need to find out how may records are extracted into each file and display it on the top of the same file as a header record.

Anybody has idea how to do this,
Thanks,
Navin

 

[fredericofonseca]

And how are you extracting the data from the table? and where is the table stored?




Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[Salem]

Assuming you can't do this whilst generating the file, then you could do this after the file is completed

#!/bin/sh
#

# count the lines in the file (passed as $1)
# then prepend that information to the file
prepend ( ) {
  lines=`wc -l < $1`
  ( echo &quot;Lines in file = $lines&quot; ; cat $1 ) > tmp$$
  mv tmp$$ $1
}

# example call
prepend results.txt

--

http://www.catb.org/~esr/faqs/smart-questions.html

 

[navink123]

Thanks Salem,
This is exactly what I wanted. But the script prepends the # to only one file in the directory. How can I display the # in all files in the directory.

Thanks,
Navin

 

[dickiebird]

Use a loop to prepend to all files in the directory eg

#!/bin/sh
cd yourdir
for file in *
do
lines=`wc -l $file`
( echo "Lines in file = $lines" ; cat $file ) > tmp$$
mv tmp$$ $file
done



Dickie Bird (-)))