Retrieving a specific value Post: 302528222

Sponsored Content

Top Forums Shell Programming and Scripting Retrieving a specific value Post 302528222 by click on Monday 6th of June 2011 04:45:38 PM

06-06-2011

Registered User

Both works

Code:

-bash-3.2$ awk -F"[:[]" 'NF==1{print ; next}{if($2<14&&$2!=""){$0=$1":"$2"[dB]"; print $0}} ' test
HTHa0101013>    Value
MOD_2_1:        13.9[dB]
HTHa0101014>
MOD_1_1:        10.2[dB]
HTHa0101015>
HTHa0101016>
MOD_1_1:        13.0[dB]
HTHa0101017>
MOD_2_1:        10.7[dB]
HTHa0101018>
HTHa0101020>
MOD_1_1:        13.2[dB]
HTHa0101021>
HTHa0101022>
MOD_1_1:        10.0[dB]
MOD_2_1:        11.2[dB]
-bash-3.2$ cat test

HTHa0101013>    Value
MOD_0_1:        20.5[dB]
MOD_1_1:        23.9[dB]
MOD_2_1:        13.9[dB]
HTHa0101014>
MOD_0_1:        26.2[dB]
MOD_1_1:        10.2[dB]
MOD_2_1:        27.8[dB]
HTHa0101015>
MOD_0_1:        28.0[dB]
MOD_1_1:        24.2[dB]
MOD_2_1:        28.6[dB]
HTHa0101016>
MOD_0_1:        24.6[dB]
MOD_1_1:        13.0[dB]
MOD_2_1:        27.6[dB]
HTHa0101017>
MOD_0_1:        19.0[dB]
MOD_1_1:        18.4[dB]
MOD_2_1:        10.7[dB]
HTHa0101018>
MOD_0_1:        24.9[dB]
MOD_1_1:        28.8[dB]
MOD_2_1:        22.3[dB]
HTHa0101020>
MOD_0_1:        19.6[dB]
MOD_1_1:        13.2[dB]
MOD_2_1:        16.9[dB]
HTHa0101021>
MOD_0_1:        19.1[dB]
MOD_1_1:        15.5[dB]
MOD_2_1:        27.5[dB]
HTHa0101022>
MOD_0_1:        20.8[dB]
MOD_1_1:        10.0[dB]
MOD_2_1:        11.2[dB]
-bash-3.2$ awk -v thr=14 -F '[:[]' '/>/ {h=$0;p=1;next} {if(NF>2 &&$2<thr){printf("%s%s\n", p?h ORS:"", $0);p=0}}' test
HTHa0101013>    Value
MOD_2_1:        13.9[dB]
HTHa0101014>
MOD_1_1:        10.2[dB]
HTHa0101016>
MOD_1_1:        13.0[dB]
HTHa0101017>
MOD_2_1:        10.7[dB]
HTHa0101020>
MOD_1_1:        13.2[dB]
HTHa0101022>
MOD_1_1:        10.0[dB]
MOD_2_1:        11.2[dB]
-bash-3.2$

click

View Public Profile for click

Find all posts by click

10 More Discussions You Might Find Interesting

1. AIX

doubt in retrieving date

Hello, instead of specifying the date manually in the list as below, for dt in 010106 010206 010306 010406 010506 010606 here for example : 010106 - 1st jan 2006 how to retrieve the date of a week automatically and put in a loop? is there any way to do? thanks in advance.

2. UNIX for Dummies Questions & Answers

Retrieving output interactively

Hi. I have a situation where I need to constantly read a command's output in order to loop through it to determine something that is happening over our system. The command td <filename> interactively prints 'filename' as text is written to it and this is redirected to standard output. I have been...

3. UNIX for Dummies Questions & Answers

Retrieving data

Friends, I have a data with 3 columns: 30 41 1 39 19 4 14 25 3 .... .... ..... I want to retrieve any data in the first column that is greater 15. What is the best way to do this? Thanks!

4. UNIX for Dummies Questions & Answers

retrieving files which has more than 0 bytes

Hi, Can anyone tell how to list all files in current directory which has more than 0 bytes?

5. Solaris

help retrieving files from SunOS 5.8

