Retrieving a specific value Post: 302528209

Sponsored Content

Top Forums Shell Programming and Scripting Retrieving a specific value Post 302528209 by Ernst on Monday 6th of June 2011 04:16:27 PM

06-06-2011

Registered User

Unfortunately, neither code works for me. They kept printing only the first column.

Quote:

HTHa0101013> Value
HTHa0101014>
HTHa0101015>
HTHa0101016>
HTHa0101017>
HTHa0101018>
HTHa0101020>
HTHa0101021>
HTHa0101022>

Let me post the real file that I am using so you can try it also.

Code:

HTHa0101013>    ru
MOD_0_1:    20.5[dB]
MOD_1_1:    23.9[dB]
MOD_2_1:    Type
HTHa0101014>    ru
MOD_0_1:    26.2[dB]
MOD_1_1:    20.2[dB]
MOD_2_1:    27.8[dB]
HTHa0101015>    ru
MOD_0_1:    28.0[dB]
MOD_1_1:    24.2[dB]
MOD_2_1:    28.6[dB]
HTHa0101016>    ru
MOD_0_1:    24.6[dB]
MOD_1_1:    23.0[dB]
MOD_2_1:    27.6[dB]
HTHa0101017>    ru
MOD_0_1:    19.0[dB]
MOD_1_1:    18.4[dB]
MOD_2_1:    20.7[dB]
HTHa0101018>    ru
MOD_0_1:    24.9[dB]
MOD_1_1:    28.8[dB]
MOD_2_1:    22.3[dB]
HTHa0101020>    ru
MOD_0_1:    19.6[dB]
MOD_1_1:    23.2[dB]
MOD_2_1:    16.9[dB]
HTHa0101021>    ru
MOD_0_1:    19.1[dB]
MOD_1_1:    25.5[dB]
MOD_2_1:    27.5[dB]
HTHa0101022>    ru
MOD_0_1:    20.8[dB]
MOD_1_1:    20.0[dB]
MOD_2_1:    21.2[dB]

My expected output value is:

Quote:

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]

I used these codes:

Code:

wk -F"[:[]" ' { if (substr($0,0,3)=="HTHa010") print $0; else if ($2<14) print
$0}' tt > tt1.xls

Code:

wk -F"[:[]" 'NF==1{print ; next}{if($2<14&&$2!=""){$0=$1":"$2"[dB]"; print $0}}
 ' tt

Not getting the desired result.

Last edited by radoulov; 06-06-2011 at 05:29 PM.. Reason: Code tags.

Ernst

View Public Profile for Ernst

Find all posts by Ernst

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 CENTOS

paps

PAPS(1) 						      General Commands Manual							   PAPS(1)

NAME

       paps - UTF-8 to PostScript converter using Pango

SYNOPSIS

       paps [options] files...

DESCRIPTION

       paps reads a UTF-8 encoded file and generates a PostScript language rendering of the file. The rendering is done by creating outline curves
       through the pango ft2 backend.

OPTIONS

       These programs follow the usual GNU command line syntax, with long options starting with  two  dashes  (`-').   A  summary  of  options	is
       included below.

       --landscape
	      Landscape output. Default is portrait.

       --columns=cl
	      Number of columns output. Default is 1.

       --font=desc
	      Set the font description. Default is Monospace 12.

       --rtl  Do rtl layout.

       --paper ps
	      Choose paper size. Known paper sizes are legal, letter, a4. Default is A4.

       --bottom-margin=bm
	      Set bottom margin in postscript points (1/72 inch). Default is 36.

       --top-margin=tm
	      Set top margin. Default is 36.

       --left-margin=lm
	      Set left margin. Default is 36.

       --right-margin=rm
	      Set right margin. Default is 36.

       --help Show summary of options.

       --header
	      Draw page header for each page.

       --markup
	      Interpret the text as pango markup.

       --encoding=ENCODING
	      Assume the documentation encoding is ENCODING.

       --lpi  Set the lines per inch. This determines the line spacing.

       --cpi  Set the characters per inch. This is an alternative method of specifying the font size.

       --stretch-chars
	      Indicates  that  characters  should be stretched in the y-direction to fill up their vertical space. This is similar to the texttops
	      behaviour.

AUTHOR

       paps was written by Dov Grobgeld <dov.grobgeld@gmail.com>.

       This manual page was written by Lior Kaplan <kaplan@debian.org>, for the Debian project (but may be used by others).

								  April  17, 2006							   PAPS(1)

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

5. Solaris

help retrieving files from SunOS 5.8

Discussion started by: ryanm

6. Shell Programming and Scripting

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

Discussion started by: hcclnoodles

7. Shell Programming and Scripting

error in retrieving records from DB

Discussion started by: cratercrabs

8. Shell Programming and Scripting

Retrieving File name

Discussion started by: asheshrocky

9. UNIX for Dummies Questions & Answers

retrieving data between two strings

Discussion started by: NareshN

10. Shell Programming and Scripting

Passing argument not retrieving.

Discussion started by: rogerben

LEARN ABOUT CENTOS

paps