Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Help needed in case
Top Forums Shell Programming and Scripting Help needed in case Post 302877085 by radoulov on Thursday 28th of November 2013 04:09:53 AM
Old 11-28-2013
Assuming your file.txt contains the following lines:
Code:
"25319","45162","TEST","ADMIN","127.3.3.1","select * from test","2013-11-27 19:38:28","2013-11-27 19:38:28",11
"25319","45162","TEST","ADMIN","127.3.3.4","select * from test","2013-11-27 19:38:28","2013-11-27 19:38:28",11

Assuming that there are no embedded commas in the filed values.
Something like this might work for you:
Code:
_ips=( 
  tool1_127.3.3.1
  tool1_127.3.3.2
  tool1_127.3.3.3 
  tool2_127.3.3.4
  tool2_127.3.3.5
  tool2_127.3.3.6  
  )


while IFS=, read j j j j _ip j; do
  _ip=${_ip//\"}
  for _t_ip in "${_ips[@]}"; do
    [[ $_ip == ${_t_ip##*_} ]] && {
      echo send mail -- connection -- append from "${_t_ip%_*}"
      break 
      }
  done
done < file.txt

I get the following output:
Code:
$ ./s
send mail -- connection -- append from tool1
send mail -- connection -- append from tool2

Remove the echo if the output matches your expectations.
Last edited by radoulov; 11-28-2013 at 05:44 AM..
 

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

lower case to upper case string conversion in shell script

How can convert a Lower case variable value to an upper case in the kron shell script. (3 Replies)
Discussion started by: dchalavadi
3 Replies

2. Shell Programming and Scripting

help needed in using case statement

Hi, I have a script as below: ....................................................................... rpttxt() { name="$*" awk '/'"${name}"'/ {print $2$3$4 }' file_1.txt } title="`rpttxt "TITLE"`" ......................................................................... The... (0 Replies)
Discussion started by: jisha
0 Replies

3. Shell Programming and Scripting

Script needed to select and delete lower case and mixed case records

HELLO ALL, URGENTLY NEEDED A SCRIPT TO SELECT AND DELETE LOWER AND MIXED CASE RECORDS FROM A COLUMN IN A TABLE. FOR EXAMPLE : Table name is EMPLOYEE and the column name is CITY and the CITY column records will be: Newyork washington ... (1 Reply)
Discussion started by: abhilash mn
1 Replies

4. Shell Programming and Scripting

Help needed in switch case handling in UNIX

Hi, In below code, i am expecting the output has Bye Bye But i am getting has Bye Hi Code: #!/usr/bin/bash var="Hi" cat txt.txt | while read var1 do next="Bye" case $var in Hi) (1 Reply)
Discussion started by: Balamani
1 Replies

5. Shell Programming and Scripting

Help needed in Switch Case

Hi Experts team, i wish to use switch case in unix. my req is case $code in 1111) echo "1111" 1112) echo "1112" *) echo "default" esac see eventhough for particular case 1111 , it is always execute the default statement *), if i code like this. How can handle... (2 Replies)
Discussion started by: spkandy
2 Replies

6. Shell Programming and Scripting

data array needs to change upper case to lower case

Hi all, i have a data array as followes. ARRAY=DFSG345GGG ARRAY=234FDFG090 ARRAY=VDFVGBGHH so on.......... i need all english letters to be change to lower case. So i am expecting to see ARRAY=dfsg345ggg ARRAY=234fdfg090 ARRAY=vdfvgbghh so on........ If i have to copy this data in... (8 Replies)
Discussion started by: usustarr
8 Replies

7. Shell Programming and Scripting

sed ignoring case for search but respecting case for subtitute

Hi I want to make string substitution ignoring case for search but respecting case for subtitute. Ex changing all occurences of "original" in a file to "substitute": original becomes substitute Origninal becomes Substitute ORIGINAL becomes SUBSTITUTE I know this a little special but it's not... (1 Reply)
Discussion started by: kmchen
1 Replies

8. Shell Programming and Scripting

Conversion from Upper Case to Lower Case Condition based

