About null values

Hi,

I'm using importdata(file) function to extract the file information as a matrix. Until now there isn't any problem.

However, when I catch a file where there are a null values,the function only obtains the previous lines until the first line where there is a null values.

How can I configure this function for not omit the null values?

thanks

regards

[REN]

if isempty(x)

or

function: isnan([test values here])

[Andrew Newell]

Importdata isn't bothered by zeros. It ignores blank lines and variable spacing between numbers, and can even handle missing data elements in a row (by appending NaN's to the end of the row). So what do you mean by null values?

[Mtlb Usr]

Hi,

Sorry, I haven't realized me that the info that I was reading was a string, because the value of the cell is null. E.g: ...;null;...

Then, the real reason of the issue is that the importdata() doesn't read the info joining the numbers and strings.

Finally, I think that as a solution it would be change these "null" values per NaN. Perhaps, for this way the function would can read all information in one matrix. Would be it correct?

thanks

regards

Answer 1

[Mtlb Usr]

Hi,

Finally, I got resolve this issue. it was a stupid thing, because I had only to check if the value was Null or not. But Null with the first letter with capital letter..important.

However, thank you for u answer.

regards

[chocho]

@Mtlb Usr hi bro how do you solve your problem? because I have the same problem.

 i used importdata to read the file but when it get null is showing NaN and stop reading the rest of the file

Answer 2

[Matt Tearle]

It sounds like this is a delimited text file, in which case I'd recommend using textscan. It will use NaN in place of missing values. You can also specify the TreatAsNan option to tell it that certain patterns are missing values.