Sponsored Content
Top Forums Shell Programming and Scripting shell script pattern matching Post 302351811 by mirfan on Wednesday 9th of September 2009 04:09:13 PM
Old 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

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

2. Shell Programming and Scripting

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... (5 Replies)
Discussion started by: rakeshforum
5 Replies

3. 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

4. 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

5. Homework & Coursework Questions

shell script that can create, monitor the log files and report the issues for matching pattern

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

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

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

8. 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

9. 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

10. 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
GOTMAIL(1)						      General Commands Manual							GOTMAIL(1)

NAME
gotmail - A script to fetch mail from a Hotmail mailbox. SYNOPSIS
gotmail [-u username] [-p password] [--help] [--version] ... DESCRIPTION
This manual page documents the gotmail script. Gotmail is a perl script to fetch mail out of a Hotmail account and either place it into the current directory in unix mbox format or for- ward it to another email address. OPTIONS
-?, --help, --usage Show summary of options. -u, --username username Specify your hotmail account username. -p, --password password Specify your hotmail account password. (Warning: using this on the command line is insecure. It is suggested that you use a configu- ration file--see below) -d, --domain domain Specify an acceptable hotmail domain: hotmail.com (default), hotmail.com (default), msn.com, charter.com, compaq.net, hotmail.co.jp, hotmail.co.uk, hotmail.de, hotmail.fr, hotmail.it, messengeruser.com, passport.com, webtv.net --version Print the version number. --debug Print and log debug spew. -v, --verbose Be verbose. --silent Be as quiet as possible. -c, --config-file file Specifies a different configuration file than the default (~/.gotmailrc). See below. --proxy host:port Specify an HTTP proxy to use. Format is host:port - eg: localhost:3128 -f, --forward address Specify an email address to forward to. If a forwarding address is not given, messages will be saved to disk. -s, --smtpserver server Send email via the specified smtp server, rather than with sendmail. This allows use of Gotmail under Windows 2000, at least. May work elsewhere. --exclude-folders folders Do not get these folders (list of folders in quotes, i.e.: "Inbox, Bulk Mail") --folders folderlist The --folders option only downloads messages from folders that are in the list given. eg. gotmail --folders "bulk mail, inbox" will get the bulk mail and inbox folders only. The list separator should now be a comma, optionally with whitespace on either side. --folder-dir /my/dir Specify which directory to put email folders in. The folders will be saved as mbox-compatible files named after the folders on Hot- mail. --only-new Only previously unread messages will be retrieved. --mark-read Mark messages as read once they have been downloaded. --delete Delete messages once they have been downloaded. This option is being deprecated as of version 0.8.2. Use the --move <folder> com- mand to move downloaded mails to the Trash Can instead. --move <folder> Move mails to the named folder after downloading. --speed-limit Add a small delay after each message to stop the local MTA from being overloaded. --retry-limit num_tries Maximum number of times to retry a download. --save-to-login When this option is specified, saves messages to "username-foldername" in the folder-dir directory. The Inbox folder is saved to just "username". --use-procmail This option sends all messages only to procmail(1). Options to forward or save to mailboxes are ignored. --procmail-bin /path/to/procmail Allows user to set location of the procmail binary. Default is "/usr/bin/procmail". --procmail-option <opt> Pass options through to procmail --curl-bin /path/to/curl Allows user to set location of the curl binary. Default is to search the path. --use-sa Use SpamAssassin to detect junk mail. --delete-spam Delete junk mail instead of just ignoring it (requires --use-sa option). --move-spam folder Move spam to this folder (requires --use-sa option). --spam-score score SpamAssassin score to be considered spam. Default is 4.5. --nodownload Don't actually download or forward mail. Useful when used with the --delete-spam option. --summary Print the number of messages received one line per folder. --remove-header Automatically remove X-Message-Info header to not trigger X_MESSAGE_INFO rule in SpamAssassin. EXAMPLES
Download all the mail from the account of "billyjoe@hotmail.com" with password "sEcReT" and forward it to "john@ab.com". gotmail -u billyjoe -p sEcReT -f john@ab.com (This is insecure!) Download, and delete, new mail only in the Inbox and MyMail folders of uro_levu's Hotmail account. Save the resulting mail in mbox files named after the folders ("Inbox" and "MyMail") under the warmmail/ directory. gotmail -u uro_levu -p my_password --delete --only-new --folder-dir $HOME/warmmail --folders "Inbox, MyMail" (This is insecure!) Scan the mail in the Inbox and move anything with a SpamAssassin score of 5 or better to a folder named Spam, but don't actually download anything. gotmail --folders "Inbox" -u billyjoe -p sEcReT --use-sa --nodownload --move-spam Spam --spam-score 5 (This is insecure!) Configuration You can put the configuration for gotmail in a file. This has the significant advantage of not putting your username and password on the command line, where it is possible for others on your machine to read them. By default, gotmail will look for a file in your home directory called ".gotmailrc". You can specify a different one with the --config-file option. Options on the command line will override options in the configuration file. Configuration files may contain comments (Lines beginning with #). Options in the file are identical to the long arguments listed above, and are assigned values using an = sign. Do not add extra whitespace before or after the =. This very simple configuration file gets all the mail from the account of randomuser@hotmail.com, password "ger0nim34": # randomuser's gotmailrc file username=randomuser password=ger0nim34 This slightly more complex example causes gotmail to quietly download and delete all mail in the account of linux@hotmail.com, and forward it to linux@yahoo.com. # .gotmailrc username=linux password=FreesOftwareForever forward=linux@yahoo.com silent delete AUTHORS
This manual page was written by Peter Hawkins <peter@hawkins.emu.id.au>, for the Debian GNU/Linux system (but may be used by others). Addi- tions were made by paul cannon <pik@debian.org> and James Turnbull <james@lovedthanlost.net>. Additional contributions from John Fruetel, Jon Phillips, Guyang Mao, Didier CLERC, Leigh Purdie, Sh, Patrick Froede, Herman Mereles, Kamal Kantawala, Andrei Popov, Kamal Mahyuddin, Hindu, Joel Mejeur, Wesley Hosking, Max Hales, Brian Almeida, Jens Preikschat, Jonas Smedegaard, Robert Lazzurs, Tim Dijkstra, Hari Sundararaghavan, Silas S. Brown, Adrian Chung, Lalit Chhabra, Loic TREGOUET, Sean D. True, Timothy Lee, stripes, David Holland, Sergio Rua, Lee, William X. Walsh,Chris Ham, Angel Luis Jimenez Martinez, James Ascroft-Leigh, Andrea Brig- anti,cageek, Brad Donison, Jens E. Madsen Jr., Paul Howarth, Gertjan Harkink, Jos De Laender, jdanwhite, and Manoajv Sridhar. GOTMAIL(1)
All times are GMT -4. The time now is 08:15 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy