Sponsored Content
Top Forums Shell Programming and Scripting shell script pattern matching Post 302351910 by Annihilannic on Thursday 10th of September 2009 02:07:40 AM
Old 09-10-2009
What's the problem with your existing code? Is it not working as you expect?

I presume for the second example you meant to insert into the "hotmail_email" column, not "yahoo_email".

I would do something like this:

Code:
#!/bin/sh

#email="example@yahoo.com"
#email="example@hotmail.com"
email="example@gmail.com"

case $email in
        *@yahoo.*)
		table=yahoo_email
		;;
	*@hotmail.*)
		table=hotmail_email
		;;
	*)
		table=standard_email
		;;
esac

mysql<<EOF
	INSERT INTO db.table $table VALUES ('$email');
EOF

I presume your insert statement will need a "where" clause though...
 

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
icapnotify(1M)															    icapnotify(1M)

NAME
icapnotify - Test email connectivity to HP for Instant Capacity (iCAP) systems. Request a confirmation response email from HP. Turn config- uration change notification and asset reporting on or off. SYNOPSIS
icapnotify <reply_address> icapnotify -a on|off icapnotify -n on|off Obsolescent: icod_notify <reply_address> icod_notify -a on|off icod_notify -n on|off DESCRIPTION
When a reply_address is specified, sends an asset report via email to HP, root, and the specified email address. Confirmation email is sent from HP to the specified reply email address indicating that HP received the asset report email. Note that asset reporting is optional but can be useful for viewing complexwide asset information at the HP Utility Pricing Solutions por- tal (http://www.hp.com/go/icap/portal). The deprecated command provides identical functionality to the command and is maintained for backward compatibility. For detailed information on email configuration and requirements, see the located at /usr/share/doc/icapUserGuide.pdf. Options The command recognizes these options and arguments: -a on|off Turns email asset reporting on or off. This option is used to specify if the Instant Capacity software should send asset reports to HP via email. The command displays the present setting for this option. -n on|off Turns configuration change notification on or off. If specified on, executing the command results in a configuration change notification email sent to the system contact email address summarizing any configuration change. Configuration change notification email can be turned off by specifying off. Configuration change notifications are not sent if the system contact email address is not set. EXTERNAL INFLUENCES
Environment Variables o LANG determines the locale to use for the locale categories when both LC_ALL and the corresponding environment variable (begin- ning with LC_) do not specify a locale. If LANG is not set or is set to the empty string, a default of C is used (see lang(5)). o LC_CTYPE determines the interpretation of single- and multiple-byte characters. o LC_MESSAGES determines the language in which messages are displayed. If any internationalization variable contains an invalid setting, icapnotify behaves as if all internationalization variables are set to C (see environ(5)). International Code Set Support Single- and multiple-byte character code sets are supported. RETURN VALUE
The command exits with one of these values: 0 Command succeeded. >0 Command failed; error message sent to STDERR. EXAMPLES
Test email connectivity with HP by sending an asset report to HP, root , and super_user@corp.com, and request a confirmation email from HP to be sent to super_user@corp.com: icapnotify super_user@corp.com Turn email asset reporting on: icapnotify -a on Turn email asset reporting off: icapnotify -a off Turn configuration change notification on: icapnotify -n on Turn configuration change notification off: icapnotify -n off AUTHOR
was developed by HP. SEE ALSO
icapmodify(1M), icapstatus(1M), icapmanage(1M), icapd(1M), icap(5). icapnotify(1M)
All times are GMT -4. The time now is 02:26 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy