NEED HELP FAST! I have several problem about ASCII file.

So, I have a ASCII data file with unknown number (NaN). My teacher want me to change NaN into -99.9999. But when I tried so many times, the undefined variable error is appear. WHAT SHOULD I DO? Pls I appreciate if anyone can help :))

[Walter Roberson]

Please do not close questions that have an answer.

Answer 1

[Image Analyst]

What did you try? Did you try the obvious

 data(isnan(data)) = -99.9999;

?? What error message did you get?

[Image Analyst]

By the way, that's an Excel workbook file, not an ASCII text file.

[della tan]

A = xlsread('COBA','Sheet1','A1:E709') 

A(isnan(A))= -99.9999

so, the excel file not showing all data....

[della tan]

what should i do??

[Image Analyst]

column E is considered text data by Excel since there is no equals sign there. To get everything, try this:

[numbers, strings, raw] = xlsread('COBA.xlsx');
numbers(isnan(numbers)) = -99.9999;

strings will be a cell array of your strings in column e. If you want to parse the strings into numbers, use textscan(), or sscanf(), or strsplit() with str2double().

[della tan]

i dont understand with "If you want to parse the strings into numbers, use textscan(), or sscanf(), or strsplit() with str2double()". Can you give me an exemple with my data?

[Walter Roberson]

It would be easier to go back to the original text data and import that properly, than to continue working with this badly input .xlsx