07-07-2020 01:43 PM
Hello,
i have a problem with a String i get out of a spectrometer. The original form of the Sting is a XML String included the measurement reslults. With Match Pattern i separate the X values and Y values to two strings.
Now i wanna combine the two Strings to a number Array. But how?
My Y data in the sting is like this:
7.948828125E-07;6.848046875E-07;6.274609375E-07;5.248046875E-07;4.015234375E-07;4.081640625E-07;3.863671875E-07;3.901171875E-07;0.03740484375 ..........
I tryed it with Spreadsheet spring to Array but than i just got this results:
7, 6, 6, 5, 4, 4, 3, 3, 0
Does anyone know how to solve my problem?
Thanks and regards
Felix
Solved! Go to Solution.
07-07-2020 01:49 PM
It worked fine for me.
Though your data in your post looks correct, is there any chance that you are running this on a computer that believes the decimal separator is supposed to be a comma rather than a decimal point?
Because the result of you getting a series of integers makes me think the conversion is recognizing the decimal point and the digits after that.
Try %.;%f as your format specifier.
07-07-2020 01:52 PM
your are right
thanks!
Would be nice if the solutions a always that easy 🙂