DIAdem

cancel
Showing results for 
Search instead for 
Did you mean: 

How to read in scientific notation data with GetStringBlock()

Solved!
Go to solution

Hi, I wrote a vbs dataplugin to hand a file format I have been working with. It works except it adds 10^8 to each value read in. 

 

data is in the following format in ascii file:  

0.00000000E+000, 3.64626834E+000
1.25000000E+001, 9.34699104E+000
2.50000000E+001, 9.43020247E+000

 

I have attached an example of the text file and my vbs script code. 

 

Anyone have any idea what I'm missing? Do I need to parse the data somehow first and not use the E+000 format for GetStringBlock() to read in the value properly? 

Download All
0 Kudos
Message 1 of 3
(2,348 Views)
Solution
Accepted by topic author jdferdon

Hi,

I think you mixed up two formatting options. Please replace 

File.Formatter.ThousandSeparator = "."

with

File.Formatter.DecimalPoint = "."
0 Kudos
Message 2 of 3
(2,318 Views)

Yep, that was it, thanks for finding my silly errors. 

0 Kudos
Message 3 of 3
(2,310 Views)