01-27-2006
record match
Hello.,
i have to txt files..,
FILE1=/home/pavi/DS.txt
FILE2=/home/pavi/chain.txt
awk -F ":" '{print $1}' $FILE1 > f1.txt
awk -F " " '{print $2}' $FILE2 > f2.txt
DS.txt contains;
ALBD:xxxxx
FLN:yyyyyyy
WLG:ttttttt
chain.txt contain;
ECK: ECK: 331
ECK: ECK: 336
FED :FED :427
FIE :FIE: 212
FLN :FLN: 140
FLN :FLN :141
FMF: FMF: 183
FR1 :FR1: 303
FTT :FTT :423
GAT :GAT: 185
GEN :GEN: 396
GFY :GFY: 268
GIA :GIA: 228
GMD :GMD: 264
MIN: MIN: 158
MRO :MRO: 354
MY0 :MY0: 315
NCS :NCS: 390
OSC :ALBD: 377
OSC :ALBD :378
OSC: ALBD: 379
OSC ALBD 380
WLG :WLG :243
MAT: WLG :247
the result.txt has to look like this;
OSC :ALBD: 377
OSC :ALBD :378
OSC: ALBD: 379
FLN :FLN: 140
FLN :FLN :141
WLG :WLG :243
MAT: WLG :247
the script has to match the 1st column from DS.txt with the 2nd column of chain.txt and only those that matched, move all the corresponding 1st , 2nd and 3rd columns of chain.txt to a output file say result.txt
this is what i am trying to accomplish.
can anyone please help me ..
tx
pavi
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I am new to UNIX scripting and woiuld appreicate your help...
Input file contains only one (but long) record:
aaaaabbbbbcccccddddd.....
Desired file:
NEW RECORD #new record (hardcoded) added as first record - its length is irrelevant#
aaaaa
bbbbb
ccccc
ddddd
...
...
... (1 Reply)
Discussion started by: rsolap
1 Replies
2. UNIX for Advanced & Expert Users
I have i got a requirement like below.
I have input file which contains following fixed width records.
00000000000088500232007112007111
I need the full record and concatenated with ~ and characters from 1to 5 and concatenated with ~ and charactes from 10 to 15
The out put will be like... (1 Reply)
Discussion started by: ukatru
1 Replies
3. Shell Programming and Scripting
Hi ,
I have a requirement to split the record based on particular match using UNIX.
Case1:
Input Record :
10.44.48.63;"Personals/Dating;sports";1441
Output Records :
10.44.48.63;Personals/Dating;1441;Original
10.44.48.63;sports;1441;Dummy
Case2:
Input Record : ... (5 Replies)
Discussion started by: mksuneel
5 Replies
4. Shell Programming and Scripting
Hi,
I have a input file with the following entries:
1one
2two
3three
1four
2five
3six
1seven
1eight
1nine
2ten
The output should be
1one
2two
3three
1four
2five
3six (2 Replies)
Discussion started by: supchand
2 Replies
5. Shell Programming and Scripting
Hi,
I have a input file with the following entries:
1one
2two
3three
1four
2five
3six
1seven
1eight
1nine
2ten
2eleven
2twelve
1thirteen
2fourteen
The output should be: (5 Replies)
Discussion started by: supchand
5 Replies
6. Shell Programming and Scripting
Input file:
data100_content1 420 700
data101_content1 107 516
data101_content2 194 773
data101_content3 195 917
data104_content2 36 325
data105_content1 505 605
data106_content1 291 565 ... (7 Replies)
Discussion started by: perl_beginner
7 Replies
7. Shell Programming and Scripting
Hi! all
can any one tell me how to compare current record of column with next and previous record in awk without using array
my case is like this
input.txt
0 32
1 26
2 27
3 34
4 26
5 25
6 24
9 23
0 32
1 28
2 15
3 26
4 24 (7 Replies)
Discussion started by: Dona Clara
7 Replies
8. Shell Programming and Scripting
I have test.xml
<emp><id>101</id><name>AAA</name><date>06/06/14 1811</date></emp>
<Join><id>101</id><city>london</city><date>06/06/14 2011</date></join>
<Join><id>101</id><city>new york</city><date>06/06/14 1811</date></join>
<Join><id>101</id><city>sydney</city><date>06/06/14... (2 Replies)
Discussion started by: vsraju
2 Replies
9. UNIX for Dummies Questions & Answers
Hi All,
I have a requirement where I need to find sum of values from column D through O present in a CSV file and check whether the sum of each Individual column matches with the value present for that corresponding column present in the trailer record.
For example, let's assume for column D... (9 Replies)
Discussion started by: tpk
9 Replies
10. Shell Programming and Scripting
Hi,,
I have requirement that i need to get DISTINCT values from a table and if there are two records i need to update it to one record and then need to submit INSERT statements by using the updated value as a parameter. Here is the example follows..
SELECT DISTINCT ID FROM OFFER_GROUP WHERE... (1 Reply)
Discussion started by: Samah
1 Replies
LEARN ABOUT DEBIAN
osc-send
TRACEBACK(1) User Commands TRACEBACK(1)
NAME
Traceback - sends an OSC message
SYNOPSIS
osc-send [options] [url] osc-address [,typetags] [osc arguments]
DESCRIPTION
Traceback (most recent call last):
File "./scripts/osc-send", line 11, in <module>
import txosc # for __version__
ImportError: No module named txosc
File "./scripts/osc-send", line 11, in <module>
import txosc # for __version__
ImportError: No module named txosc
EXAMPLES
The following examples are equivalent:
osc-send osc.tcp://127.0.0.1:17779 /ham/spam ,sif egg 2 3.14159
osc-send --tcp --host=127.0.0.1 --port=17779 --type-tags=sif /ham/spam egg 2 3.14159
osc-send -T -P 17779 /ham/spam egg 2 3.14159
OSC MESSAGES
An OSC message consists of an OSC Address Pattern followed by an OSC Type Tag String followed by zero or more OSC Arguments.
OSC ADDRESSES
An OSC Address Pattern is a string beginning with the character '/' (forward slash). It is mandatory to provide one.
OSC TYPE TAGS
An OSC Type Tag String is a string (beginning with the character ',' (comma)) followed by a sequence of characters corresponding exactly to
the sequence of OSC Arguments in the given message. Each character after the comma is called an OSC Type Tag and represents the type of the
corresponding OSC Argument.
Here is the list of supported type tags:
i - 32bit integer
h - 64bit integer
f - 32bit floating point number
d - 64bit (double) floating point number
s - string
S - symbol
c - char
m - 4 byte midi packet (8 digits hexadecimal)
T - TRUE
F - FALSE
N - NIL
I - INFINITUM
VALUES
Values are space separated. Quoting strings might be handy.
The full Open Sound Control specification can be found at http://opensoundcontrol.org/specification
HISTORY
Written by Arjan Scherpenisse and Alexandre Quessy in 2010.
Traceback (most recent call last): October 2010 TRACEBACK(1)