How to format csv file to columns?
2 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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 commentaires
Stephen23
le 13 Nov 2017
Modifié(e) : Stephen23
le 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?
Réponses (0)
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Produits
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!