There are 2 inputfiles as I mentioned, Input1 and Input2.
Input1 has 3 columns. 1st one has keyvalues and 2nd ones has sub key values and 3rd one has numerical values (ranges like from 5-10, 30-40)
Code:
input1
a a1 5-10
30-40
45-60
80-90
100-120
x a2 10-20
50-60
Input2 has also 3 columns exactly like input1.1st one with key and 2nd one with subkey and 3rd one with various ranges of numbers like 1-4,1-4,120-140,140-120
Code:
input2
a a1 1-4
a a1 4-1
a a1 120-140
a a1 140-120
a a1 65-69
70-100
a a1 70-65
44-40
a a1 6-7
37-57
63-83
a a1 7-8
Now I need to name the input2 value ranges according the ranges given in input 1 like in the following output
Code:
output
a a1 1-4 outofrange1
a a1 4-1 outofrange2
a a1 120-140 outofrange3
a a1 140-12 outofrange4
a a1 65-69 inrange1
70-100
a a1 70-65 inrange2
44-40
a a1 6-7 inrange3
a a1 7-8 inrange4
As you can see 1-4 (the values from 1 to 4 in input2 are absent in input1) giving the name as outofrange1.
2nd one is little bit trciky if the value range is from high to low like 4-1 (the values from 4 to 1 in input2 are absent in input1). though it looks same as 1st case it has high value to low value range like 4 to 1. and given name as outofrange2
outofrange3 is same as outofrange1 outofrange4 is same as outofrange2
5th one, 65-69, inrange1 (the values from 65 to 69 in input2 are present in between the ranges in input1 but not with in the exact ranges giving the name as inrange1.
45-6065-6980-90
inrange2.[/B] is the trickiest version of inrange1.[/B](I mentioned before in ouofrange2)
7th one , 6-7, inrange3 (the values 6 to 7 in input 2 are exactly present in between the values of input 1), inrange3.
56-710
inrange4.[/B] is the trickiest version of inrange2.[/B]
And most importantly we are comparing the first range values of all the keys in input2 with all the key values in input1 like a-a1-65-69 with all the values in input2 a -a1- 5-10, 30-40, 45-60,80-90, 100-120
Hope it elucidate every thing clearly
Last edited by stateperl; 07-23-2009 at 12:02 AM..
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)
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)
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)
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)
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)
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)
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
LEARN ABOUT DEBIAN
mp3cut
MP3CUT(1) User Command MP3CUT(1)NAME
mp3cut - cut and assemble MP3 files
SYNOPSIS
mp3cut [ -o outputfile ] [ -T title ] [ -A artist ] [ -N album-name ] [ -t [hh:]mm:ss[+ms]-[hh:]mm:ss[+ms] ] mp3file [[ -t ... ] mp3file1
...]
DESCRIPTION
The mp3cut utility cuts and assembles MP3 files according to the time specifications given on the command line. The mp3 output is written
to the outputfile. If no outputfile is given on the command-line, the name for the outputfile is created from the name of the first mp3
file by adding output.mp3 at the end. The -t flag specifies which part of the mp3 file following it will be extracted.
OPTIONS -o outputfile
Specify where the output is to be written.
-T title
Specify the title ID3 tag for the output file.
-A artist
Specify the artist ID3 tag for the output file.
-N album-name
Specify the album name ID3 tag for the output file.
-t [hh:]mm:ss[+ms]-[hh:]mm:ss[+ms]
Specify which part of the following mp3file will be included in the output file.
hh = hours
mm = minutes
ss = seconds
ms = milliseconds
If the starting time is omitted, 00:00:00+00 is used as starting time. If the ending time is omitted, the end of the MP3 file is
used as ending time.
EXAMPLES
mp3cut -o output.mp3 -t 23:42+500-01:23:42+750 input.mp3
Cut the segment from 23 minutes, 42 seconds and 500 milliseconds to 1 hour, 23 minutes, 42 seconds and 750 milliseconds from
input.mp3 and write the output to output.mp3.
mp3cut -t 00:01-00:02 input1.mp3 -t -15:23 input2.mp3 -t 9:87+500- input3.mp3
Append the segments from input1.mp3, input2.mp3 and input3.mp3 and write the output to input1.output.mp3.
AUTHORS
Manuel Odendahl <manuel@bl0rg.net>, Florian Wesch <dividuum@bl0rg.net>
February 2005 MP3CUT(1)
07-22-2009
