Hi,
I am trying to run qdec for group analysis of subcortical and cortical volumes. I have all of my data in an excel sheet (subject ID, age, gender, volumes of various structures) and am trying to convert this into a file that will be able to be opened in qdec. I use a Mac, and I have exported the sheet into text-edit and then resaved it as "qdec.table.dat". This .dat file opens perfectly in text-edit. However, when I go to load the table into qdec it gives me an error: "error loading the data table"
Is the dat file I created not compatible with qdec? If so, is there another way in which I can transfer my data into a dat file?
Thank you very much in advance for your help,
Matt
I forget to load the specific error message for the qdec.table.dat error. Thanks again for your help.
*Loading data table /Volumes/GEcontrols/qdec/qdec.table.dat... QdecDataTable::Load: will attempt to open as Mac text file... Number of columns: 6 fsid column: 1 Number of factors: 5 Number of subjects: 150 ERROR: QdecDataTable::Load: problem parsin file /Volumes/GEcontrols/qdec/qdec.table.dat This line did not appear to end with a newline:
Error loading the data table.*
On Tue, Nov 24, 2009 at 1:22 PM, Matt Warner mawfreesurfer@gmail.comwrote:
Hi,
I am trying to run qdec for group analysis of subcortical and cortical volumes. I have all of my data in an excel sheet (subject ID, age, gender, volumes of various structures) and am trying to convert this into a file that will be able to be opened in qdec. I use a Mac, and I have exported the sheet into text-edit and then resaved it as "qdec.table.dat". This .dat file opens perfectly in text-edit. However, when I go to load the table into qdec it gives me an error: "error loading the data table"
Is the dat file I created not compatible with qdec? If so, is there another way in which I can transfer my data into a dat file?
Thank you very much in advance for your help,
Matt
Hi Matt, I believe the problem lies in how excel treats end of line characters (even Excel for Mac). You could use Open-office which will export to a more Unix-friendly format, or you could try using tr (a Unix command-line utility that could change the problematic end of line characters to Unix-compatible ones). Are you familiar with the Unix command-line tools? Try using "cat" to read the file and piping it to wc -l. Chances are you will have only one line. Let me know if you need further assistance. If there is nothing personal in the files, I could probably do it for you if you send me the file. Jared
Matt Warner wrote:
Hi,
I am trying to run qdec for group analysis of subcortical and cortical volumes. I have all of my data in an excel sheet (subject ID, age, gender, volumes of various structures) and am trying to convert this into a file that will be able to be opened in qdec. I use a Mac, and I have exported the sheet into text-edit and then resaved it as "qdec.table.dat". This .dat file opens perfectly in text-edit. However, when I go to load the table into qdec it gives me an error: "error loading the data table"
Is the dat file I created not compatible with qdec? If so, is there another way in which I can transfer my data into a dat file?
Thank you very much in advance for your help,
Matt
Freesurfer mailing list Freesurfer@nmr.mgh.harvard.edu https://mail.nmr.mgh.harvard.edu/mailman/listinfo/freesurfer
freesurfer@nmr.mgh.harvard.edu