import data from txt missing delimiters

2016 5 22
1 个回答
回答已采纳
更新时间：2016 5 22
6 次查看（30 天）

0 个投票

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

1 个投票

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 个评论
显示 1更早的评论 隐藏 1更早的评论

That was the one i was looking for! Awesome, thanks!
I got a little problem with the format. I am trying to get the numbers from my data alone, but when i use "T = readtable(fullpathname,'Delimiter',',','ReadVariableNames',false,'Format','%n%n%n%n%n%n%n%n%n%n')" i get the following message: "Error using readtable (line 135) Unable to read the entire file. You may need to specify a different format string, delimiter, or number of header lines.
Caused by: Reading failed at line 1. A field on that line may have contained the wrong type of value."
If i leave out Format there is no problem, but as soon as i insert Format it goes wrong. Any idea what is wrong?
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 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Workspace Variables and MAT Files 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by