Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

grep between

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting grep between
# 1  
Old 10-08-2012
grep between
Hello,
Could you please help me with that:
I have file with rows like:
Code:
AAAAA_ABCDE_20120918_120043_ABC_00.XXX
BBBB_KLMNR_20120919_140043_AB_00.XXX
CCC_ABCD_20120920_160043_ABCD_00.XXX
DD_ABC_20120921_180043_AFH_00.XXX

And I want to grep all between 20120919 and 20120920 and two have output like:
Code:
BBBB_KLMNR_20120919_140043_AB_00.XXX
CCC_ABCD_20120920_160043_ABCD_00.XXX

Thanks!
# 2  
Old 10-08-2012
if there is only one entry of the dates..

try this..

Code:
sed -n '/20120919/,/20120920/p' file

This User Gave Thanks to pamu For This Post:
apenkov
# 3  
Old 10-08-2012
Code:
awk -F_ '$3>=20120919 && $3<=20120920' file

This User Gave Thanks to elixir_sinari For This Post:
apenkov
# 4  
Old 10-09-2012
Thanks a lot!
Apparently additional strings appeared in the file like:
Code:
AAAA_
BBBB_

then
Code:
sed -n '/20120919/,/20120920/p' file

will get them also, but I don't need...
And strings like:
Code:
AAAAA_ABCDE.20120918_120043_ABC_00.XXX
BBBB_KLMNR.20120919_140043_AB_00.XXX

then I can not use
Code:
awk -F_ '$3>=20120919 && $3<=20120920' file

Let's assume that there can be strings without date, which I don't need and the length and the content before the date is uknown. Any ideas if there is a way to handle this?

Thanks!
# 5  
Old 10-09-2012
try some thing like this..

Code:
sed -n '/20120919/,/20120920/p' file | sed -n '/201[0-9]*/p'

You can modify above highlighted one as per your criteria.Smilie
This User Gave Thanks to pamu For This Post:
apenkov
# 6  
Old 10-09-2012
Thanks pamu, it is working fine!
# 7  
Old 10-09-2012
awk is also working fine,
Code:
awk -F"_" '{if($3>=20120919 && $3<=20120920) print $0}' filename

Last edited by Franklin52; 10-09-2012 at 07:06 AM.. Reason: Please use code tags for data and code samples
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Inconsistent `ps -eaf -o args | grep -i sfs_pcard_load_file.ksh | grep -v grep | wc -l`

i have this line of code that looks for the same file if it is currently running and returns the count. `ps -eaf -o args | grep -i sfs_pcard_load_file.ksh | grep -v grep | wc -l` basically it is assigned to a variable ISRUNNING=`ps -eaf -o args | grep -i sfs_pcard_load_file.ksh |... (6 Replies)
Discussion started by: wtolentino
6 Replies

2. UNIX for Dummies Questions & Answers

Piping grep into awk, read the next line using grep

Hi, I have a number of files containing the information below. """"" Fundallinfo 6.3950 14.9715 14.0482 """"" I would like to grep for Fundallinfo and use it to read the next line? I ideally would like to read the three numbers that follow in the next line and... (2 Replies)
Discussion started by: Paul Moghadam
2 Replies

3. UNIX for Dummies Questions & Answers

Bash - CLI - grep - Passing result to grep through pipe

Hello. I want to get all modules which are loaded and which name are exactly 2 characters long and not more than 2 characters and begin with "nv" lsmod | (e)grep '^nv???????????? I want to get all modules which are loaded and which name begin with "nv" and are 2 to 7 characters long ... (1 Reply)
Discussion started by: jcdole
1 Replies

4. Shell Programming and Scripting

AWK/GREP: grep only lines starting with integer

I have an input file 12.4 1.72849432773174e+01 -7.74784188610632e+01 12.5 9.59432114416327e-01 -7.87018212757537e+01 15.6 5.20139995965960e-01 -5.61612429666624e+01 29.3 3.76696387248366e+00 -7.42896194101892e+01 32.1 1.86899877018077e+01 -7.56508762501408e+01 35 6.98857157014640e+00... (2 Replies)
Discussion started by: chrisjorg
2 Replies

5. UNIX for Dummies Questions & Answers

Advanced grep'in... grep for data next to static element.

I have a directory I need to grep which consists of numbered sub directories. The sub directory names change daily. A file resides in this main directory that shows which sub directories are FULL backups or INCREMENTAL backups. My goal is to grep the directory for the word "full" and then... (2 Replies)
Discussion started by: SysAdm2
2 Replies

6. UNIX for Dummies Questions & Answers

Difference between grep, egrep & grep -i

Hi All, Please i need to know the difference between grep, egrep & grep -i when used to serach through a file. My platform is SunOS 5.9 & i'm using the korn shell. Regards, - divroro12 - (2 Replies)
Discussion started by: divroro12
2 Replies

7. Shell Programming and Scripting

grep for certain files using a file as input to grep and then move

Hi All, I need to grep few files which has words like the below in the file name , which i want to put it in a file and and grep for the files which contain these names and move it to a new directory , full file name -C20091210.1000-20091210.1100_SMGBSC3:1000... (2 Replies)
Discussion started by: anita07
2 Replies

8. UNIX for Dummies Questions & Answers

| help | unix | grep (GNU grep) 2.5.1 | advanced regex syntax

Hello, I'm working on unix with grep (GNU grep) 2.5.1. I'm going through some of the newer regex syntax using Regular Expression Reference - Advanced Syntax a guide. ls -aLl /bin | grep "\(x\)" Which works, just highlights 'x' where ever, when ever. I'm trying to to get (?:) to work but... (4 Replies)
Discussion started by: MykC
4 Replies

9. UNIX for Dummies Questions & Answers

| help | unix | grep - Can I use grep to return a string with exactly n matches?

Hello, I looking to use grep to return a string with exactly n matches. I'm building off this: ls -aLl /bin | grep '^.\{9\}x' | tr -s ' ' -rwxr-xr-x 1 root root 632816 Nov 25 2008 vi -rwxr-xr-x 1 root root 632816 Nov 25 2008 view -rwxr-xr-x 1 root root 16008 May 25 2008... (7 Replies)
Discussion started by: MykC
7 Replies

10. Shell Programming and Scripting

MEM=`ps v $PPID| grep -i db2 | grep -v grep| awk '{ if ( $7 ~ " " ) { print 0 } else

Hi Guys, I need to set the value of $7 to zero in case $7 is NULL. I've tried the below command but doesn't work. Any ideas. thanks guys. MEM=`ps v $PPID| grep -i db2 | grep -v grep| awk '{ if ( $7 ~ " " ) { print 0 } else { print $7}}' ` Harby. (4 Replies)
Discussion started by: hariza
4 Replies
Login or Register to Ask a Question