How to loading CSV file in exponential expression.

[jaiminLee]

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?

[cmorfin]

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:

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

Hope this helps

Christophe