grep or awk problem, unable to extract numbers

baghera · #1 (**permalink**) 08-30-2007

Hi, I've trouble getting some numbers from a html-file. The thing is that I have several html-logs that contains lines like this:

nerdnerd, how_old_r_u:45782<br>APPLY: <hour_second> Verification succeded

This is some of what I've extracted from a html file but all I really want is the number in the middle. When using awk I get:

how_old_r_u:45782<br>APPLY:

since there is a space at each end, like a separator for awk.

And I tried using grep "[0-9]" but it only takes the whole line containing the number so I get the whole line again. Is there any command that can retreive the numbers only?

vino · #2 (**permalink**) 08-30-2007

The pattern is not very clear. But you can try

Code:

grep -oE "[[:digit:]]{1,}" input.txt

If that does not satisfy your requirement, perhaps this.

Code:

sed -n -e "s/.*:\([0-9]*\).*/\1/p" input.txt

baghera · #3 (**permalink**) 08-31-2007

Quote:

Originally Posted by vino

The pattern is not very clear. But you can try

Code:

grep -oE "[[:digit:]]{1,}" input.txt

If that does not satisfy your requirement, perhaps this.

Code:

sed -n -e "s/.*:\([0-9]*\).*/\1/p" input.txt

But if there is more numbers on that line for example:

how_old_r_u:45782<br>APPLY:[30000,t3,t4]:Plummet

It seems when I run the command

Code:

grep -oE "[[:digit:]]{1,}" input.txt

I also get the other numbers is there some way to get only 45782?

fazliturk · #4 (**permalink**) 08-31-2007

cut -f2 -d: inputfile |sed s/[^0-9]//g

charbel · #5 (**permalink**) 08-31-2007

Is that number composed of 5 digits only?
if YES, then you can use the awk command and you can print that substring only....

code:
cat input.txt|awk 'BEGIN {FS=":"} {print substr($2,1,5)}'

this may help.....

ghostdog74 · #6 (**permalink**) 08-31-2007

Quote:

Originally Posted by charbel

Is that number composed of 5 digits only?
if YES, then you can use the awk command and you can print that substring only....

code:
cat input.txt|awk 'BEGIN {FS=":"} {print substr($2,1,5)}'

this may help.....

no need for cat.

Code:

awk 'BEGIN {FS=":"} {print substr($2,1,5)}' input.txt

vino · #7 (**permalink**) 08-31-2007

Quote:

Originally Posted by baghera

But if there is more numbers on that line for example:

how_old_r_u:45782<br>APPLY:[30000,t3,t4]:Plummet

It seems when I run the command

Code:

grep -oE "[[:digit:]]{1,}" input.txt

I also get the other numbers is there some way to get only 45782?

Which is why the sed alternative was provided. Did you try that ? Does that give you what you are looking for ?

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
extract numbers from a word	systemali	Shell Programming and Scripting	14	03-30-2009 03:47 AM
Extract numbers from a string and store in variables	davewg	Shell Programming and Scripting	6	11-14-2007 05:22 AM
grep for non numbers	shihabvk	Shell Programming and Scripting	6	09-20-2005 09:06 PM
grep numbers range	azmathshaikh	Shell Programming and Scripting	1	08-08-2005 07:45 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread: