Export Data via fprintf printing something else besides NaN

6 views (last 30 days)
Brian on 25 Nov 2013
Commented: Brian on 25 Nov 2013
Hi, I have a simple export loop that is writing the contents of a matrix to a text file for another system to read. The issue is that the other system doesn't like NaN as part of a numeric array and I need to print a blank space instead. How can I go about doing this?
On occasion my MacroData matrix Contains NaN's. Is there a way for me to do a find replace while I'm in the file itself, or simple replace the NaN output with a blank?
f_format = '%s%f%f\r\n';
count = 1;
for i = 1:length(UniqueDates)
Thanks a lot, Brian

Accepted Answer

Titus Edelhofer
Titus Edelhofer on 25 Nov 2013
a simple solution would be to print first into a string, process the string and then dump to the file, something like
for i = 1:length(UniqueDates)
str = sprintf(f_format,datestr(UniqueDates(i,1),'mm/dd/yyyy'),MacroData(i,:));
str = strrep(str, 'NaN', ' ');
fprintf(f_temp, '%s', str);
  1 Comment
Brian on 25 Nov 2013
Works perfect thanks Titus. I had never used sprintf before so I really wasn't certain of it's use.
Thanks again, Brian

Sign in to comment.

More Answers (0)

Community Treasure Hunt

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

Start Hunting!

Translated by