09-09-2009
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"
msn="example@hotmail.com"
gtalk="example@gmail.com"
case $yim in
*yahoo*)
mysql <<EOF
INSERT INTO db.table yahoo_email VALUES ('$yim');
EOF
case $msn in
*hotmail*)
mysql<<EOF
INSERT INTO db.table yahoo_email VALUES ('$msn');
EOF
esac;;
What should be the appropriate way to do this kind of job done. Please reply me as soon as possible.
Thanks,
Irfan
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
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
2. Shell Programming and Scripting
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... (5 Replies)
Discussion started by: rakeshforum
5 Replies
3. Shell Programming and 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
4. Shell Programming and Scripting
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
5. Homework & Coursework Questions
Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted!
1. The problem statement, all variables and given/known data:
Write an automated shell program(s) that can create, monitor the log files and report the issues for matching... (0 Replies)
Discussion started by: itian2010
0 Replies
6. Shell Programming and Scripting
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
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
8. Shell Programming and Scripting
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
9. Shell Programming and Scripting
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
10. Shell Programming and Scripting
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
LEARN ABOUT DEBIAN
ftpmail
ftpmail(1) General Commands Manual ftpmail(1)
NAME
ftpmail - FIFO-based Perl script for sending email based on proftpd TransferLog
SYNOPSIS
ftpmail [ --help ] [ --fifo fifo-path ] [ --from email-address ] [ --log xferlog-file ] [ --recipient email-address ] [ --subject email-
subject ] [ --smtp-server server-address ] [ --attach-file ] [ --auth smtp-auth-info-file ] [ --ignore-users regex-pattern ] [ --watch-
users regex-pattern ]
DESCRIPTION
ftpmail is a Perl script designed to read ProFTPD's TransferLog log entries, watching for uploads, and to send an automatic email notifica-
tion when uploads occur. To use ftpmail , you configure your proftpd daemon to write its TransferLog to a FIFO; the ftpmail program is a
FIFO reading program which then processes those log messages.
OPTIONS
--help Display a short usage description, including all available options.
--attach-file
If used, this will cause a copy of the uploaded file to be included, as an attachment, in the generated email.
--auth smtp-auth-info-file
Configures the path to a file containing SMTP authentication information. The configured file should look like this:
user username
password password
--fifo fifo-path
Indicates the path to the FIFO to which proftpd is writing its TransferLog. That is, this is the path that you used for the
TransferLog directive in your proftpd.conf. This parameter is REQUIRED.
--from email-address
Specifies the email address to use in the From email header. This parameter is REQUIRED.
--ignore-users regex-pattern
Specifies a Perl regular expression. If the uploading user name matches this regular expression, then an email notification is
NOT sent; otherwise, an email is sent.
--log xferlog-path
Since this script reads the TransferLog using FIFOs, the actual TransferLog file is not written by default. Use this option to
write the normal TransferLog file, in addition to watching for uploads.
--recipient email-address
Specifies an email address to which to send an email notification of the upload. This option can be used multiple times to
specify multiple recipients. AT LEAST ONE recipient is REQUIRED.
--smtp-server server-address
Specifies the SMTP server to which to send the email. This parameter is REQUIRED.
--subject subject
Specify a custom Subject email header for the email sent. The default Subject is:
User '$user' uploaded file '$file' via FTP
--watch-users regex-pattern
Specifies a Perl regular expression. If the uploading user name matches this regular expression, then an email notification is
sent; otherwise, no email is sent.
FILES
/var/log/xferlog
AUTHORS
ProFTPD is written and maintained by a number of people, full credits can be found on http://www.proftpd.org/credits.html
SEE ALSO
proftpd(8), xferlog(5)
Full documentation on ProFTPD, including configuration and FAQs, is available at http://www.proftpd.org/
For help/support, try the ProFTPD mailing lists, detailed on http://www.proftpd.org/lists.html
Report bugs at http://bugs.proftpd.org/
March 2011 ftpmail(1)