Need Regular expression


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Need Regular expression
# 1  
Old 08-17-2009
Need Regular expression

Hi,

I want to find the records using grep with following conditions.

one field position at 26 and having length 2 and values of 21,24,31,34 or
another field position at 28 and length 2 of values 21,224,31,34

I wrote it like below, But I want this search using grep, can any one provide?
Code:
awk 'substr($0,26,2)==21 || substr($0,26,2)==24 || substr($0,26,2)==31 || substr($0,26,2)==34 || substr($0,28,2)==21 ||substr($0,28,2)==24||substr($0,28,2)==31 ||substr($0,28,2)==24{print $0}' R3AP200811_GMSSMSTRLD_01358_20081119235959.traf_load

Regards,
Venkat

Last edited by Franklin52; 08-17-2009 at 07:08 AM.. Reason: Please use code tags!
# 2  
Old 08-17-2009
i'm not sure to understand why you say toy use grep, if i understandign you i think you need cut:
Code:
while read line 
do
var=`echo $line |cut -c26,27 `
var2=`echo $line|cut -c28,29 `

if [ $var -eq $NUMBER1 -o $ var2 -eq $NUMBER1 ..................................... ]
then
  ...............
else
  ...............
fi
done< file


Last edited by chipcmc; 08-17-2009 at 07:56 AM..
# 3  
Old 08-17-2009
Code:
grep -E '^.{25}(21|24|31|34)(21|24|31|34)' file

# 4  
Old 08-17-2009
Quote:
Originally Posted by danmero
Code:
grep -E '^.{25}(21|24|31|34)(21|24|31|34)' file

This way you ignore OR. With your code both fileds (26-27) AND (28-29) have to be true. If I understud it good, itīs enought that one condition is satisfied.

Code:
 
grep -E "^.{25}((21|24|31|34)..|..(21|24|31|34))" file


Last edited by necroman08; 08-17-2009 at 09:14 AM.. Reason: Adding quote
# 5  
Old 08-17-2009
Or, a shorter version that takes advantage of the cross product:

Code:
grep -E "^.{25}([23][14]..|..[23][14])" file

tyler_durden
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Regular expression

I would like to extract "JDBC Thin Client" from (PROGRAM=JDBC Thin Client); and "C:\Python26\python.exe" from (PROGRAM=C:\Python26\python.exe); "txm_v_awsrf_db.pr" from (PROGRAM=txm_v_awsrf_db.pr). if input line like "(PROGRAM=)", it return unknown. Would you help suggest a regular... (4 Replies)
Discussion started by: cstsang
4 Replies

2. Shell Programming and Scripting

Regular expression

Can someone please explain me what does this mean? ^{1,50}$ (1 Reply)
Discussion started by: Anupam_Halder
1 Replies

3. UNIX for Dummies Questions & Answers

Regular expression help

Hi, I am quite knew to scripting and I am trying to get a regular expression to work to check that a user enters a valid version number such as 1 or 1.1 or 12.3 etc. I dont seem to be able to get it to work as it picks up versions such as 1.......2. I only want it to work with a single dot.... (12 Replies)
Discussion started by: frodo61
12 Replies

4. UNIX for Advanced & Expert Users

sed: -e expression #1, char 0: no previous regular expression

Hello All, I'm trying to extract the lines between two consecutive elements of an array from a file. My array looks like: problem_arr=(PRS111 PRS213 PRS234) j=0 while } ] do k=`expr $j + 1` sed -n "/${problem_arr}/,/${problem_arr}/p" problemid.txt ---some operation goes... (11 Replies)
Discussion started by: InduInduIndu
11 Replies

5. Programming

Perl: How to read from a file, do regular expression and then replace the found regular expression

Hi all, How am I read a file, find the match regular expression and overwrite to the same files. open DESTINATION_FILE, "<tmptravl.dat" or die "tmptravl.dat"; open NEW_DESTINATION_FILE, ">new_tmptravl.dat" or die "new_tmptravl.dat"; while (<DESTINATION_FILE>) { # print... (1 Reply)
Discussion started by: jessy83
1 Replies

6. Shell Programming and Scripting

Integer expression expected: with regular expression

CA_RELEASE has a value of 6. I need to check if that this is a numeric value. if not error. source $CA_VERSION_DATA if * ] then echo "CA_RELESE $CA_RELEASE is invalid" exit -1 fi + source /etc/ncgl/ca_version_data ++ CA_PRODUCT_ID=samxts ++ CA_RELEASE=6 ++ CA_WEEK_NO=7 ++... (3 Replies)
Discussion started by: ketkee1985
3 Replies

7. UNIX for Dummies Questions & Answers

ls with regular expression

I currently list and sort all the files in a directory which begin with an Upper Case C and end with the extension '#finished#'. Here is the command I use: ls -tr $currentDir/*.#finished# what i need to do now is list all the files in a directory that begin with upper case C and end... (3 Replies)
Discussion started by: rkgudde
3 Replies

8. Linux

Regular expression to extract "y" from "abc/x.y.z" .... i need regular expression

Regular expression to extract "y" from "abc/x.y.z" (2 Replies)
Discussion started by: rag84dec
2 Replies

9. Programming

What does the regular expression ['(^[^~]+~).*'] mean?

What does the regular expression +~).*'] mean while using it with regexec.When the string "RCHNUSNT35C~rs07/ASM-RS07" is used with the regular expression +~).*'] regexec gives an error. I know what regexec does,but i do not understand what this expression means wrt to this string... any help... (2 Replies)
Discussion started by: anupamar
2 Replies

10. Shell Programming and Scripting

Regular Expression + Aritmetical Expression

Is it possible to combine a regular expression with a aritmetical expression? For example, taking a 8-numbers caracter sequece and casting each output of a grep, comparing to a constant. THX! (2 Replies)
Discussion started by: Z0mby
2 Replies
Login or Register to Ask a Question