My csv file having some Scientific value and before importing into the db I want to convert those values in number.
Could you please help me out.
Thanks in Advance :)
~Deepak
2008-07-25 09:42 PM
WebsiteBlog
How to convert Scientific value in Number
- Dshivhare
- Posts: 12
- Starts: 4
- Wiki Edits: 0
- Location: Denver, CO
- Vinayan
- Posts: 250
- Starts: 0
- Wiki Edits: 2
What type of scientific values are in your csv file? For eg:- The expression "E" ( 1.2E3 ) is a standard MySQL Scientific value. You can directly load the contents in the csv file to the MySQL db using the command "LOAD DATA INFILE".
2008-07-25 11:10 PM
- Dshivhare
-
- Posts: 12
- Starts: 4
- Wiki Edits: 0
- Location: Denver, CO
- Santhi
- Posts: 233
- Starts: 0
- Wiki Edits: 1
To convert 2.60E+12 to number:
2.60E+12 = 2.60*10^12 which is equal to 2,600,000,000,000 .
2008-07-26 04:02 AM
- Dshivhare
-
- Posts: 12
- Starts: 4
- Wiki Edits: 0
- Location: Denver, CO
- Vinayan
-
- Posts: 250
- Starts: 0
- Wiki Edits: 2
Hi Dshivhare,
I am not sure about any inbuilt function in Ruby to convert scientific value to normal format. But you can convert one base to another base Eg:- octal to decimal or binary to decimal etc. It seems like you can directly enter the value 2.60E+12 to your database. The expression "E" is a standard MySQL Scientific value and your database will recognize it. Do you face any issue since the value is in scientific format?
I am not sure about any inbuilt function in Ruby to convert scientific value to normal format. But you can convert one base to another base Eg:- octal to decimal or binary to decimal etc. It seems like you can directly enter the value 2.60E+12 to your database. The expression "E" is a standard MySQL Scientific value and your database will recognize it. Do you face any issue since the value is in scientific format?