convert data in the text file to table in DBL

[sean1985]

awesome.

1)whats the thing behind the small trick?

2) Is the table format same with the 2D array of DBL cause i will have to use it later. I need the data in DBL of 2D array.

3)also explain abt my mistake too

thanks mike. saviour of the day .

[GerdW]

Hi sean,

here's the hard way:

Hmm, Mike beats me... And his solution is more elegant, but: mine is the "hard way"

Sean:
The trick is to know the correct separator between your data. In your case it's not the (usual) tab, but a double space!


Message Edited by GerdW on 05-21-2008 09:23 AM

[sean1985]

GerdW

thks for the reply too.

U're the best. But mike is simple and elegant.

GerdW could u explain urs too cos I had diffculties understanding.. i just a newbie though i had completed all the neccessary studies

[GerdW]

Hi Sean

the two functions are "Search and replace chars" (in the while loop) and "spreadsheet string to array". The rest should be clear from the comments...

I was misguided by the fact that there are sometimes 2, sometimes 3 spaces depending on sign of following number. That's why I took the long way. Use Mike's example, it's much more readable...

Our both solutions will show a first column with zeros, you may want to strip it...

[sean1985]

i dunno why there is /s and %g purpose?

can u explain gerald ?

[GerdW]

Hi Sean,

my name is not "gerald"

"/s" is a space display as "/ code" (Mike is using them too!), "%g" is the format code needed by SpreadsheetStringToArray and means "scientific format". You find all those format codes in the LabView help, it's a huge page full of them


Message Edited by GerdW on 05-21-2008 10:08 AM

[Mathan]

---

GerdW wrote:
my name is not "gerald"

---

This is not the first time  names are misunderstood  ....

Mathan

Message Edited by mathan on 05-21-2008 03:33 AM

[Mathan]

---

GerdW wrote:
my name is not "gerald"

---

This is not the first time  names are misunderstood  ....

Mathan

[sean1985]

my bad

i got a problem now. though i used mike.vi at some part of my table. I found out to have 0.00 data. because my table contain some DBL values.

[GerdW]

Hi Mathan,

misspelling/-pronouncing are different than just wildly guessing the name

Hi Sean,

"I found out to have 0.00 data. because my table contain some DBL values" ??? Where's the connection here? Zero because of DBL???