MATLAB Answers

import data from txt missing delimiters

8 ビュー (過去 30 日間)
I am struggeling with importing data from a .txt file in my script, and i believe it is due to a '$' in my first coloumn. I have tried using csvread, textscan and importdata. The only thing i got to work was importdata, but it ignores the delimiters.
This is the command i use: "test = importdata(fullpathname,',')"
It gives me a 1291x1 array, which should have been a 1291x10.
I have attached the file im trying to import. Anyone got an idea how to import the data in different coloumns?
Thanks!

採用された回答

Todd Leonhardt
Todd Leonhardt 2016 年 5 月 22 日
Have you tried the readtable() command yet? http://www.mathworks.com/help/matlab/ref/readtable.html
It works very well with delimited files. It also allows you to specify an optional 'Format' if it doesn't work correctly out of the box.
  3 件のコメント
Todd Leonhardt
Todd Leonhardt 2016 年 5 月 22 日
For the format string, try something like:
'$%n%n%n%n%n%n%n%n%n%n#'
And since all of your numbers look like integers, maybe consider replace the "%n" which signifies a double precision float with %u for unsigned integer or %d for signed integer.

サインインしてコメントする。

その他の回答 (0 件)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by