Hi, I am trying to get a small amount of files off of a SunBlade 2000 running SunOS 5.8, but I'm having trouble finding a medium that will actually work. It is not networked, and it doesn't have a writable CD drive. My only options seem to be floppy disk and USB drive. However, when I insert...

6. Shell Programming and Scripting

retrieving specific lines from a file - can I use grep ?

Hi there, if i had a file that looked like this my_server1 red green blue yellow blue my_server2 blue blue yellow green blue my_server3 yellow

7. Shell Programming and Scripting

error in retrieving records from DB

Hi ., I have 3 records in a oracle table... wen i connect to oracle from unix environment and query the table i get some errors... the script i used is g=`sqlplus -s "username/password" << EOF select column from table; EOF` if then echo $g fi The output i get...

8. Shell Programming and Scripting

Retrieving File name

Hi All.. I have a Filename as FAB1_600015_CONRAD.A0_7XYZ12345.000_LT-SWET.01_LTPA25L_20110622-161429_07_WFR12345_20110622-161429_20110712-125228.data.dis I want to get the result as...

9. UNIX for Dummies Questions & Answers

retrieving data between two strings

I have input file like AAA AAA CCC CCC CCC EEE EEE EEE EEE FFF FFF GGG GGG i was trying to retrieve data between two strings using sed. sed -n /CCC/,/FFF/p input_file Am getting output like CCC CCC CCC

10. Shell Programming and Scripting

Passing argument not retrieving.

Hi I have a script which am trying to pass an argument which am trying to call using $1 but its not taking the value inside the if loop as it showing the error as if: Empty if.. Any help on this will be helpful. #!/usr/bin/csh echo $1 if ('$1' == "pp") then echo "Printing $1" endif

LEARN ABOUT POSIX

libbash

LIBBASH(7)							  libbash Manual							LIBBASH(7)

NAME

     libbash -- A bash shared libraries package.

DESCRIPTION

     libbash  is  a package that enables bash dynamic-like shared libraries. Actually its a tool for managing bash scripts whose functions you may
     want to load and use in scripts of your own.

     It contains a 'dynamic loader' for the shared libraries ( ldbash(1)), a configuration tool (ldbashconfig(8)), and some libraries.

     Using ldbash(1) you are able to load loadable bash libraries, such as getopts(1) and hashstash(1).  A bash shared library that can be  loaded
     using
     ldbash(1) must answer 4 requirments:

     1.     It must be installed in $LIBBASH_PREFIX/lib/bash (default is /usr/lib/bash).

     2.     It must contain a line that begins with '#EXPORT='.  That line will contain (after the '=') a list of functions that the library
	    exports.  I.e. all the function that will be usable after loading that library will be listed in that line.

     3.     It must contain a line that begins with '#REQUIRE='.  That line will contain (after the '=') a list of bash libraries that are
	    required for our library.  I.e. every bash library that is in use in our bash library must be listed there.

     4.     The library must be listed (For more information, see ldbashconfig(8)).

   Basic guidelines for writing library of your own:
     1.     Be aware, that your library will be actually sourced. So, basically, it should contain (i.e define) only functions.

     2.     Try to declare all variables intended for internal use as local.

     3.     Global variables and functions that are intended for internal use (i.e are not defined in '#EXPORT=') should begin with:
		  __<library_name>_
	    For example, internal function myfoosort of hashstash library should be named as
		  __hashstash_myfoosort
	    This helps to avoid conflicts in global name space when using libraries that come from different vendors.

     4.     See html manual for full version of this guide.

AUTHORS

     Hai Zaar <haizaar@haizaar.com>
     Gil Ran <ril@ran4.net>

SEE ALSO

     ldbash(1), ldbashconfig(8), getopts(1), hashstash(1) colors(1) messages(1) urlcoding(1) locks(1)

Linux								       Epoch								     Linux

10 More Discussions You Might Find Interesting

1. AIX

doubt in retrieving date

Discussion started by: sumi

2. UNIX for Dummies Questions & Answers

Retrieving output interactively

Discussion started by: fidodido

3. UNIX for Dummies Questions & Answers

Retrieving data

Discussion started by: bobo

4. UNIX for Dummies Questions & Answers

retrieving files which has more than 0 bytes

Discussion started by: sri2005