Append filename to datafile

Satyagiri · #1 (**permalink**) 10-12-2006

I am working on an shell script which checks for all the file starting with abc*.*
and if file found then the filelines need to append the file name in begining

can some one help with the filename appending...

for i in `ls $filename*.csv`
do
echo $i
--- NEED to append file name befor calling the loader
sqlldr
#mv $i $destdir/
done
exit 0

Hitori · #2 (**permalink**) 10-12-2006

Quote:

Originally Posted by Satyagiri

for i in `ls $filename*.csv`
do
echo $i
--- NEED to append file name befor calling the loader
sqlldr
#mv $i $destdir/
done
exit 0

something like

Code:

for i in `ls $filename*.csv`
do
echo $i
--- NEED to append file name befor calling the loader
sqlldr
#NOTE: almost pseudocode
mv $i tmpfile
echo "$i" > $i
cat tmpfile >> $i
rm tmpfile
#mv $i $destdir/
done
exit 0

Satyagiri · #3 (**permalink**) 10-12-2006

Hitori,
it does not replace the file name to all the lines in the file

Hitori · #4 (**permalink**) 10-12-2006

Quote:

Originally Posted by Satyagiri

Hitori,
it does not replace the file name to all the lines in the file

You want to append filename to each line in the file? Pipe the output of your program:

Code:

script | sed "s/^/$i: /" >> $i

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Combine a datafile with Master datafile, emergent!	onthetopo	Shell Programming and Scripting	6	05-12-2007 07:36 AM
Append current date to filename	gigigi	UNIX for Dummies Questions & Answers	3	07-20-2006 06:10 PM
Append date to filename	hshapiro	UNIX for Dummies Questions & Answers	5	04-03-2006 10:52 AM
oracle datafile *dbf	tt155	SUN Solaris	3	12-17-2005 07:38 PM
replace one section in a datafile	Paprika	Shell Programming and Scripting	4	06-17-2005 09:48 AM

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