import data from txt missing delimiters

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!

Answer 1

[Todd Leonhardt]

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.

[Christian von Spreckelsen]

That was the one i was looking for! Awesome, thanks!

[Christian von Spreckelsen]

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]

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.