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 Oldr

Creating 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.