Hello Unix Gurus : It would be really appreciative if can find a solution for this . I have records in a file . I need to Capitalize the records based on condition . For Example i tried the following Command COMMAND --> fgrep "2000YUYU" /export/home/oracle/TST/data.dat | tr '' ''... (12 Replies)
Discussion started by: tsbiju
12 Replies

9. Shell Programming and Scripting

Change first letter of a word from lower case to upper case

Hi all, I am trying to find a way to change first letter in a word from lower case to upper case. It should be done for each first word in text or in paragraph, and also for each word after punctuation like . ; : ! ?I found the following command sed -i 's/\s*./\U&\E/g' $@ filenamebut... (7 Replies)
Discussion started by: georgi58
7 Replies

LEARN ABOUT CENTOS

locale::codes::currency

Locale::Codes::Currency(3)				User Contributed Perl Documentation				Locale::Codes::Currency(3)

NAME

       Locale::Codes::Currency - standard codes for currency identification

SYNOPSIS

	   use Locale::Codes::Currency;

	   $curr = code2currency('usd');     # $curr gets 'US Dollar'
	   $code = currency2code('Euro');    # $code gets 'eur'

	   @codes   = all_currency_codes();
	   @names   = all_currency_names();

DESCRIPTION

       The "Locale::Codes::Currency" module provides access to standard codes used for identifying currencies and funds, such as those defined in
       ISO 4217.

       Most of the routines take an optional additional argument which specifies the code set to use. If not specified, the default ISO 4217
       three-letter codes will be used.

SUPPORTED CODE SETS

       There are several different code sets you can use for identifying currencies. A code set may be specified using either a name, or a
       constant that is automatically exported by this module.

       For example, the two are equivalent:

	  $curr = code2currency('usd','alpha');
	  $curr = code2currency('usd',LOCALE_CURR_ALPHA);

       The codesets currently supported are:

       alpha, LOCALE_CURR_ALPHA
	   This is a set of three-letter (uppercase) codes from ISO 4217 such as EUR for Euro.

	   Two of the codes specified by the standard (XTS which is reserved for testing purposes and XXX which is for transactions where no
	   currency is involved) are omitted.

	   This is the default code set.

       num, LOCALE_CURR_NUMERIC
	   This is the set of three-digit numeric codes from ISO 4217.

ROUTINES

       code2currency ( CODE [,CODESET] )
       currency2code ( NAME [,CODESET] )
       currency_code2code ( CODE ,CODESET ,CODESET2 )
       all_currency_codes ( [CODESET] )
       all_currency_names ( [CODESET] )
       Locale::Codes::Currency::rename_currency  ( CODE ,NEW_NAME [,CODESET] )
       Locale::Codes::Currency::add_currency  ( CODE ,NAME [,CODESET] )
       Locale::Codes::Currency::delete_currency  ( CODE [,CODESET] )
       Locale::Codes::Currency::add_currency_alias  ( NAME ,NEW_NAME )
       Locale::Codes::Currency::delete_currency_alias  ( NAME )
       Locale::Codes::Currency::rename_currency_code  ( CODE ,NEW_CODE [,CODESET] )
       Locale::Codes::Currency::add_currency_code_alias  ( CODE ,NEW_CODE [,CODESET] )
       Locale::Codes::Currency::delete_currency_code_alias  ( CODE [,CODESET] )
	   These routines are all documented in the Locale::Codes::API man page.

SEE ALSO

       Locale::Codes
	   The Locale-Codes distribution.

       Locale::Codes::API
	   The list of functions supported by this module.

       http://www.iso.org/iso/support/currency_codes_list-1.htm
	   The ISO 4217 data.

AUTHOR

       See Locale::Codes for full author history.

       Currently maintained by Sullivan Beck (sbeck@cpan.org).

COPYRIGHT

	  Copyright (c) 1997-2001 Canon Research Centre Europe (CRE).
	  Copyright (c) 2001	  Michael Hennecke
	  Copyright (c) 2001-2010 Neil Bowers
	  Copyright (c) 2010-2013 Sullivan Beck

       This module is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

perl v5.16.3							    2013-02-27						Locale::Codes::Currency(3)
All times are GMT -4. The time now is 06:43 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy