Re: using AWK to compare fileds


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Re: using AWK to compare fileds
# 1  
Old 09-13-2012
Re: using AWK to compare fileds

I have following text:

Code:
NAME=ora.LISTENER.lsnr
TYPE=ora.listener.type
TARGET=ONLINE            , ONLINE            , ONLINE            , ONLINE
STATE=ONLINE on host1, ONLINE on host2, ONLINE on host3, ONLINE on host4

NAME=ora.LISTENER_1525.lsnr
TYPE=ora.listener.type
TARGET=ONLINE            , ONLINE            , ONLINE            , ONLINE
STATE=ONLINE on host1, ONLINE on host2, ONLINE on host3, ONLINE on host4

NAME=ora.LISTENER_1529.lsnr
TYPE=ora.listener.type
TARGET=ONLINE            , ONLINE            , ONLINE            , ONLINE
STATE=ONLINE on host1, ONLINE on host2, ONLINE on host3, ONLINE on host4

i have a variable "hst_name"

lets say hst_name=host2

now i need to print the NAME if TARGET value is not equal to STATE value of that particular host.

Can some one help me here.
# 2  
Old 09-13-2012
I guess you have posted similar post https://www.unix.com/shell-programmin...using-awk.html
you can give it a try this time around...

Last edited by vidyadhar85; 09-13-2012 at 11:56 AM..
# 3  
Old 09-13-2012
I have been working on it for last two days...

Code:
STATE=ONLINE on host1, ONLINE on host2, ONLINE on host3, ONLINE on host4

how to cut the filed based on varaible using awk.

Code:
awk -F = '/^STATE/ {t = $2; print t;}' sample.txt

ONLINE on host1, ONLINE on host2, ONLINE on host3, ONLINE on host4
ONLINE on host1, ONLINE on host2, ONLINE on host3, ONLINE on host4
ONLINE on host1, ONLINE on host2, ONLINE on host3, ONLINE on host4
ONLINE on host1, ONLINE on host2, ONLINE on host3, ONLINE on host4
ONLINE on host1, ONLINE on host2, ONLINE on host3, ONLINE on host4

How to cut the status i.e ONLINE here based on variable i.e host1 or host2 or host3 or host 4
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Replace the perticular fileds in passwd file

Hi I have 2 different password entries in 2 different files for the same user. file 1 - siva:correct:1000:23:siva:/home/siva:/bin/bash file 2 - siva:incorrect:1000:23:siva:/home/siva:/bin/bash file 1 is having correct passwd entry where as file 2 is wrong. Now, i want to compare... (3 Replies)
Discussion started by: kumar85shiv
3 Replies

2. Shell Programming and Scripting

awk to store in a list the values of certain fileds

Dear Group, I have following input: sa;sb;sc;sd;period;ma;mb;mc;md;me sa1;sb1;sc1;sd1;200001;ma1;mb1;mc1;md1;me1 sa2;sb2;sc2;sd2;200002;ma2;mb2;mc2;md2;me2 sa3;sb3;sc3;sd3;200003;ma3;mb3;mc3;md3;me3 first line contains the headers! I want to create with one pass the following output:... (8 Replies)
Discussion started by: suturjik
8 Replies

3. Shell Programming and Scripting

Add two more fileds to awk command

This is what I was trying but failed to do so need help. cat 1.sql | awk '{printf("%s",NR%4 ? $0",":$0"\n")}' Output :- I want to add 2 more values for each line (hostname,user name) so the output should have hostname & username (testsrv01,test1) Output should be like... (4 Replies)
Discussion started by: lazydev
4 Replies

4. Shell Programming and Scripting

How to selectively NOT output some fileds?

Dear All I have a text file which has many columns (>10,000). I want to create a new text file which will NOT include following columns: 5,15,105,200. How can I do that in shell (or awk, perl)? Thanks. (6 Replies)
Discussion started by: littlewenwen
6 Replies

5. Shell Programming and Scripting

awk command to compare a file with set of files in a directory using 'awk'

Hi, I have a situation to compare one file, say file1.txt with a set of files in directory.The directory contains more than 100 files. To be more precise, the requirement is to compare the first field of file1.txt with the first field in all the files in the directory.The files in the... (10 Replies)
Discussion started by: anandek
10 Replies

6. Shell Programming and Scripting

AWK help. how to compare a variable with a data array in AWK?

Hi all, i have a data array as follows. array=ertfgj2345 array=456ttygkd . . . array=errdjt3235 so number or elements in the array can varies depending on how big the data input is. now i have a variable, and it is $1 (there are $2, $3 and so on, i am only interested in $1). ... (9 Replies)
Discussion started by: usustarr
9 Replies

7. Shell Programming and Scripting

A script that read specific fileds from the 7th line in a file

Dear All, I need a unix script that will read the 7th line and especially these fileds from a file Mo speed 16, Mt speed 15 every 15 minutes starting from 00:00 to 23:45 on daily basis and put the result in a txt file and name it MT_MO_20090225.txt, please also note that the system date format... (2 Replies)
Discussion started by: samura
2 Replies

8. Shell Programming and Scripting

print the fileds of a file

Hi Friends, Please help me in finding the solution for this : I have a file as below : CuDv: name = "hdisk0" status = 1 chgstatus = 2 ddins = "scsidisk" location = "" parent = "vscsi0" connwhere = "830000000000" PdDvLn... (3 Replies)
Discussion started by: vijaya2006
3 Replies

9. UNIX for Advanced & Expert Users

Mandatory fileds in Bugzilla

Hi, We need to configure some of the fileds in bugzilla like Platform,OS, Version etc are mandatory. Is it possible to set, if yes then how to configure. Thanks & Regards, Bache (0 Replies)
Discussion started by: bache_gowda
0 Replies

10. Shell Programming and Scripting

Merging fileds from 2 files

I have 2 files - fileA and fileB I need to match the first field of the 2 files then output some of the fields from fileA on the same line as certain fields from fileB. There will be instances where fileB does not have a match for first field in fileA Thanks in advance (8 Replies)
Discussion started by: Mudshark
8 Replies
Login or Register to Ask a Question