How can I write to a CSV file in separated columns and without any commas?
37 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
I am using the following code to write in a CSV file for 10 different columns but I end up with all data in a single column and commas between each data.
dlmwrite('/Users/.../matlabdandata2.csv',[frames' time' cycle' ...],'delimiter',',','-append')
Thanks!
0 comentarios
Respuestas (3)
Christopher Wallace
el 13 de Jul. de 2018
Editada: Christopher Wallace
el 13 de Jul. de 2018
csvwrite('matlabdandata2.csv', [frames, time, cycle])
9 comentarios
Walter Roberson
el 14 de Jul. de 2018
Image Analyst
el 14 de Jul. de 2018
Editada: Image Analyst
el 14 de Jul. de 2018
That workbook has only 5 columns and they don't even have names that match. How are we supposed to generate the variables he called "[frames' time' cycle' ...]" which he is trying to stitch together?
And does he want 3 columns in the output text file, or 10 columns? And what does "the only problem is separating as 10 different columns" mean?
Image Analyst
el 13 de Jul. de 2018
When you did this:
dlmwrite('/Users/.../matlabdandata2.csv', [frames' time' cycle' ...], 'delimiter', ',', '-append')
did you notice that you specified a comma as the delimiter? Why?
If you don't want a comma, specify a space or something else as the delimiter.
2 comentarios
Image Analyst
el 13 de Jul. de 2018
What does this say in the command window:
data = [frames', time', cycle', ...etc....] % Stitch 10 vectors side by side.
whos data
dimensions = size(data)
Attach your data if you want people to help you.
Ece Su Ildiz
el 14 de Jul. de 2018
6 comentarios
Image Analyst
el 14 de Jul. de 2018
When you said "separator" regarding a CSV (Comma Separated Variable) file I assumed you meant the separator between the complete numbers. Now I'm wondering if you're talking about the separator between the thousands and millions groups in the number instead. Which is it?
Also I'm wondering if the columns in your table are actually strings, because I don't see why, in your first screenshot, cell F1 uses a comma but cell F2 uses a period for the decimal point.
What is your "region" (country) that your computer is set up for in your settings/control panel? Is it one of those countries that uses commas instead of dots for decimal points?
Ver también
Categorías
Más información sobre String Parsing en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!