How to get out of a String with multiple exponatioal numbers a Number array?

[felixfelex]

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

[RavensFan · Accepted solution]

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.

[felixfelex]

your are right

thanks!

Would be nice if the solutions a always that easy 🙂