can you send me the file?
n.
On Wed, 2010-09-22 at 10:28 -0500, James Porter wrote:
Hello-
I'm having a resurgence of an old problem (http://www.mail-archive.com/freesurfer@nmr.mgh.harvard.edu/msg12152.html) but the old solution is not cutting it. When I try to load a table in QDEC 1.4, I get the following error:
Loading data table qdec.table.dat... ERROR: QdecDataTable::Load did not find a column named 'fsid','ID', or 'Subject' in the first column of qdec.table.dat! Error loading the data table.
However, the file definitely does have 'fsid' as the first column.
> head qdec.table.dat | awk '{print $1, $2, $3}' fsid Sex AgeGrp 14080 Female Oldr 14081 Female Oldr 14286 Female Oldr 14287 Female Oldr 14390 Female Oldr 14391 Male Oldr 14392 Male Oldr 14428 Female Oldr 14430 Male OldrCreating the file on Windows, Mac, and Unix platforms using a variety of programs (kate, oocalc, text wrangler, excel, word, notepad, etc) with 'fsid', 'ID', or 'Subject' as the column title doesn't help, nor does running dos2unix on the file(s). Having tab delimited or space delimited files doesn't make any difference, either. Trying to open the tables with QDEC in Unix (RedHat) or Mac (10.6.4) doesn't change the outcome.
Any ideas on how to solve this riddle?
Thanks, Jim -- Jim Porter, M.A. Graduate Student Clinical Science and Psychopathology Research University of Minnesota
Freesurfer mailing list Freesurfer@nmr.mgh.harvard.edu https://mail.nmr.mgh.harvard.edu/mailman/listinfo/freesurfer
there shouldn't be a limit on the number of columns it will read. the thing to be careful about is the name of a column. sometimes when importing a spreadsheet, a column name will consist of two words (thus messing-up the detected number of columns), or it will have a minus "-" char in the name, which doesnt get interpreted properly. probably there is a column name which is not a single word.
n.
On Wed, 2010-09-22 at 10:45 -0500, James Porter wrote:
Of course, once I ask for help I stumble immediately upon the solution. There appears to be a limit to the number of columns that QDEC is willing to put up with when reading in tables. If I create a table that only has the few columns that I'm interested in (as opposed to the kitchen sink spreadsheet I was working with), then it reads in without error.
Thanks for the help by proxy! Jim
On 9/22/10 10:38 AM, Nick Schmansky wrote:
can you send me the file?
n.
On Wed, 2010-09-22 at 10:28 -0500, James Porter wrote:
Hello-
I'm having a resurgence of an old problem (http://www.mail-archive.com/freesurfer@nmr.mgh.harvard.edu/msg12152.html) but the old solution is not cutting it. When I try to load a table in QDEC 1.4, I get the following error:
Loading data table qdec.table.dat... ERROR: QdecDataTable::Load did not find a column named 'fsid','ID', or 'Subject' in the first column of qdec.table.dat! Error loading the data table.
However, the file definitely does have 'fsid' as the first column.
> head qdec.table.dat | awk '{print $1, $2, $3}' fsid Sex AgeGrp 14080 Female Oldr 14081 Female Oldr 14286 Female Oldr 14287 Female Oldr 14390 Female Oldr 14391 Male Oldr 14392 Male Oldr 14428 Female Oldr 14430 Male OldrCreating the file on Windows, Mac, and Unix platforms using a variety of programs (kate, oocalc, text wrangler, excel, word, notepad, etc) with 'fsid', 'ID', or 'Subject' as the column title doesn't help, nor does running dos2unix on the file(s). Having tab delimited or space delimited files doesn't make any difference, either. Trying to open the tables with QDEC in Unix (RedHat) or Mac (10.6.4) doesn't change the outcome.
Any ideas on how to solve this riddle?
Thanks, Jim -- Jim Porter, M.A. Graduate Student Clinical Science and Psychopathology Research University of Minnesota
Freesurfer mailing list Freesurfer@nmr.mgh.harvard.edu https://mail.nmr.mgh.harvard.edu/mailman/listinfo/freesurfer
The information in this e-mail is intended only for the person to whom it is addressed. If you believe this e-mail was sent to you in error and the e-mail contains patient information, please contact the Partners Compliance HelpLine at http://www.partners.org/complianceline . If the e-mail was sent to you in error but does not contain patient information, please contact the sender and properly dispose of the e-mail.
there a line break script, which is somehow installed in my system (Sentos), which cleans this up. you basically type lb "FILENAME" i can't try and find out what it contains, if you can't get it to work
On 22 September 2010 11:28, James Porter porterj@umn.edu wrote:
Hello-
I'm having a resurgence of an old problem ( http://www.mail-archive.com/freesurfer@nmr.mgh.harvard.edu/msg12152.html) but the old solution is not cutting it. When I try to load a table in QDEC 1.4, I get the following error:
Loading data table qdec.table.dat... ERROR: QdecDataTable::Load did not find a column named 'fsid', 'ID', or'Subject' in the first column of qdec.table.dat! Error loading the data table.
However, the file definitely does have 'fsid' as the first column.
> head qdec.table.dat | awk '{print $1, $2, $3}' fsid Sex AgeGrp 14080 Female Oldr 14081 Female Oldr 14286 Female Oldr 14287 Female Oldr 14390 Female Oldr 14391 Male Oldr 14392 Male Oldr 14428 Female Oldr 14430 Male OldrCreating the file on Windows, Mac, and Unix platforms using a variety of programs (kate, oocalc, text wrangler, excel, word, notepad, etc) with 'fsid', 'ID', or 'Subject' as the column title doesn't help, nor does running dos2unix on the file(s). Having tab delimited or space delimited files doesn't make any difference, either. Trying to open the tables with QDEC in Unix (RedHat) or Mac (10.6.4) doesn't change the outcome.
Any ideas on how to solve this riddle?
Thanks, Jim
-- Jim Porter, M.A. Graduate Student Clinical Science and Psychopathology Research University of Minnesota
Freesurfer mailing list Freesurfer@nmr.mgh.harvard.edu https://mail.nmr.mgh.harvard.edu/mailman/listinfo/freesurfer
The information in this e-mail is intended only for the person to whom it is addressed. If you believe this e-mail was sent to you in error and the e-mail contains patient information, please contact the Partners Compliance HelpLine at http://www.partners.org/complianceline . If the e-mail was sent to you in error but does not contain patient information, please contact the sender and properly dispose of the e-mail.
freesurfer@nmr.mgh.harvard.edu