awk: string followed by tab comparision


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting awk: string followed by tab comparision
# 1  
Old 01-30-2012
awk: string followed by tab comparision

Hi all,
Currently i am using

Code:
if( $0~/ NOT / && $0~/ NULL /)
{
  .................            
}

to check if the input record contains "NOT" and "NULL". But in some cases "NOT" and "NULL" are preceded and followed by tab. How do i find compare for these fields as well?
# 2  
Old 01-30-2012
Just remove the space...
Code:
if(/NOT/ && /NULL/)
{
...
}

You can also avoid "$0~" since by default it will check again $0.

--ahamed
# 3  
Old 01-30-2012
Try this. This will handle any whitespace (space or tab) before and after NOT and NULL
Code:
echo -e "abc\tNOT\tNULL\txyz" |  awk '/[ \t]NOT[ \t]/&&/[ \t]NULL[ \t]/{print "found"}'


Last edited by chihung; 01-30-2012 at 08:30 PM..
# 4  
Old 01-31-2012
Code:
 
awk '/NOT.*NULL/' input.txt

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk - Print whole string ending with a Tab if key matched

Hi , I am looking to print the whole string from file2.txt but it is only printing 77 but not the whole matched string from File2.txt Any help is appreciated. Thanks, Script awk ' BEGIN { OFS="\t" out = "a.txt"} NR==FNR && NF {a=$0; next} function print_65_11() { if... (11 Replies)
Discussion started by: High-T
11 Replies

2. Shell Programming and Scripting

String Comparision

I want to compare two strings using awk dynamically without trimming the spaces and want to find the count of matching string. Input Strings file: File1 content (file1): " a " " a2 " File2 content (file2): " a " " a " " a2 " " b2 " " c2 "... (3 Replies)
Discussion started by: AhmedLakadkutta
3 Replies

3. Shell Programming and Scripting

String comparision

I have a string like ab or abc of whatever length. But i want to know whether another string ( for example, abcfghijkl, OR a<space> bcfghijkl ab<space> cfghijkl OR a<space>bcfghijkl OR ab<space> c<space> fghijkl ) starts with ab or abc... space might existing on the longer string... If so, i... (1 Reply)
Discussion started by: nram_krishna@ya
1 Replies

4. Shell Programming and Scripting

String comparision not working

have written a simple shell script to do some automation work. Basically the script searches for all the files in the current path and if the file is a specified one, it does some action. Below are the relevant lines --- #!/bin/bash 1.for i in ls * 2.do 3.if 4.then .... //do something... (3 Replies)
Discussion started by: Dev_Sharma987
3 Replies

5. Shell Programming and Scripting

Date - String comparision

Hi, I am having difficulty to compare a string in a file against a date from a a table and print the latest date. Below are the values. String in File : 2009-12-02 00:37:51 Value Table : 2010-01-10-02.00.49.294758 I have to compare both the values ( Ignore the Microsecond in the table... (5 Replies)
Discussion started by: sam_78_nyc
5 Replies

6. Shell Programming and Scripting

reg String comparision

Hi, I would like to compare the 25th position of the file with the character '(' and if it is not equal then it would generate a mail. I have used the below if condition, however it is always executing the code within if, even the comparison is expected to return false. if Please help me... (1 Reply)
Discussion started by: kdheepan
1 Replies

7. UNIX for Dummies Questions & Answers

Trim String in 3rd Column in Tab Delimited File...SED/PERL/AWK?

Hey Everybody, I am having much trouble figuring this out, as I am not really a programmer..:mad: Datafile.txt Column0 Column1 Column2 ABC DEF xxxGHI I am running using WGET on a cronjob to grab a datafile, but I need to cut the first three characters from... (6 Replies)
Discussion started by: rickdini
6 Replies

8. Shell Programming and Scripting

comparision of string in various files

i want to take position 19-24(only first line) from all files and need to compare any duplication is there or not. If duplication, then i have to print the file names. I have written to take the characters from 19-24 from all files. but how to compare ? ... (1 Reply)
Discussion started by: senthil_is
1 Replies

9. UNIX for Dummies Questions & Answers

problem in string comparision

Hi All, I've to compare the number of records present in a file against its trailer count. for ex: rec_cnt=$(awk 'END{print NR}' file.txt) trl_cnt=$(tail -1 file.txt| cut -c1-6) problem is trailer is appended with zero's and while comparing it is giving problem. i.e, rec_cnt=9 and... (1 Reply)
Discussion started by: ganapati
1 Replies

10. Shell Programming and Scripting

String comparision in shell scripting

Hi Guys, I am new to scripting I have written a code to compare strings,but I am getting some Exception Code snippet: MODE="D" if ]; then . $file1 fi Error: ./BatchJobs.sh: [[: execute permission denied I have given all Execute permissions to the script(chmod 755... (2 Replies)
Discussion started by: Anji
2 Replies
Login or Register to Ask a Question