Convert DIAdem files to excel (or csv)

[1984]

Hi community,

a friend of mine sent me some diadem files in a zip format. The zip file contains 8 files with the following extensions: ISF, DAT, I16, T64, W8, W16, W32, Text document

He wonders if I can convert the data to excel. I have never used diadem, so i promissed him that I will ask here in the forums. 

Is it possible to do it in the easy way? I have LV2014 and LV2015.

thanks!

[Brad_Turpin]

Hi Big Brother,

If the ISF file is a Tektronix ISF file, then NI has a DataPlugin that will read it. I'm not sure what to make of the T64 file.  We can probably create a DataPlugin to read the "Text document" file, but I'd have to see it first to know how simple or hard that will be.  The remaining files should be components of a native DIAdem DAT file: DAT, I16, W8, W16, W32.  You can load all those components by choosing to load the *.DAT header file with the "DAT" DataPlugin.

You can load data files into LabVIEW using DataPlugins by running the "Storage VIs", which you will find in the "File I/O" palette, right next to the TDMS VIs.

If this is a one-off request, you could also just post that data set, and I could see if I could create one or more CSV or Excel files from the data.

Brad Turpin

DIAdem Product Support Engineer

National Instruments

[1984]

Thanks Brad. The data is confidential and there would be probably thousands of files which would need to be converted, so I will just relay back to my friend that they need to find a different way to solve his issue.

thx again!

[Brad_Turpin]

Hi 1984,

Just a quick postscript here.  The DataPlugin does not convert the data file, it merely enables DIAdem or LabVIEW or the DataFinder to read the data file in its native state.

Brad Turpin

DIAdem Product Support Engineer

National Instruments

[Dia791]

Hello guys,

if the TXT file contains the raws/columns of data, it's ratzher easy to read it into DIAdem.

Then the content can be "exported" into the ASCII file with the extension CSV, which is then a "native" format for Excel...