Extracting numbers and multipling

Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Extracting numbers and multipling
# 1  
Old 09-02-2009
Extracting numbers and multipling

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...
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


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
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

Last edited by vgersh99; 09-02-2009 at 01:43 PM.. Reason: code tags, PLEASE!
# 2  
Old 09-02-2009
If the requirement is to extract only the number which is the last part of the line, then the following can help you.

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

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

sed extracting numbers

I have number I want to extract from this number with sed 21 and 8 to variables a and b. Any Ideas? I did like 's/\(192.168.\)/ /' but its wrong :( (6 Replies)
Discussion started by: Natalie
6 Replies

2. Shell Programming and Scripting

Extracting numbers

Hi I am part of a academic organization and I want to send a fax to the students however there must be a quicker way to get the fax numbers extracted from the online forms they sent me. The file looks like this (numbers are fake in order to protect identity): Biochemistry Major Michael... (3 Replies)
Discussion started by: phil_heath
3 Replies

3. Shell Programming and Scripting

Help extracting single instance of numbers which repeat

Hi, the title isn't very descriptive but it'll be easier to explain what I need if I write out the coordinates from which I need to extract certain information: ATOM 2521 C MAM X 61 44.622 49.357 12.584 1.00 0.00 C ATOM 2522 H MAM X 61 43.644 49.102 12.205 ... (10 Replies)
Discussion started by: crunchgargoyle
10 Replies

4. Shell Programming and Scripting

extracting non-zero pairs of numbers from each row

Hi all, I do have a tab delimited file a1 a2 b1 b2 c1 c2 d1 d2 e1 e2 f1 f2 0 0 123 546 0 0 0 0 0 0 0 0 0 0 345 456 765 890 902 1003 0 0 0 0 534 768 0 0 0 0 0 0 0 0 0 0 0 0 0 0 456 765 0 0 0 0 0 0 0 0 0 0 0 0 12 102 0 0 0 0 456 578 789 1003 678 765 345 400 801 1003 134 765... (5 Replies)
Discussion started by: Lucky Ali
5 Replies

5. Shell Programming and Scripting

[Solved] Help on extracting the numbers out of top command

Hi guys, Any easy way to generate a CSV file that contains only the numbers out of the following lines? load averages: 15.09, 12.89, 11.76 03:39:22 999 processes: 854 sleeping, 2 running, 122 zombie, 5 stopped, 16 on cpu Memory: 32G real, 17G free, 18G swap in use, 15G swap free ... (6 Replies)
Discussion started by: ejianu
6 Replies

6. UNIX for Dummies Questions & Answers

Extracting numbers from a String

Hi all, I'm a new programmer to shell script... and I have no idea how to use substring. I want to extract the numbers from the following string and place it into a variable: "170 unique conformations found" The numbers can be more than three digits depending on the case. I just want to... (10 Replies)
Discussion started by: ah7391
10 Replies

7. Shell Programming and Scripting

Extracting formatted text and numbers

Hello, I have a file of text and numbers from which I want to extract certain fields and write it to a new file. I would use awk but unfortunately the input data isn't always formatted into the correct columns. I am using tcsh. For example, given the following data I want to extract: and... (3 Replies)
Discussion started by: DFr0st
3 Replies

8. Shell Programming and Scripting

Extracting numbers from a string

Hello Everyone, i have quick question. I have file names like: bin_map300.asc and I would like to extract grid300. My approach so far: name=bin_map300.asc echo ${name%%.*} echo ${name##*_} I am stuck combining the two. Any help would be appreciated. (3 Replies)
Discussion started by: creamcheese
3 Replies

9. Shell Programming and Scripting

Error extracting 1 or more numbers with expr command

Need help with the following, I want to extract the digits from the following file pattern using the expr command. digits are in the range 1-99 Tried two different methods, not sure what I am doing wrong. file1=file1.dbf file10=file10.dbf Works for expr "$file10" : '.*\(\)' 10 ... (2 Replies)
Discussion started by: fire!
2 Replies

10. Shell Programming and Scripting

extracting numbers from strings

Hello all, I am being dumb with this and I know there is a simple solution. I have a file with the follwing lines bc stuff (more)...............123 bc stuffagain (moretoo)............0 bc stuffyetagain (morehere)......34 failed L3 thing..............1 failed this... (2 Replies)
Discussion started by: gobi
2 Replies
Login or Register to Ask a Question