Nathan,
Here are the steps I use to create QDEC dat files on a Mac:
-Export/save your data in SPSS/Excel as a .csv file
-Open the .csv file in TextWrangler (a free text editor for Mac)
-Do a Find & Replace of the "," for "<spaces> " to make it a space
separated file
-Down at the bottom of the TextWrangler window is a drop down box to
specify the type of hard returns ('Classic Mac' or 'Unix'); make sure
the last line ends in a return
-Save as a ~.qdec.table.dat file
Hope that helps.
-Derin
On Nov 17, 2009, at 5:00 PM, Krish Subramaniam wrote:
Some programs notoriously add Ctrl-M at the end of every line ( or
every cell )
If you have the vi editor you can follow this method
http://www.tech-recipes.com/rx/150/remove-m-characters-at-end-of-lines-in-vi/
to remove all the instances of Ctrl-M and again try in qdec.
Unfortunately I am not able to reproduce the error here because i
don't have excel.
Here's another method :
http://www.unix.com/shell-programming-scripting/25658-removing-control-ms-m.html
Best
Krish
On Nov 17, 2009, at 5:21 PM, Dankner, Nathan (NIH/NIMH) [F] wrote:
Unfortunately I'm not running windows. Are you familiar with any
tricks I can use on a mac?
On 11/17/09 5:15 PM, "Douglas N Greve" <gr...@nmr.mgh.harvard.edu>
wrote:
If you're creating the file in windows, try running dos2unix on the
file.
doug
Dankner, Nathan (NIH/NIMH) [F] wrote:
Hi all,
I am attempting to create a qdec.table.dat file, and have been
unable to find a way to paste my data into it in a way that will
make it readable. When I paste it in qdec always outputs an error
when trying to open it, even if visually the file appears to be
correct. Is there an easy way to import data from excel into
something readable by qdec? I'm hoping to avoid having to manually
enter everything because there is quite a lot of data, so any help
would be appreciated. Thanks,
Nathan
_______________________________________________
Freesurfer mailing list
Freesurfer@nmr.mgh.harvard.edu
https://mail.nmr.mgh.harvard.edu/mailman/listinfo/freesurfer
--
Douglas N. Greve, Ph.D.
MGH-NMR Center
gr...@nmr.mgh.harvard.edu
Phone Number: 617-724-2358
Fax: 617-726-7422
Bugs: surfer.nmr.mgh.harvard.edu/fswiki/BugReporting
FileDrop: www.nmr.mgh.harvard.edu/facility/filedrop/index.html
_______________________________________________
Freesurfer mailing list
Freesurfer@nmr.mgh.harvard.edu
https://mail.nmr.mgh.harvard.edu/mailman/listinfo/freesurfer
_______________________________________________
Freesurfer mailing list
Freesurfer@nmr.mgh.harvard.edu
https://mail.nmr.mgh.harvard.edu/mailman/listinfo/freesurfer
_______________________________________________
Freesurfer mailing list
Freesurfer@nmr.mgh.harvard.edu
https://mail.nmr.mgh.harvard.edu/mailman/listinfo/freesurfer
