Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Comparing strings using nawk

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Comparing strings using nawk
# 1  
Old 06-25-2009
Comparing strings using nawk
Hello All
Please I have got a file called DATE.tex which consist of

01-04-2008_12:00:00
01-04-2005_12:00:00
01-04-2003_12:00:00
01-04-2007_12:00:00
01-04-2002_12:00:00
01-04-2009_12:00:00

I want to use nawk to print out the dates >=01-04-2009_12:00:00
I tried this

cat plnt.new | nawk '{if($1>="01-04-2009_12:00:00"){print}}'

But it seems not doing the job. I want to use nawk to do this filtering.
Can any one help?
# 2  
Old 06-25-2009
code:-


Code:
sed 's/_/-/'  input.txt  | nawk -F"-" '($1 >= '01') && ( $2 >= '04') && ( $3 >= '2009')'

# 3  
Old 06-25-2009
Quote:
Originally Posted by ahmad.diab
code:-


Code:
sed 's/_/-/'  input.txt  | nawk -F"-" '($1 >= '01') && ( $2 >= '04') && ( $3 >= '2009')'

There is a small problem here. if date is 01 March 2010 then
$2 >='04 will fail.

I suggest using datecalc, written by one of administrators.
# 4  
Old 06-25-2009
Code:
kindly see input file!!!

there is no month written in word ..only digits.


Input....
01-04-2008_12:00:00
01-04-2005_12:00:00
01-04-2003_12:00:00
01-04-2007_12:00:00
01-04-2002_12:00:00
01-04-2009_12:00:00

# 5  
Old 06-25-2009
convert date/time to YYYYMMDDhhmmss format and do the numeric comparison.
# 6  
Old 06-25-2009
Quote:
Originally Posted by ahmad.diab
Code:
kindly see input file!!!

there is no month written in word ..only digits.


Input....
01-04-2008_12:00:00
01-04-2005_12:00:00
01-04-2003_12:00:00
01-04-2007_12:00:00
01-04-2002_12:00:00
01-04-2009_12:00:00

For clarity I chose Mar
I meant 03>04 wil fail. Smilie
# 7  
Old 06-25-2009
Quote:
Originally Posted by rakeshawasthi
For clarity I chose Mar
I meant 03>04 wil fail. Smilie


Code:
NO IT WILL NOT Fail I had Tried IT.


uname -a

SunOS server8 5.10 Generic_118833-36 sun4u sparc SUNW,Sun-Blade-100

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Comparing Strings in ksh88

Hi I tried the following string comparison script in Ksh88 #!/bin/ksh str1='aC' str2='ABC' if then echo "Equal" else echo "Not Equal" fi Though str1 and str2 are not equal the script output says Equal . Please correct me Thanks (2 Replies)
Discussion started by: smile689
2 Replies

2. Shell Programming and Scripting

comparing strings as ints

Hi, So I got his code below. $year is a string of 2010,2011 etc. I guess I want to convert $year to an integer so I can do my if statement to see if the year string is greater than 2010? Or how could I do this? Right now I get a syntax error doing this. if; then do stuff fi (2 Replies)
Discussion started by: vsekvsek
2 Replies

3. Shell Programming and Scripting

Comparing strings with sed

Input: The the the the Output: not-same same What would be the sed command to do this? (7 Replies)
Discussion started by: cola
7 Replies

4. Shell Programming and Scripting

comparing awk and nawk

Hi Guys, i tried these two commands. First in awk and nawk. The nawk command is running fine but the awk command is throwing error. What is wrong with the awk command. There are lot of awk commands running fine in my system d003:/usr/local/dsadm/dsprod>nawk 'NR = 1 {print " "$0}' a.txt ... (6 Replies)
Discussion started by: mac4rfree
6 Replies

5. Shell Programming and Scripting

comparing two strings

hi All i am facing prob in comparing two strings that have two word. below is the code snippet. checkValidates="file validates" file3_name="file" if then echo "file" $file3_name "is validated successfully" fi when i run this i get the error as -bash: [: too many arguments ... (1 Reply)
Discussion started by: infyanurag
1 Replies

6. Shell Programming and Scripting

comparing 2 strings

hi i have 2 strings. i want to compare the strings. please help (2 Replies)
Discussion started by: satish@123
2 Replies

7. Shell Programming and Scripting

comparing strings

i have a string in a file which gets repeated number of times like below: rpttxt("abc") . . rpttxt("REP_TITLE") rpttxt("BOS_TITLE") . . . . and so on using awk or grep how can i comapre the string( as the second half keeps varying) and store it in a temporary variable? I am using the... (3 Replies)
Discussion started by: agarwal
3 Replies

8. Shell Programming and Scripting

Comparing Two Strings

Hi All, While I am trying to run below code I Am getting the exception like ./abs.sh: line 102: syntax error near unexpected token `then' ./abs.sh: line 102: ` then' The Code Snippet is: if then cat $file1 | sed -e... (8 Replies)
Discussion started by: Anji
8 Replies

9. UNIX for Advanced & Expert Users

Comparing strings

I have two strings a=Mar22 b=may21 how can I compare them Is this fine if then; . ... else .... fi or if then (2 Replies)
Discussion started by: yakyaj
2 Replies

10. Shell Programming and Scripting

comparing two strings

Hi How do i compare two strings in shell script. Below is an example but I am not getting the desired output, plz help if then echo success fi I am not getting the desired output if I do this. plz help (24 Replies)
Discussion started by: ragha81
24 Replies
Login or Register to Ask a Question