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" greve@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 greve@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

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

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" greve@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 greve@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