From Friday, April 19th (11:00 PM CDT) through Saturday, April 20th (2:00 PM CDT), 2024, ni.com will undergo system upgrades that may result in temporary service interruption.
We appreciate your patience as we improve our online experience.
From Friday, April 19th (11:00 PM CDT) through Saturday, April 20th (2:00 PM CDT), 2024, ni.com will undergo system upgrades that may result in temporary service interruption.
We appreciate your patience as we improve our online experience.
04-29-2016 07:40 AM
Hello,
I have a 3rd party LabVIEW application (.exe only, no source code) that is generating DTA files that I a have not been able to successfully read using a variety of software packages (LabVIEW, MATLAB, Excel, Stata, etc.).
Since the files were generated by a LabVIEW application, I would think that LabVIEW would be able to read these files as well. I have tried "Read from Binary File" in LabVIEW specifying different byte orders, but am not getting the data I desire from the file. The files should hold numerical values, and there MAY be some header information, but I'm not sure since I'm not able to read them.
I've attached an example file. I changed the ".dta" extension on the file to ".csv", as ".dta" is not one of the accepted file types for attachments. Any help or guidance is greatly appreciated.
Thank You,
Akshay
05-02-2016 04:37 AM
@AkshayHari wrote:Hello,
I have a 3rd party LabVIEW application (.exe only, no source code) that is generating DTA files that I a have not been able to successfully read using a variety of software packages (LabVIEW, MATLAB, Excel, Stata, etc.).
Thank You,
Akshay
The .dat file generated can be imported into a Microsoft Excel spreadsheet for calculations and graphing purposes as follows:
Start excel
File Open
Select "All files"
Select your .dat file (previously recorded and saved).
Select "delimited" (as opposed to the default "fixed width")
Import starting at line 33
Next
Unselect "Tab"
Select "Semicolon", you should see bars separating the data fields now.
Next
Define each field. European users will have to select "Advanced", then change the "Decimal point" to "." and "Thousands separator" to ","
field 1,2 = date YMD
Hope this helps
Kudos Welcome 🙂
05-02-2016 06:14 AM
Thanks a lot for getting back to me.
However, the steps you outlined did not work for me. What should I put in the "File origin" box? I quickly parsed through all of the options and did not see one that led to the data I expected to see (they all showed special characters in the Preview box).
Could you share the Excel file into which you successfully imported the data?
Thank You,
Akshay
05-03-2016 04:22 PM
Hi Akshay,
Have you had any more luck opening the .dat or .dta file? Could you upload the original file and not the .csv file? Do you get any errors or does it not show up correctly?
Also, do you have any information about the executable that is generating the file?
05-03-2016 04:49 PM
05-04-2016 06:11 AM
Please find the original .dta file in the attached .zip file.
Thanks,
Akshay