[SOLVED] Regex find first 5-7 occurrences of a set of digits within a string

chrism01 · 03-07-2013, 07:12 PM

Just for fun here's a Perl approach for OP and Daniel's qns

Code:

#!/usr/bin/perl -w
use strict;


my ($tmp, @arr );
@arr=('this is9the way44the world123456ends35 ',
    'not 54321 with a444444bang 42 but a9whimper',
    q{<a onclick="doShowCHys=1;ShowWindowN(0,'/daman/man.php?asv4=145148&amp;playTogether=True',960,540,943437);return false;" title="">} );
for $tmp ( @arr)
{
#   print "tmp $tmp\n";
    $tmp =~ s/([0-9]{5,7})/$1/ ;
    print $1."\n";
}

o/p

Code:

 ./t.pl
123456
54321
145148

danielbmartin · 03-07-2013, 08:48 PM

Perhaps the file OP processes always has this format...

Code:

<a onclick="doShowCHys=1;ShowWindowN(0,'/daman/man.php?asv4=145148&amp;playTogether=True',960,540,943437);return false;" title="">
<a onclick="doShowCHys=1;ShowWindowN(0,'/daman/man.php?asv4=1451486&amp;playTogether=True',960,540,94343);return false;" title="">
<a onclick="doShowCHys=1;ShowWindowN(0,'/daman/man.php?asv4=1451489&amp;playTogether=True',960,540,94343);return false;" title="">
<a onclick="doShowCHys=1;ShowWindowN(0,'/daman/man.php?asv4=45148&amp;playTogether=True',960,540,94343);return false;" title="">

In that case, extracting the numeric string which follows asv4= is a simple task.

Code:

cut -d"=" -f4 $InFile |cut -d"&" -f1 >$OutFile

Daniel B. Martin

ntubski · 03-07-2013, 10:02 PM

Quote:

Originally Posted by danielbmartin

I interpret the problem statement this way:
Extract the first numeric string in each line which is of length 5, 6, or 7.
(No reliance on an equals sign.)

Code:

gawk 'match($0, /[0-9]{5,7}/) { print(substr($0, RSTART, RLENGTH)) }' $InFile

Note: requires gawk version 4+ for the {n,m} regex operator.

grail · 03-08-2013, 04:38 AM

Quote:

Note: requires gawk version 4+ for the {n,m} regex operator

Earlier versions can use --re-interval

@ Daniel - Not sure that the generic solution you are after is possible with grep as unlike something like sed you cannot tell grep to stop after the first match (that I know of)

whizje · 03-08-2013, 01:32 PM

Code:

bash-4.2$ grep -Eo "[0-9]{5,7}.*" test|grep -Eo "^[0-9]{5,7}"
145148
1451486
1451489
45148

Code:

bash-4.2$ echo "this is9the way44the world123456ends35 
not 54321 with a444444bang 42 but a9whimper"|grep -Eo "[0-9]{5,7}.*"|grep -Eo "^[0-9]{5,7}"
123456
54321

grail · 03-08-2013, 10:01 PM

hmmm... that works but I was taking the idea that it was to be a single grep command, ie a single sed could do it easily