UNIX for Dummies Questions & Answers

Hi All,

I have searched the forum but couldn't find exactly what I need. Hopefully someone may be able to help.

I'm trying to put a script together that will extract numbers from a text file and multiply them by, for example 1.5 or 1.2

Sample file looks like this...
--------------------------------------------------

Code:

line of text
line of text - there are a random number of lines here, maybe 3, maybe 8
line of text
01 - number of product A sold 431242
02 - and we also sold this number product B 4423
05 - and this number product C 55343
06 - and finally this number product D 534211

--------------------------------------------------

I want the initial output file to look like this
--------------------------------------------------

Code:

431242
4423
55343
534211

--------------------------------------------------

So as you can see I only want the figures in the new file.
If it helps, the lines the figures are on will always start as shown above - i.e. one line starts with 01, the next with 02, the next with 05 and the last with 06

My intention is then to take each of these figures and add them to a more meaningful output file adding a new column which has the figures multiplied by 1.5, except for the last figure which will be multiplied by 1.2 to give a new target - for example
---------------------------------------

Code:

Product   Sold   Target
Product A 431242 646863
Product B 4423   6634
Product C 55343  83014
Product D 534211 641053

---------------------------------------

I think I know how to do the multiply ok, but it's the extraction of the initial figures that I'm having a problem with.

If anyone can lend a hand it would be appreciated.

Many thanks
S

If the requirement is to extract only the number which is the last part of the line, then the following can help you.

Code:

grep 'product' t1 | egrep -o '[[:digit:]]+$'