Sponsored Content
Top Forums Shell Programming and Scripting match range of different numbers by AWK Post 302339564 by repinementer on Thursday 30th of July 2009 11:46:48 PM
Old 07-31-2009
Hey

I have uploaded an excel file that has 3 worksheets including input1, input2 and desired output.

Based on the input2 value signs (positive or negative) ranges of output are given.
If its positive sign it is exactly as I mentioned in the previous picture.
If its negative sign there will be little change.

For understanding this I'll include another picture

Thanx
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

match numbers (awk)

i would like to enter (user input) a bunch of numbers seperated by space: 10 15 20 25 and use awk to print out any lines in a file that have matching numbers so output is: 22 44 66 55 (10) 77 (20) (numbers 10 and 20 matched for example) is this possible in awk . im using gawk for... (5 Replies)
Discussion started by: tanku
5 Replies

2. Shell Programming and Scripting

Match real numbers in AWK

I am looking for a better way to match real numbers within a specified tolerance range. My current code is as follows: if ($1 !~ /^CASE/) for(i=1;i in G;i++) if (G >= $5-1 && G <= $5+1) { print $1,$4,$5,J,G } else { print $1,"NO MATCH" } where $5 and G are... (3 Replies)
Discussion started by: cold_Que
3 Replies

3. Shell Programming and Scripting

awk to match a numeric range specified by two columns

Hi Everyone, Here's a snippet of my data: File 1 = testRef2: A1BG - 13208 13284 AAA1 - 34758475 34873943 AAAS - 53701240 53715412File 2 = 42MLN.3.bedS2: 13208 13208 13360 13363 13484 13518 13518My awk script: awk 'NR == FNR{a=$1;next} {$1>=a}{$1<=a}{print... (5 Replies)
Discussion started by: heecha
5 Replies

4. Shell Programming and Scripting

Range of numbers in HEX using AWK

Hi , How do i found out all the number in a range ( HEX) for example Input is 15CF:15D2 Output needed 15CF 15D0 15D1 15D2 Thanks (2 Replies)
Discussion started by: greycells
2 Replies

5. Shell Programming and Scripting

Awk numeric range match only one digit?

Hello, I have a text file with lines that look like this: 1974 12 27 -0.72743 -1.0169 2 1.25029 1974 12 28 -0.4958 -0.72926 2 0.881839 1974 12 29 -0.26331 -0.53426 2 0.595623 1974 12 30 7.71432E-02 -0.71887 3 0.723001 1974 12 31 0.187789 -1.07114 3 1.08748 1975 1 1 0.349933 -1.02217... (2 Replies)
Discussion started by: meridionaljet
2 Replies

6. Shell Programming and Scripting

Complex match of numbers between 2 files awk script

Hello to all, I hope some awk guru could help me. I have 2 input files: File1: Is the complete database File2: Contains some numbers which I want to compare File1: "NUMBERKEY","SERVICENAME","PARAMETERNAME","PARAMETERVALUE","ALTERNATENUMBERKEY"... (9 Replies)
Discussion started by: Ophiuchus
9 Replies

7. Shell Programming and Scripting

awk : match only the pattern string , not letters or numbers after that.

Hi Experts, I am finding difficulty to get exact match: file OPERATING_SYSTEM=HP-UX LOOPBACK_ADDRESS=127.0.0.1 INTERFACE_NAME="lan3" IP_ADDRESS="10.53.52.241" SUBNET_MASK="255.255.255.192" BROADCAST_ADDRESS="" INTERFACE_STATE="" DHCP_ENABLE=0 INTERFACE_NAME="lan3:1"... (6 Replies)
Discussion started by: rveri
6 Replies

8. Shell Programming and Scripting

Match on a range of numbers

Hi, I'm trying to match a filename that could be called anything from vout001 to vout252 and was trying to do a small test but I'm not getting the result I thought I would.. Can some one tell me what I'm doing wrong? *****@********>echo $mynumber ... (4 Replies)
Discussion started by: Jazmania
4 Replies

9. Shell Programming and Scripting

Get range out using sed or awk, only if given pattern match

Input: START OS:: UNIX Release: xxx Version: xxx END START OS:: LINUX Release: xxx Version: xxx END START OS:: Windows Release: xxx Version: xxx ENDHere i am trying to get all the information between START and END, only if i could match OS Type. I can get all the data between the... (3 Replies)
Discussion started by: Dharmaraja
3 Replies

10. Shell Programming and Scripting

awk to print text in field if match and range is met

In the awk below I am trying to match the value in $4 of file1 with the split value from $4 in file2. I store the value of $4 in file1 in A and the split value (using the _ for the split) in array. I then strore the value in $2 as min, the value in $3 as max, and the value in $1 as chr. If A is... (6 Replies)
Discussion started by: cmccabe
6 Replies
PSIGN(1)						      General Commands Manual							  PSIGN(1)

NAME
psign - produce a RADIANCE picture from text. SYNOPSIS
psign [ options ] [ text ] DESCRIPTION
Psign produces a RADIANCE picture of the given text. The output dimensions are determined by the character height, aspect ratio, number of lines and line length. (Also the character size if text squeezing is used.) If no text is given, the standard input is read. -cb r g b Set the background color to r g b The default is white (1 1 1). -cf r g b Set the foreground color to r g b The default is black (0 0 0). -dr Text reads to the right (default). -du Text reads upwards. -dl Text reads to the left (upside down). -dd Text reads downwards. -h cheight Set the character height to cheight. The default is 32 pixels. -a aspect Set the character aspect ratio (height/width) to aspect. The default value is 1.67. -x xsize Set the horizontal image size to xsize. Use with -y option (below) in place of the -h specification to control output image size directly. If the character aspect ratio (-a option, above) is non-zero, then one of the specified x or y output dimensions may be reduced to maintain this ratio. If direction is right (-dr) or left (-dl), then it is not necessary to give the -y option, since it can be computed from the character height (-h). -y ysize Set the vertical image size to ysize. Use with the -x option (described above). If direction is up (-du) or down (-dd), then it is not necessary to give the -x option, since it can be computed from the character height (-h). -s spacing Set the intercharacter spacing to spacing. The magnitude of this value is multiplied by the character height over the aspect ratio (ie. the character width) to compute the desired distance between characters in the output. The sign of the value, posi- tive or negative, determines how this ideal spacing is used in the actual placement of characters. If spacing is positive, then the overall width of the line will not be affected, nor will indentation of textual elements. Thus, the text format will be mostly unaffected. However, spacing between characters will reflect their relative size for a more natural appearance. If spac- ing is negative, characters will be squeezed together to meet the spacing critereon, regardless of how it might affect the format of the output. The default value for spacing is zero, which is interpreted as uniformly spaced characters. -f fontfile Load the font from fontfile. The default font is helvet.fnt EXAMPLE
To put a big "Hi!" on the terminal: psign -h 22 -a 1 -cb 0 0 0 -cf 1 1 1 Hi! | ttyimage ENVIRONMENT
RAYPATH path to search for font files AUTHOR
Greg Ward BUGS
The entire bitmap is stored in memory, which can be a problem for large and/or high-resolution signs. SEE ALSO
getinfo(1), pcompos(1), pfilt(1), ttyimage(1) RADIANCE
10/9/97 PSIGN(1)
All times are GMT -4. The time now is 04:01 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy