import data from txt missing delimiters

Question

Christian von Spreckelsen 2016-5-22

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/285385-import-data-from-txt-missing-delimiters

评论： Todd Leonhardt 2016-5-22

IMU 1 - forsøg 1 bred.TXT

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!

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Todd Leonhardt 2016-5-22

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/285385-import-data-from-txt-missing-delimiters#answer_223085

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更早的评论

Christian von Spreckelsen 2016-5-22

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 2016-5-22

在 MATLAB Online 中打开

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.

请先登录，再进行评论。

import data from txt missing delimiters

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

采纳的回答

3 个评论
显示 1更早的评论隐藏 1更早的评论

更多回答（0 个）

另请参阅

类别

标签

Community Treasure Hunt

import data from txt missing delimiters

0 个评论 显示 -2更早的评论隐藏 -2更早的评论

采纳的回答

3 个评论 显示 1更早的评论隐藏 1更早的评论

更多回答（0 个）

另请参阅

类别

标签

Community Treasure Hunt

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

3 个评论
显示 1更早的评论隐藏 1更早的评论