LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Read from spreadsheet file

I came across an embarassing problem. When a data was transfered from the
oscilloscope to a file. Some part of the data was stored in a float type
rather than engineeing type as below. This seems to be due to the difference
of the amplitude of each data. Separating two coloums into each 1D array by
using the delimiter(\s\s\s), Labview caused some mistake which was not
expected, becuase, there are 6 or 7 spaces in the float type figures. Could
anyone help me to separate these two coloums with the engineering type
effectively? I have used a VI(read from spreadsheet file.vi) to drag this
data.


x y
1.53899979E-04 5.77684790E-02
1.53999979E-04 9.80626121E-02
1.54099980E-04 0
.15726906
1.54199981E-04 0.22460309
1.54299982E-04 0.28177762
1.54399982E-04 0.30948961
1.54499983E-04 0.29732949
1.54599984E-04 0.24740726
1.54699985E-04 0.17171118
1.54799985E-04 8.52460191E-02
1.54899986E-04 -1.76618993E-03
1.54999987E-04 -8.23388398E-02
1.55099988E-04 -0.15329903
1.55199989E-04 -0.21366209
1.55299989E-04 -0.26128671

>>> This should have been changed into ...

x y
1.53899979E-04 5.77684790E-02
1.53999979E-04 9.80626121E-02
1.54099980E-04 1.57269060E-01
1.54199981E-04 2.24603090E-01
1.54299982E-04 2.81777620E-01
1.54399982E-04 3.09489610E-01
1.54499983E-04 2.97329490E-01
1.54599984E-04 2.47407260E-01
1.54699985E-04 1.71711180E-01
1.54799985E-04 8.52460191E-02
1.54899986E-04 -1.76618993E-03
1.54999987E-04 -8.23388398E-02
1.55099988E-04 -1.53299030E-01
1.55199989E-04 -2.13
662090E-01
1.55299989E-04 -2.61286710E-01


many Thanks
0 Kudos
Message 1 of 1
(3,503 Views)