Scientific format

Hello

Does anybody knows a way to format scientific notation with numbers?

There isn't any function like TextToDecimal().

ex: "12345E-10" shows "0.0000012345"

Thanks


Hi

The method worked like a charm.

Thanks

Champion

Hi  ye qian,

Use below JS :

     Number("12345E-10").toPrecision();


Please Check : 

   Sample :  screen

 

Cheers


ScientNum.oml

Hi Rahul Kumar

Is there a similar method for Excel to import data to DB?

Using the JS method,  I have to load the data into the screen and then insert the data into the DB.

Champion

Please check this for import.

Some more links.

 ->  https://www.outsystems.com/forums/discussion/58632/button-for-data-import-excel-file-content-in-database-outsystems/

  ->     https://www.outsystems.com/forums/discussion/52708/import-from-excel-runtime/


You have to convert Excel to Record List. After that you have to write data in DB by foreach loop one by one.  Excel sheet Columns must have same data type as it is DB. Please check above links you will get more insights. 

Hi

The method worked like a charm.

Thanks

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.