Sponsored Content
Top Forums Shell Programming and Scripting Help needed with multiplying two values of two columns in a file Post 302677883 by momin on Thursday 26th of July 2012 08:20:59 PM
Old 07-26-2012
Help needed with multiplying two values of two columns in a file

Hi, I am trying to multiply column#1 with column#2 using a shell script. How can I make a for-loop script using 1st column as "i" and the second column as "j" from the following file? Please feel free to share any alternative ways to multiplying column#1 with column#2.

HTML Code:
.06     5.0000
.49     7.8750
.18     5.0000
.17     1.0000
.64     6.1250
.01     0.1250
.48     4.81250
.01     0.2500
.77     19.5000
Thanks in advance
Smilie

---------- Post updated at 08:20 PM ---------- Previous update was at 08:16 PM ----------

This is what I tried..... but did not work Smilie

HTML Code:
root@vna1(/)# for x in `awk '{print $1}' /tmp/temp6`
> do
> for j in `awk '{print $2}' /tmp/temp6`
> do
> echo "scale=3; $x * $y" | bc
> done
> done
syntax error on line 1 stdin
syntax error on line 1 stdin
syntax error on line 1 stdin
syntax error on line 1 stdin
syntax error on line 1 stdin
syntax error on line 1 stdin
syntax error on line 1 stdin
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Help needed to sort multiple columns in one file

Hi, I would like to know given that I have 3 columns. Let say I have first 3 columns to do operation and these operation output is printed out each line by line using AWK and associative array.Currently in the output file, I do a sort by -r for the operation output. The problem comes to... (1 Reply)
Discussion started by: ahjiefreak
1 Replies

2. Shell Programming and Scripting

Help needed: Adding columns in csv file in loop

Hi Everyone: My shell script creates multiple csv files (~30) in for loop. I want to compile (or merge) 3rd column from each (all) of these files to another file (in loop). Please help. Thanks. (3 Replies)
Discussion started by: smap007
3 Replies

3. Shell Programming and Scripting

multiplying values from two text files

Im very new to programming. But I would like to write a script which extracts and multiply values from 2 txt and output as a new file. Can someone please teach me how to write it? Thank you so much for example File A File B 1 34 1 2 2 13 2 2 3 8 3 3 File C output 1 68 2... (2 Replies)
Discussion started by: crunchichichi
2 Replies

4. UNIX for Dummies Questions & Answers

combine the values from the first two columns within a file

Hello everybody, I have a text file containing 10,000 rows and 5000 columns. The values are separated by a tab. Ex. file_ex.ped 1 mike 0 0 2 1 A A G G C T A G 1 jack 0 0 2 2 T A G T C A A C 1 Mary 0 0 1 2 A T G C A T G C ... I would like a out put file 1 mike 0 0 2 1 AA GG CT AG 1... (7 Replies)
Discussion started by: Unilearn
7 Replies

5. Shell Programming and Scripting

error- multiplying negative decimal values

a=10.02 pattern=-11.01 b=$(echo | awk '{ print $a*$pattern}') echo $b its not working even ALso tried `expr $a \* $pattern` No LUCK (3 Replies)
Discussion started by: saluja.deepak
3 Replies

6. UNIX for Dummies Questions & Answers

Subtracting values from 2 columns in a file

Hello, I have a file with 5 columns that looks like this: A1BG chr19 + 58863335 58866549 A1BG chr19 - 58858171 58864865 A2LD1 chr13 - 101182417 101186056 A2LD1 chr13 - 101182417 101241046 A2M chr12 - 9220303 9268558 A2ML1 ... (5 Replies)
Discussion started by: wolf_blue
5 Replies

7. UNIX for Dummies Questions & Answers

Removing columns from a text file that do not have any values in second and third columns

I have a text file that has three columns. But at the end of the text file, there are trailing lines that have missing second and third columns: 4 0.04972604 KLHL28 4 0.0497332 CSTB 4 0.04979822 AIF1 4 0.04983331 DECR2 4 0.04990344 KATNB1 4 4 4 4 How can I remove the trailing... (3 Replies)
Discussion started by: evelibertine
3 Replies

8. Shell Programming and Scripting

Needed value after the last delimeter in a file with varying number of delimited columns

Hi All, My file has the records as below: aaa\bbb\c\dd\ee\ff\gg zz\vv\ww pp\oo\ii\uu How can I get the value after the last delimeter. My o/p: gg ww uu Thanks in Advance, (5 Replies)
Discussion started by: HemaV
5 Replies

9. Shell Programming and Scripting

Creating a loop for multiplying columns

I have 2 files, that look like this: ID SNP1 SNP2 SNP3 SNP4 A1 1 2 0 2 A2 2 0 1 1 A3 0 2 NA 1 A4 1 1 0 2 and this: SNP score SNP1 0.5 SNP2 0.7 SNP3 0.8 SNP4 0.2 Basically, all of the SNP-values are 0,1, 2 or NA, and they each have a score, listed in the second file. The total... (5 Replies)
Discussion started by: kayakj
5 Replies

10. UNIX for Beginners Questions & Answers

Add values to file in 2 new columns

Columns 4 and 5 are X and Y coordinates, column 6 is the elevation I would like to add 2 new columns at the end of the file with values the distance between first(X)(Y) and last location (X)(Y), based in 2 rows the difference in elevation = ($6-prev6) How to calculate the requested values... (6 Replies)
Discussion started by: jiam912
6 Replies
HTML::HTML5::Parser::Error(3pm) 			User Contributed Perl Documentation			   HTML::HTML5::Parser::Error(3pm)

NAME
HTML::HTML5::Parser::Error - an error that occured during parsing DESCRIPTION
Note that HTML::HTML5::Parser is not a validation tool, and there are many classes of error that it does not care about, so will not raise. The "error_handler" and "errors" methods of "HTML::HTML5::Parser" generate "HTML::HTML5::Parser::Error" objects. "HTML::HTML5::Parser::Error" overloads stringification, so can be printed, matched against regular expressions, etc. Constructor "new(level=>$level, type=>$type, token=>$token, ...)" Constructs a new "HTML::HTML5::Parser::Error" object. Methods "level" Returns the level of error. ('MUST', 'SHOULD', 'WARN', 'INFO' or undef.) "layer" Returns the parsing layer involved, often undef. e.g. 'encode'. "type" Returns the type of error as a string. "tag_name" Returns the tag name (if any). "source_line" ($line, $col) = $error->source_line(); $line = $error->source_line; In scalar context, "source_line" returns the line number of the source code that triggered the error. In list context, returns a line/column pair. (Tab characters count as one column, not eight.) "to_string" Returns a friendly error string. SEE ALSO
HTML::HTML5::Parser. AUTHOR
Toby Inkster, <tobyink@cpan.org> COPYRIGHT AND LICENSE
Copyright (C) 2011-2012 by Toby Inkster This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself, either Perl version 5.8.1 or, at your option, any later version of Perl 5 you may have available. perl v5.14.2 2012-03-19 HTML::HTML5::Parser::Error(3pm)
All times are GMT -4. The time now is 11:23 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy