06-27-2008
AWK script help required
Hello every one
i have a very long file 'file1' like this
HTML Code:
<K>1</K>
</Condition>
<Tariff>Rate
<Price>1.27</Price>
<Interval>30</Interval>
</Tariff>
</Node>
<Node>NonFaF
<Tariff>Rate
<Price>1.9</Price>
<Interval>30</Interval>
</Tariff>
</Node>
</Node>
</Node>
<Node>FaF
<Condition>FriendsAndFamily
<K>1</K>
</Condition>
<Tariff>Rate
<Price>1.27</Price>
<Interval>30</Interval>
</Tariff>
</Node>
<Node>NonFaF
<Tariff>Rate
<Price>1.9</Price>
<Interval>30</Interval>
</Tariff>
</Node>
</Node>
<Node>International
<Node>LCR
<Node>group0_LCR
<Condition>NumberList
<Type>0</Type>
and i have file2 which is like this
HTML Code:
1.27 1.56
3.45 4.25
1.90 2.10
Now i want script to traverse through file1 and stops whereever he finds '<Price>1.9</Price> ' , compare the numercial value (1.9 in this case ) with all values of column 1 of file2 and where he finds match, then replaces it with <Price>value in file2 of second column</Price>
I am also working on it and would appreciate your help a lot
Regards
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I have two questions:
(Q1) I am using a loop and want to print a particular field of a table using the AWK command by accessing one row at a time by validating NR with the loop counter. I am using a command like this but it isn't working!
count=1
NAWK -F"|" -v var=$count 'NR == var { printf... (13 Replies)
Discussion started by: udiptya
13 Replies
2. Shell Programming and Scripting
Hi,
I have a fixed with file, which have almost 10 records
Sample File:
------------
AR 100 TTT
BC 200 SSS
DA 199 YYY
AR 500 RRR
PO 300 QQQ
PB 800 PPP
PC 150 OOO
AR 111 CCC
AD 321 LLL
I Have to check for first two charactors and if its 'AR' i have to save those records to one... (3 Replies)
Discussion started by: meetavin
3 Replies
3. Shell Programming and Scripting
Hi,
I have a .txt file (uniqfields.txt) with 3 fields separated by " | " (pipe symbol). This file contains unique values with respect to all these 3 fields taken together. There are about 40,000 SORTED records (rows) in this file. Sample records are given below.
1TVAO|OVEPT|VO... (2 Replies)
Discussion started by: RRVARMA
2 Replies
4. Shell Programming and Scripting
Hi All,
I need to pick up data on both sides of "=" sign.
For eg, following is the context that I have.
125.156.125.147=machine1
147.125.185.156=machine2
147.125.185.159=machine3
Can I have the ip address in one variable and machine name in another variable using sed or awk.
... (1 Reply)
Discussion started by: nua7
1 Replies
5. Shell Programming and Scripting
Hi
I have a file, with format like:
column1|coulumn2|column3|column4
A|X|K|18
L|O|R|31,42,25
G|H|I|55,66
L|E|Q|25,31,94
output required:
column1|coulumn2|column3|column4
A|X|K|18
L|O|R|31,25
L|E|Q|25,31
Input File Format: All columns are seperated using |, last column... (8 Replies)
Discussion started by: New to awk
8 Replies
6. Shell Programming and Scripting
Hi All,
I have 2 .csv files as below
File1.csv
name1,20,30,date1
name2,30,40,date1
File2.csv
name1,25,35,date1
name2,45,55,date1
Can any one help me to add the 2nd and 3rd column of file1 and file2 and write the output into a new file as below
name1,45,65,date1... (9 Replies)
Discussion started by: ajay547
9 Replies
7. UNIX for Advanced & Expert Users
Hi Jim,
The following script is in working state. But i m having one more problem with awk cmd. Could you tell me how to use any variable inside awk or how to take any variable value outside awk.
My problem is i want to maintain one property file in which i am declaring variable value into that... (1 Reply)
Discussion started by: Ganesh Khandare
1 Replies
8. Shell Programming and Scripting
File 1
###################
TRAIU DSKDL; SLLA ;LAKJA
KJAJA NSAJAN JANAL AJKJA
JAJALA KAKAK JA AKA AKA AJ A A
PPIN TRY1 SANT1 PPIN TRY2 SANT2
PPIN TRY3 SANT3 PPIN TRY4 SANT4
PPIN TRY5 SANT5
AJJA NA ANA ANHDJLD ALJALJA
AJLJAJD LALJAL ALJALJA ALJALJA (4 Replies)
Discussion started by: jaita
4 Replies
9. Shell Programming and Scripting
HI friends,
I have two files.
File2 2nd column need to be compared with file1 3rd column.If ID match found, then save in different file as file1 data
followed by file2.
file1:
No;age;id;name
1;24;37h;name1
2;22;67e;name2
4;48;9r;name3
6;67;9i8;name4
file2:
exp;id;pos... (9 Replies)
Discussion started by: vasanth.vadalur
9 Replies
10. Shell Programming and Scripting
Hello, I am trying to get an output from awk and have been unsuccessful so far.
There is an input file which contains certain segments, that needs to be read and append with another data after matching the segment...
Input file is as shown below
ISA*00* *00* *01*781495650... (2 Replies)
Discussion started by: rakeshv
2 Replies
LEARN ABOUT OPENSOLARIS
igawk
IGAWK(1) Utility Commands IGAWK(1)
NAME
igawk - gawk with include files
SYNOPSIS
igawk [ all gawk options ] -f program-file [ -- ] file ...
igawk [ all gawk options ] [ -- ] program-text file ...
DESCRIPTION
Igawk is a simple shell script that adds the ability to have ``include files'' to gawk(1).
AWK programs for igawk are the same as for gawk, except that, in addition, you may have lines like
@include getopt.awk
in your program to include the file getopt.awk from either the current directory or one of the other directories in the search path.
OPTIONS
See gawk(1) for a full description of the AWK language and the options that gawk supports.
EXAMPLES
cat << EOF > test.awk
@include getopt.awk
BEGIN {
while (getopt(ARGC, ARGV, "am:q") != -1)
...
}
EOF
igawk -f test.awk
SEE ALSO
gawk(1)
Effective AWK Programming, Edition 1.0, published by the Free Software Foundation, 1995.
AUTHOR
Arnold Robbins (arnold@skeeve.com).
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+--------------------+-----------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+--------------------+-----------------+
|Availability | SUNWgawk |
+--------------------+-----------------+
|Interface Stability | Volatile |
+--------------------+-----------------+
NOTES
Source for gawk is available on http://opensolaris.org.
Free Software Foundation Nov 3 1999 IGAWK(1)