Skip to main content
J
jaiminLee1-Visitor
1-Visitor
October 21, 2019
Question

How to loading CSV file in exponential expression.

  • October 21, 2019
  • 1 reply
  • 802 views

Example 

A(G)  B (G) C (G)
0.007297 1.04E-05 3.00E-06
0.007924 6.86E-06 2.10E-05

This is CSV data example.

If i make loader. Can Thingworx handle it? 

if not i will make translate data like this.

1.04E-05  --> 0.0000104.

how to do this case?

1 reply

C
cmorfin19-Tanzanite
19-Tanzanite
October 23, 2019

Hi @jaiminLee 

 

ThingWorx, using the CSVParser, will be able to read the values.

I did a quick test and here is the result:

 

CSV file:

 
A B C
0.007297 1.04E-05 3.00E-06
0.007924 6.86E-06 2.10E-05

 

Result in AdvancedGrid widget:

expGrid.png

 

Same code as in this post has been used to load the csv.

 

Hope this helps

Christophe

 

Terms & ConditionsAccessibility statement