Spreadsheet String To Array Function

[oli_dragon]

can someone help me in understanding how to convert the .txt spreadsheet into double array. It looks like the function is only readin the first charater. The vi was working fine (XP LV2011 SP1) before I migrate to win7 (LV2011 SP1).

[James_W]

you are using "d" - this converts to intergers, use %3f for floating point numbers (or %3g %3e %3p etc  - look ate the context help for string conversion formats)

[oli_dragon]

correct.

I changed that to float %f, but still I only have first character of each string number... what can I do

[James_W]

have you tried:

%.3f

[RavensFan]

It's your decimal point being a comma, problem.

[James_W]

---

RavensFan wrote:

It's your decimal point being a comma, problem.

---

&$%$$ - I looked at that myself but didn't think it was a comma. Must get eyes checked soon!!

[RavensFan · Accepted solution]

He needs to make his format string %.;%.3f  The %  {period} {semicolon} tells the format string to interpret that string properly with decimal points rather than using the system setting which happens to be a decimal comma since that is what the array is showing.

[oli_dragon]

Great

%.;%.3f works perfectly. thanks guys