Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

awk conditional statement issue

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting awk conditional statement issue
# 1  
Old 12-27-2010
awk conditional statement issue
I have a file like this

Quote:
1133880712010-11-24 8340743 248130911
1133880712010-11-23 8340743 248130913
1133880712010-11-09 8340743 248130910
1133880712010-11-01 8340743 248130912
2183842512010-11-25 15379043 453130325
2183842512010-11-11 15379043 453130324
2183842512010-11-09 15379043 453130323
2281567512010-11-11 4837827 473838369
2281567512010-11-11 4837827 473838367
2281567512010-11-10 4837827 473838371
i want to filter out records whose date is greater than '2010-11-20'.
I have written this code like this...
Code:
cat /etl/ruby/purge/output/PurgeCLC15.DSINT.sort_inptnt_otptnt_prequalify.ruby.dat | awk '{ substr($0,12,10) == '2010-11-20' print substr($0,12,10) }'

but no output at all.... parsing error i'm getting
can anyone pls provide inputs to this..
# 2  
Old 12-27-2010
For those entries before 2010-11-20
Code:
grep -v '2010-1[1-2]-[2-3][0-9]' /etl/ruby/purge/output/PurgeCLC15.DSINT.sort_inptnt_otptnt_prequalify.ruby.dat

To display entries after 2010-11-20 inclusive
Code:
grep  '2010-1[1-2]-[2-3][0-9]' /etl/ruby/purge/output/PurgeCLC15.DSINT.sort_inptnt_otptnt_prequalify.ruby.dat

# 3  
Old 12-27-2010
Thanks for your reply.. it's wrkng fine..

Any solution using "awk" command ? please let me know if u are aware.
# 4  
Old 12-27-2010
Code:
awk '{if(substr($1,10) > "2010-11-20") print}' /etl/ruby/purge/output/PurgeCLC15.DSINT.sort_inptnt_otptnt_prequalify.ruby.dat

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Conditional statement in SFTP

Hi, I wanted to know if we can use conditional statements like if--else--fi inside an automated SFTP script session. (1 Reply)
Discussion started by: jhilmil
1 Replies

2. Shell Programming and Scripting

conditional statement in awk

Hi all, I have a file containing the values that would be use as the basis for printing the lines of another set of files using awk. What I want to do is something like the one below: stdev.txt 0.21 0.42 0.32 0.25 0.15 file1.txt file2.txt file3.txt ..filen.txt 0.45 0.23 ... (4 Replies)
Discussion started by: ida1215
4 Replies

3. UNIX for Advanced & Expert Users

conditional statement

I need to implement something like this. 1) search for a file(say *.doc) from a path (say /home/user/temp) 2) if file found & if file size > 0 : yes --> file valid else : print file not valid. I am trying to implement something like this, but seems i am terribly wrong somewhere.. ... (1 Reply)
Discussion started by: animesharma
1 Replies

4. Shell Programming and Scripting

Conditional Shell Statement

I want to add a conditional statement to a user's .profile file. I have a certain number of users that log in and use the rksh (Restricted Korn Shell). When they log in, it starts a certain program and when they exit this program, the system logs them out. When they are in this program, they can... (2 Replies)
Discussion started by: rjulich
2 Replies

5. Shell Programming and Scripting

if statement with grep as conditional

Please see the script segment below for i in $files do echo $i if ; then case "$1" in "IE0263"|"IE0264"|"IE0267"|"IE0268") short_filename=`ls -l $i | cut -c108-136 | sort` ;; "IE0272"|"IE0273") short_filename=`ls -l $i | cut... (4 Replies)
Discussion started by: jmahal
4 Replies

6. UNIX for Dummies Questions & Answers

Conditional statement in bash

I want to combine 2 conditional statements by using -o in bash, but it won't work. if ; then echo "The number needs to be between 0 and $nr" fi Each time i execute the file it says: ./selectCitaat: line 10: syntax error near unexpected token `$1' (3 Replies)
Discussion started by: doc.arne
3 Replies

7. Shell Programming and Scripting

if conditional statement

Hi, I have a script like this: sample.sh mapping=$1 if then echo "program passed" fi I'm running the above script as ./sample.sh pass The script is not getting executed and says "integer expression expected" Could anyone kindly help me? (2 Replies)
Discussion started by: badrimohanty
2 Replies

8. Shell Programming and Scripting

conditional statement

Hi all, The following code is to find if a list of numbers from one file are within the range in another file. awk -F, '\ BEGIN { while ((getline < "file2") > 0) file2=$3 } {for (col1 in file2) if ($0>=30 && $1<=45) print $0} ' FILE1 But where I have the number 30 and 45, I... (3 Replies)
Discussion started by: dr_sabz
3 Replies

9. Shell Programming and Scripting

conditional statement

Hi Does Unix have a conditional statement like Java as follows: Condition ? Statement1 : Statement2 Thanks (8 Replies)
Discussion started by: lalelle
8 Replies

10. Shell Programming and Scripting

awk conditional statement

how can i use awk or sed to do a conditional statement, so that HH:MM if MM not great than 30 , then MM=00 else MM=30 ie: 10:34 will display 10:30 10:29 will display 10:00 a=$(echo 10:34 | awk ......) Thanks in advance (10 Replies)
Discussion started by: 3Gmobile
10 Replies
Login or Register to Ask a Question