Titles in Data File (case 6089)

[jkzuerch]

Hi,

I apologize for the delay in my response. The attached document has a sample of the issue. The fourth column labeled "Inifile" stores its data into two separate columns so that the titles for the rest of the columns are not above the correct set of data.

Thank you in advance,

Joanna

[jason_reed]

Hi Joanna,

When I downloaded your file and it automatically openned in Excel, all of the values appeared to be properly aligned in their respective columns. I only had two odd things happen. First, there was a blank row between Subject numbers 17 and 18. I'm more curious about my second observation in the first row of the spreadsheet with the column headings. Why is the column U (the one with all of the cells containing Suppression Questionnaire 2) header "none" and why does column V have no header? Did you name a variable or questionnaire file in yourMediaLab study as "none?"

Psychboiler

[timdritchie]

hi Joanna,

I think I see what you mean. The file that you had include is named:

"Suppression_Study_-_Version_2,_Part_B.csv"

Notice the comma in "Version_2,_" --this is where the file path and name are being separated and shifting your columns to the right, such that "default.mlp" should be under Inifile, the date should be under the Date heading etc.

You want to see under "Exper" the entire path plus the entire file name, but this is not happening currently. I suspect that it is the comma within your file's name that is confusing MediaLab when it writes to the file.

Try renaming your experiment file to something simpler with no comma in the file title, such as "Suppression_Study_Version2_PartB.csv"
Run a few sessions, make sure that all new data is saved under the correct column. Please let me know if that solves it.

[jkzuerch]

Hi,

Thank you. Yes, I will definitely avoid using a comma with my next study, since it is shifting the data over one column.

Cheers,

Joanna

[jarvis]

Commas in file names? Huh.. yes, this could cause all sorts of issues! We'll have to make an allowance for this such that it will not throw off the reading of CSV files. Maybe have MediaLab/DirectRT extract any commas and replace them with periods (or somesuch) when creating the data files. Honestly, I'm surprised Windows even lets you use commas as they are illegal in short file names and they are used as argument delimiters when using command line type stuff. Interesting--glad it's working ok now!