How to format csv file to columns?
2 views (last 30 days)
Show older comments
I'm creating a csv-file containing data in over 400k rows and 4 columns via dlmwrite. First row is the header but that shouldn't really matter. My problem is, all the columns are written comma-separated. But I need them to be in the specific columns to have a better overview in Excel. I tried different stuff, didn't really work. Basically I need to execute the "text to columns"-command from Excel by using Matlab. I found the Syntax
TextToColumns( Destination , DataType , TextQualifier , ConsecutiveDelimiter , Tab , Semicolon , Comma , Space , Other , OtherChar , FieldInfo , DecimalSeparator , ThousandsSeparator , TrailingMinusNumbers )
for the actxserver, but since I'm quite new to Matlab, I don't really now how to transfer it to Matlabcode. If there is an easier way, I'd appreciate that as well.
2 Comments
Stephen23
on 13 Nov 2017
Edited: Stephen23
on 13 Nov 2017
"My problem is, all the columns are written comma-separated. But I need them to be in the specific columns to have a better overview in Excel."
That makes no sense: Excel has no problem opening CSV or TSV files, and allow you to specify the separator character when opening a file, so a well formatted CSV file should be no problem at all.
"I tried different stuff, didn't really work"
What does "didn't really work" actually mean? What did you do that did not "work"? What are you actually trying to achieve? What is your OS locale setting?
Answers (0)
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Products
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!