Shell Programming and Scripting

Hi,

I have a string like:

DBMS stats (Number Used | Percentage of total): 10 | 1.00%

I have a sed command to extract numbers from this string:

Code:

sed "s/[^0-9]//g;s/^$/-1/;"

Output: 10100

However what I want the sed command to return is only the first number(regardless of its size) i.e. 10

Thanks in advance.

Hi mccartj5,

Try:

Code:

$ cat infile
DBMS stats (Number Used | Percentage of total): 10 | 1.00%
$ sed 's/^[^0-9]*\([0-9]\+\).*$/\1/' infile
10

Regards,
Birei

Code:

$ nawk -F"[:|]" '{print $3}' infile

Hi birei,

Thanks for the quick reply.

As my file can contain several lines of input I only want to evaluate the last line. I have tried the following with your suggestion but it brings me back the full string:

tail -1 infile | sed 's/^[^0-9]*\([0-9]\+\).*/\1/'

output: DBMS stats (Number Used | Percentage of total): 10 | 1.00%

Thanks,
mccartj5

---------- Post updated at 11:47 AM ---------- Previous update was at 11:39 AM ----------

Spot on jj. I see what you're doing there, looks simple when pointed out