04-21-2009
checking thorough files and renamingit
hi all
am very new to unix scripting.....
i have a work right now that i should complete by End of Day
scenario is
i get some x number of files with .csv extension on a specified path at my operating system. the names of the files are as follows . the record lay out is same for all the tables except that the data is different
Boost_Deactivation_<yyyymmdd>.csv
T Mobile_Deactivation_<yyyymmdd>.csv
Sprint_Deactivation_<yyyymmdd>.csv
i should
1)connect from oracle to this path..
2)ooop through each of the files that exist
3)rename them to a common name
4) concatenate them in to a single file
5)backup the files to backup folder
how to do it please help me .. its very very urgent am totally clueless of how to do
regards
raj
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I have automated my ftp session as given in on of the previous threads as:
#! /usr/bin/ksh
HOST=remote.host.name
USER=whoever
PASSWD=whatever
exec 4>&1
ftp -nv >&4 2>&4 |&
print -p open $HOST
print -p user $USER $PASSWD
print -p cd directory
print -p binary
print -p get xyz
wait... (3 Replies)
Discussion started by: jithinravi
3 Replies
2. Shell Programming and Scripting
Hi All,
Good Day.
need one help regarding unix script.
i have to check whether the particular file is there or not in another ip address.
suppose....there is file in this ip address 2.160.64.130 in particualar location.
i have to veify this from another ip adress(Say 2.160.64.131).if the file... (2 Replies)
Discussion started by: saikumar_n
2 Replies
3. Shell Programming and Scripting
I need to write a script for:
I have two files where I need to check entries and sort of compare:
file1:
data01
data02
data03
data04
data05
.
.
.
data81
file2:
/vol/vx/data01
/vol/vx/data02
/vol/vx/data03
/vol/vx/data04
/vol/vx/data05
. (8 Replies)
Discussion started by: za_7565
8 Replies
4. Shell Programming and Scripting
I m having trouble in a script.I need To write a script that will check for Following Errors in Logs Files,i.e files having Extension .log
The erros are
2008-01-01 15:19:11,822 ERROR - ORA-01115: IO error reading block from file 51 (block # 717090)
ORA-01110: data file 51:... (4 Replies)
Discussion started by: ali560045
4 Replies
5. UNIX for Dummies Questions & Answers
Hi,
I need one line command to display all files that ends with .scr.
Example: In a directory I have 10 files, out of that 4 files have filetype extension .dat and 4 files with .scr and 2 files with .txt.... In this i want to display only files that ends with .scr.
I tried some commands,... (2 Replies)
Discussion started by: gwgreen1
2 Replies
6. Shell Programming and Scripting
I have tried the following script to check for the presence of any files in a folder:
if (-r *) then
goto ZipMiscFiles
else
echo ""
echo " No Miscellaneous files found. Exiting program."
echo ""
exit
endif
The -r works fine with the wildcard in combo with other... (4 Replies)
Discussion started by: phudgens
4 Replies
7. Shell Programming and Scripting
i have two files which contains some fields separated by columns as
03/29/1999 08:48:12 02 172.16.114.50
03/29/1999 09:08:00 480 172.16.112.100
Both of the files do have the same format
I want the script which will take two such... (3 Replies)
Discussion started by: vaibhavkorde
3 Replies
8. Shell Programming and Scripting
Hi Guys,
I wrote a code which checks for the text and directory. If the path is incorrect than it should echo that particular path not found. I can create a different if statments but I want to do this in just one if statment with the use of "or" (||). I have succssfully executed this code but now... (2 Replies)
Discussion started by: dixits
2 Replies
9. Shell Programming and Scripting
Hi,
My requirement is,there is a directory location like:
:camp/current/
In this location there can be different flat files that are generated in a single day with same header and the data will be different, differentiated by timestamp, so i need to verify how many files are generated... (10 Replies)
Discussion started by: srikanth_sagi
10 Replies
10. Shell Programming and Scripting
Hi All,
I am trying to put a condition to check if two required files are not present in a particular directory and alert accordingly.
cd /root
F1=sample1
F2=sample2
if ]
then
echo "One of the files is not present"
else
echo "Both the files are present"
fi
Though both F1 and... (7 Replies)
Discussion started by: swasid
7 Replies