reading files from a directory.


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting reading files from a directory.
# 1  
Old 12-06-2010
reading files from a directory.

Can some body help me to code this?

go to a specific directory.(/home/abcd/test)

file1.txt,
file2.txt,
...
..
filen.txt

read the files in side the folder 'test' and print the content of each file into other folder in the same directory lets say(testresult) with the same file name and .sql extension.



file1.sql(extension is .sql).
file2.sql
file3.sql
...
...
filen.sql

Example:
# 2  
Old 12-06-2010
Code:
ls -1 *.txt | while read file; do cp $file testresult/${file%.*}.sql; done


Last edited by cabrao; 12-06-2010 at 03:43 PM..
# 3  
Old 12-06-2010
Code:
find /home/abcd/test -type f | while read a
do
cat $a > "${a%/*}"/testresult"${a##*/}".sql
done

---------- Post updated at 04:29 PM ---------- Previous update was at 04:25 PM ----------
Code:
cd /home/abcd/test
ls *.txt | xargs -i cp {} ./testresult/{}.sql

Ooops i forgot to remove the .txt extension, go for cabrao solution then ! Smilie

Last edited by ctsgnb; 12-06-2010 at 11:34 AM..
# 4  
Old 12-06-2010
ls -l *.txt | while read file; do awk '{if(NR==1)
{
t=$1;
$1=""
s="ALTER TABLE ADD COLUMN " t" "$0
next;
}
s=s" ,"$0
}
END {
print s" ) " }' $file*.* ; done
awk: cmd. line:12: fatal: cannot open file `-rwxrwxrwx' for reading (No such file or directory)
awk: cmd. line:12: fatal: cannot open file `-rwxrwxrwx' for reading (No such file or directory)

i want to execute the awk command functionality during each file reading but it seems it does work for me ..any idea about the error?
Regards
# 5  
Old 12-06-2010
Code:
for i in *.txt
do
  cp -p "$i" "testresult/${i%.*}.sql"
done

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

' for reading (No such file or directory)

1.1 Solaris 10 8/07 s10s_u4wos_12b SPARC 1.2 Patch: 127714-03 Obsoletes: Requires: 120011-14 Incompatibles: Packages: SUNWsshcu, SUNWsshdu, SUNWsshu Patch: 128253-01 Obsoletes: Requires: Incompatibles: Packages: SUNWsshcu Patch: 126630-01 Obsoletes: Requires: Incompatibles: Packages: SUNWtcsh 1.3... (3 Replies)
Discussion started by: alvinoo
3 Replies

2. Shell Programming and Scripting

Reading contents of files from a directory

I have a directory with the files, 1st: I want to Diplay each filename, underline it 2nd: Display the contents under the filename and 3rd: Redirect the above content to other file 4th: Remove the files from the directory #!/bin/ksh for i in $( cat $a/b/c.txt ) do echo "... (1 Reply)
Discussion started by: Aditya_001
1 Replies

3. UNIX for Dummies Questions & Answers

Reading the dates from a file & moving the files from a directory

Hi All, I am coding for a requirement where I need to read a file & get the values of SUB_DATE. Once the dates are found, i need to move the files based on these dates from one directory to another. ie, this is how it will be in the file, SUB_DATE = 20120608,20120607,20120606,20120606... (5 Replies)
Discussion started by: dsfreddie
5 Replies

4. UNIX for Dummies Questions & Answers

Reading Table name from a list of files in a Directory

Hi , I have searched through the forum but not able to find out any help :( i have a directory having lot of files which contains sql statemtns eg : file 1 contains select from table_name1 where ..................... select from table_name2 where .......... select from ... (3 Replies)
Discussion started by: Trendz
3 Replies

5. UNIX for Dummies Questions & Answers

Need Help in reading N days files from a Directory & combining the files

Hi All, Request your expertise in tackling one requirement in my project,(i dont have much expertise in Shell Scripting). The requirement is as below, 1) We store the last run date of a process in a file. When the batch run the next time, it should read this file, get the last run date from... (1 Reply)
Discussion started by: dsfreddie
1 Replies

6. Shell Programming and Scripting

Reading in all files from parent directory (GAWK)

Hi all, I'm very, very new to scripting (let alone SHELL) and was wondering if anyone could help me out as I seem to be in a spot of bother. I collect data (.dat files) which are automatically seperated into several sub directories, so the file paths I'm reading in at the moment would be... (11 Replies)
Discussion started by: gd9629
11 Replies

7. Shell Programming and Scripting

Reading from Directory

I am trying to make a simple script where you type in a directory, and the script tells you how many directories are within the directory, how many files, and some other general file information. My problem is setting up a for loop to read the info about the files inside the specified directory.... (2 Replies)
Discussion started by: ajw08f
2 Replies

8. UNIX for Dummies Questions & Answers

Reading files in script from another directory

Hi I'm trying to call my files from different directories in my script. Can you please help me. Here is my script: #!/bin/bash #---------------------------------------------------------------------------------------------------------------------- #This script allows the user... (1 Reply)
Discussion started by: ladyAnne
1 Replies

9. AIX

reading files from a directory.

Hi all, I have a shell script where it processes a set of files from a particular directory (shared location among 4 servers). i.e. under this directory /shared/work/ I have a set of files that needs to be processed. Since the number of files are alot, I have this script to be run from 4... (2 Replies)
Discussion started by: haroon_a
2 Replies

10. Shell Programming and Scripting

Reading files in directory

Hi Everyone , have a nice day i need a help on this thing algo is something like in certain path like /root/user1 i have many files , i need a code which could open every file one by one and then each file has contents like this <moid>CcnCounters=CAPv3-Received-Total-Requests, Source =... (3 Replies)
Discussion started by: Dastard
3 Replies
Login or Register to Ask a Question