shell pattern matching


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting shell pattern matching
# 1  
Old 09-15-2008
Network shell pattern matching

Hello Members

I am facing a problem regarding pattern matching.please guide me to solve the issue.My requirement is like:
There is table in oracle database, in that table contain columns ,inside the column so many files are there. my requirement is that to search a pattern for example: pattern is "123456" . Write a shell script that search the pattern one by one file(i.e it takes the file one by one from table) . if inside a file pattern doesn't exist then it will redirect this pattern and file name to some other file.

Please give me some idea so that i can move ahead, any help will be highly appreciated.

Thanks
Rakesh

Last edited by rakeshforum; 09-15-2008 at 05:45 AM..
# 2  
Old 09-15-2008
please reply me soon
# 3  
Old 09-15-2008
First tell us what you have tried.

So that we can suggest you improvement..
# 4  
Old 09-15-2008
Quote:
Originally Posted by rakeshforum
please reply me soon
Bump up questions is not allowed, please read our rules.
# 5  
Old 09-15-2008
Plz try this one..

Hi Rakesh I didn't work in Oracle but I could suggest this way to try:Smilie
Please check it before running. I didn't check this program..
===========================
chk_file ()
{
echo "Enter the destination direcory nm: [Give the full path]"
read dest

for f in `cat $1`
do
if [ -f $f ] && [ ` grep "(pattern like:1234)" $f | wc -w ` != 1 ]; then

mv $f $dest

fi
done

}

# login to unix machine(check the instance)

echo "`dbaccess db_nm << EOFSQL 2>> /dev/null/
SELECT col_nm FROM Tab_nm;
EOFSQL`" > file_nms.tmp


chk_file file_nms.tmp
# 6  
Old 09-15-2008
Plz try this...(FOR ORACLE)
chk_file ()
{
echo "Enter the destination direcory nm: [Give the full path]"
read dest

for f in $1
do
if [ -f $f ] && [ ` grep "(pattern like:1234)" $f | wc -w ` != 1 ]; then

mv $f $dest

fi
done

}

file_nm=`sqlplus -S usernm/passwd@host_string <<EOF
set head off feedback off echo off pages 0
SELECT col_nm FROM tab_nm`
/
EOF

chk_file file_nm

Last edited by Niroj; 09-15-2008 at 08:06 AM..
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Big pattern file matching within another pattern file in awk or shell

Hi I need to do a patten match between files . I am new to shell scripting and have come up with this so far. It take 50 seconds to process files of 2mb size . I need to tune this code as file size will be around 50mb and need to save time. Main issue is that I need to search the pattern from... (2 Replies)
Discussion started by: nitin_daharwal
2 Replies

2. Shell Programming and Scripting

Non-greedy pattern matching in shell script

Hi all, Is Perl included by default in Ubuntu? I'm trying to write a program using as few languages as possible, and since I'm using a few Perl one-liners to do non-greedy matching, it's considered another language, and this is a bad thing. Basically, I'm using a Perl one-liner to grab XML... (3 Replies)
Discussion started by: Zel2008
3 Replies

3. Shell Programming and Scripting

Pattern matching and replace in shell script

Hi I want to find a line in a file which contains a word and replace the patterns. Sample file content temp.xml ==================== <applications> <application> Name="FirstService" location="http://my.website.selected/myfirstService/V1.0/myfirst.war" ... (1 Reply)
Discussion started by: sakthi.99it
1 Replies

4. Shell Programming and Scripting

Help me to find files in a shell script with any matching pattern

Hi friends.. I have many dirs in my working directory. Every dir have thousands of files (.jsp, .java, .xml..., etc). So I am working with an script to find every file recursively within those directories and subdirectories ending with .jsp or .java which contains inside of it, the the pattern... (3 Replies)
Discussion started by: hnux
3 Replies

5. Shell Programming and Scripting

awk pattern matching and shell issue.

Please help me in this issue. I am unable to get the job,seems the awk not browsing the files. Please find my tries below. I have attached two files : 1.tobesearched.txt - a glimpse of a huge log file. 2.searchstring.txt - searching keys. these are the two scripts i tried writing: ... (7 Replies)
Discussion started by: deboprio
7 Replies

6. Shell Programming and Scripting

Korn Shell for pattern matching and extracting

Guys, i'm new to shell scripting. Here's what i need. I need a shell script which would read a file containing only 1 line which never changes. File containts - SQL_Mgd_Svc_ELONMCL54496 |EMEA\brookkev, EMEA\fieldgra, EMEA\tidmamar, EMEA\attfiste, EMEA\baldogar, EMEA\clarkia2, EMEA\conwasha,... (9 Replies)
Discussion started by: butterfly20
9 Replies

7. Shell Programming and Scripting

Pattern matching in shell script

Hi, I am using following command to extract string from a file. String will be after last / (slash). awk -F\ / '{print $NF}' $FILE but while appending the output in file in script, it dosent work. File created but of zero size... can anyone please help `awk -F\\\/ '{print $NF}' $FILE` >... (3 Replies)
Discussion started by: Deei
3 Replies

8. Shell Programming and Scripting

shell script pattern matching

Hi, I need to create a shell script through which i need to populate email addresses in email columns of database table in mysql. Let say if email contains yahoo, hotmail, gtalk than email addresses need to move in their respective columns. # !/bin/sh yim="example@yahoo.com"... (3 Replies)
Discussion started by: mirfan
3 Replies

9. Shell Programming and Scripting

Pattern matching in shell scripting.

Hey Guys, I have a shell script that is very simple and does the following. #!/usr/bin/bash set -x echo -n "can you write device drivers?" read answer if then echo "wow, you must be very skilled" else echo "neither can i, i am just shell script" fi you see where the... (6 Replies)
Discussion started by: Irishboy24
6 Replies

10. Shell Programming and Scripting

Pattern matching in a shell script?

I'm looking for a way to match a particular string in another string and if a match is found execute some command. I found the case statement can be used like this; case word in ) command ;; ] ... esac If my string to find is say "foo" in the string $mystring... (1 Reply)
Discussion started by: paulobrad
1 Replies
Login or Register to Ask a Question