Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Help with awk logic

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Help with awk logic
# 1  
Old 05-21-2009
Help with awk logic
I want to print lines that have "IND" or "ind" or nothing in field 2 or 3

file:
Quote:
abc,IND,IND
def,AMC,ind
ghi,IND,AMC
jkl,,
mno,,IND
pqr,IND,,
stu,AMC,AMC
vwx,DEL,AMC
output needed:
Quote:
abc,IND,IND
def,AMC,ind
ghi,IND,AMC
jkl,,
mno,,IND
pqr,IND,,

Code i wrote:
Code:
nawk -F"," '{if(tolower($2||$3) ~"ind"||"")print}' file


Help is appreciated
# 2  
Old 05-21-2009
Here you go..

Code:
awk -F, -v IGNORECASE=1 '( ( $2 ~ /^(ind|)$/ ) || ( $3 ~ /^(ind|)$/ ) )' test.txt

Code:
-bash-3.00$ cat test.txt
abc,IND,IND
def,AMC,ind
ghi,IND,AMC
jkl,,
mno,,IND
pqr,IND,,
stu,AMC,AMC
vwx,DEL,AMC
-bash-3.00$ awk -F, -v IGNORECASE=1 '( ( $2 ~ /^(ind|)$/ ) || ( $3 ~ /^(ind|)$/ ) )' test.txt
abc,IND,IND
def,AMC,ind
ghi,IND,AMC
jkl,,
mno,,IND
pqr,IND,,

# 3  
Old 05-21-2009
'IGNORECASE' is GNUism.
Code:
nawk -F, '$2 == "" || $3 == "" || tolower($2) == "ind" || tolower($3) == "ind" ' myFile

Last edited by vgersh99; 05-21-2009 at 06:04 PM..
# 4  
Old 05-21-2009
Quote:
Originally Posted by vgersh99
'IGNORECASE' is GNUism.
Code:
nawk -F, '$2 == "" || $3 == "" || tolower($2) == "ind" || tolower($3) == "ind" ' myFile

Thanks vgersh99
Login or Register to Ask a Question

Previous Thread | Next Thread

8 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk logic

I am trying to check my logic on a long awk i'm using. I have about 30 checks that I built into an awk and I "believe" I did this right, but I could be wrong. awk -F\| ' $9 !~ /\/*{1,}*/ $9 ~ /\(-{4}, {2,3}/ $9 ~ /\({6}, {2,3}\)/ $9 ~ /\(\+{5}, {2,3}\)/ $9 ~ /\(\+\+{4}, {2,3}\)/ $9 ~... (8 Replies)
Discussion started by: dagamier
8 Replies

2. Shell Programming and Scripting

How to use this logic with awk?

Hi friends, I am having 2 files, I just want to compare 2 files each containing 2 columns 1st column is lat, and 2nd column is long, if anyone can understand below logic please help me in writing script with awk.. here each field of file2 needs to be compared with std_file main counter=0... (1 Reply)
Discussion started by: Akshay Hegde
1 Replies

3. UNIX for Dummies Questions & Answers

awk logic and math help

Hi, My file has 2 fields and millions of lines. variableStep chrom=Uextra span=25 201 0.5952 226 0.330693 251 0.121004 276 0.0736858 301 0.0646982 326 0.0736858 401 0.2952 426 0.230693 451 0.221004 476 0.2736858 Each field either has a... (6 Replies)
Discussion started by: wyarosh
6 Replies

4. UNIX for Dummies Questions & Answers

Need help in logic using awk command

I have task to find out the min,max, average value of each service for example i searched for " StatementService " $awk '/VST.*StatementService:/{print $3,$4,$19,$22,$25}' performance.log > smp.log $cat smp.log amexgtv VST: : StatementService:1860 StatementService:getCardReference:0... (3 Replies)
Discussion started by: senthil.ak
3 Replies

5. Shell Programming and Scripting

need an awk script/logic

In one data file i have values like this a b c 1 2 e f g 2 3 i j k 3 5 I need to sum up the last 2 columns and make a data file...How i can do that. a b c 1 2 e f g 2 3 i j k 3 5... (8 Replies)
Discussion started by: bobprabhu
8 Replies

6. Shell Programming and Scripting

need a logic to start with awk/ sh

Hi Friends, I got stuck where to start with .. I ve a input file like below. where I want to compare write data with my read data .. The problem is that the read data should be compared with the lastest write data on that address. Note- Both write data & read data are in the same... (8 Replies)
Discussion started by: user_prady
8 Replies

7. Shell Programming and Scripting

need a logic for awk programming

Hello Friends, I have a txt file like below //*Init Start Reg(read,12'h42E,16'h0000); Nop(5628.5); //*Init End //*Main Start Reg(read,12'h42E,16'h0000); Nop(5628.5); //*Main End I want to calculate the values between //* Init Start & //* Init End And //*Main Start & //*Main... (5 Replies)
Discussion started by: user_prady
5 Replies

8. Shell Programming and Scripting

cannot get logic for concatenation awk

Hello friends, I have a problem in printing an array.. Example if my array line contains 4 elements like following line=0002 , line=202200, line=200002, line= 300313 Now one = sprintf line line line line will concatenate my whole array to one. But I am not sure about the... (7 Replies)
Discussion started by: user_prady
7 Replies
Login or Register to Ask a Question