Convertion from Exponential to Decimal


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Convertion from Exponential to Decimal
# 1  
Old 08-16-2011
Convertion from Exponential to Decimal

I am trying to read values from excel and perform some calculations but I am getting below error:

Code:
 
expr 2.326227180240883E7 / 8.509366417956961E8
expr: non-numeric argument

Can anyone let me know how do i convert thse exponential numbers to decimal.
# 2  
Old 08-16-2011
echo "2.326227180240883E7 / 8.509366417956961E8" |awk -F "/" '{print $1 / $2 }'
0.0273373
This User Gave Thanks to shipra_31 For This Post:
# 3  
Old 08-16-2011
Code:
echo "2.326227180240883E7 / 8.509366417956961E8" | bc -l
.27337254808206913239

??? Why wrong answer?
---
Ok. "bc" doesn't understand scientific notation. It's for numbers with arbitrary precision.

Last edited by yazu; 08-16-2011 at 10:18 AM.. Reason: Ok
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Programming

Urgent help needed.. C++ program to convert decimal to hexa decimal

Hi , seq can be 0...128 int windex = seq / 8; int bindex = seq % 8; unsigned char bitvalue = '\x01' << (7-bindex) ; bpv.bitmapvalue = bitvalue; This is the part of a program to convert decimal to bitmap value of hexadecimal. I want this to change to convert only to... (1 Reply)
Discussion started by: greenworld123
1 Replies

2. Homework & Coursework Questions

Decimal to BCD (Binary Coded Decimal)

Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted! 1. The problem statement, all variables and given/known data: Design an algorithm that accepts an input a decimal number and converts it into BCD (Binary... (2 Replies)
Discussion started by: caramba
2 Replies

3. UNIX for Dummies Questions & Answers

Decimal to BCD (Binary Coded Decimal)

Anybody please help me... Design an algorithm that accepts an input a decimal number and converts it into BCD (Binary Coded Decimal) representation. Also, draw its Flow Chart. This is a unix qn... plz post algorithm for that :confused: (1 Reply)
Discussion started by: caramba
1 Replies

4. Shell Programming and Scripting

Convert exponential value to decimal

Hi, Here is my script to read a file into array: awk -F '+' ' # load first file into array indexed by fields 1 and 2 NR == FNR { file1nr = FNR for (i=3; i<NF; i++) { file1 = $i } I have this... (5 Replies)
Discussion started by: Sangtha
5 Replies

5. Shell Programming and Scripting

convertion of a file

Hi I am having file like this 1 560017039 575052020 22-11-2003 8,290.00 709545 100239050 11 2 560017006 575052020 13-01-2008 20,000.00 709545 100246770 11 i want to convert it like 5600170395750520202211200300000008290000000000000709545010023905011... (8 Replies)
Discussion started by: suryanarayana
8 Replies

6. Shell Programming and Scripting

Hex to Decimal Convertion

Dear all, I have a file like this. EE48 4473 7FC9 EE48 102C D23 EE48 4DD 27D EE48 0 0 EE48 3FFE 854 F230 DC6 ... (1 Reply)
Discussion started by: Nayanajith
1 Replies

7. UNIX for Dummies Questions & Answers

Character Convertion Help Needed

Could someone please tell me how to convert double byte charaters to single byte characters in HP-UX 11.11 without installing any applications? e.g. I have a double byte string below and I want to convert it to a single byte string ABCdef123 ABCdef123 I tried using the iconv command but I... (3 Replies)
Discussion started by: stevefox
3 Replies

8. Filesystems, Disks and Memory

convertion

How to convert a .doc document to .pdf (2 Replies)
Discussion started by: areef4u
2 Replies

9. Shell Programming and Scripting

ASCII to char convertion

I am writing the script to encrypt and decrypt content of the text file. How can I convert ASCII to characters and backward? I need it for Bourne shell script. Thanks::confused: (3 Replies)
Discussion started by: woody
3 Replies
Login or Register to Ask a Question