einlesen von datentypen: *.asc*

[trathgeber]

Hi,

The problem i have is to input a file which has the ending of .asc

It´s the file-typ of a foot-pressure-analysing program to get the data of each sensor. I´m able to show it with the editor and MS Excel and so on, but if i load it up to LabView, he changes every value into zero, except of the first colume (the time-values) and the first row (sensor-values: 1-99). I´m fairly sure, that it has nothing to do with the comma, wether it´s a comma or a dot, because this i can change while loading.

Has anyone an idea?!?!

Thanks in advance, Thomas

[GerdW]

Hi Thomas,

if you would give us more informations we should be able to guide you better...

Can you attach an example of those asc-files (use ZIP if it's too big or when the forum doesn't allow this name extension)?
And please tell us which LabView version you are using!

Message Edited by GerdW on 03-13-2007 02:15 PM

[trathgeber]

Thanks for this quick answer!!

I use LabView 8.20.

I have to evaluate the data exported as ascii from the original software of the soles.

There are more or less three formats (.gtc, .fgt and the .asc) i want to export. The first and second one are no problem, but the data of the asc. file, as i wrote, is every time changed into zeros, except the first row and colume.

The vi´s which i took are: first - read from spreadsheet and secondly: an express vi like read from data (i have the german version, i don´t how it´s named in the english version)!!

Thanks, Thomas

ps: i don´t exactly know wether the attachment worked or not, but i hope so... 🙂

[GerdW]

Hi Thomas,

you should read in the asc-file as simple string and do the conversion by hand:

This version is NOT optimized for speed or very big data files, but it works for me 🙂

Message Edited by GerdW on 03-13-2007 03:12 PM

[trathgeber]

Thanks a lot!!!

I´ll try, but it maybe will take some time, cause i´m just a beginner in LabView, but if you say it works, i think it will!!!

tanks again, nice day, thomas

[GerdW]

Hi Thomas,

the subvi commented as 'convert to english notation' is a vi from my user-lib, so you will not find it in your function palette. But it is only needed to change the string to english number format (0.02 instead of 0,02).

Just tested:
This vi is not needed when you change the format string of the 2nd 'spreadsheet string to array' operation from "%f" to "%,;%f"...

[trathgeber]

Hi,

One more question: i cannot find the vi -convert to array of lines- ?!

Best regards, Thomas

[GerdW]

Hi Thomas,

it's in the string palette, the english name is 'Spreadsheet string to Array'.