Thread Subject: non-printing NaN's

Hey all:

I've got a matrix I'm trying to print to a CSV file. Some of the entries that this matrix represents have no recorded values for certain points in time, so I had those entries populated with NaN's. Here's what I'm doing so far to print to a CSV:

    data = predetermined data from ...
        sources with NaN's for blank spots; % size = m x n
    Time = predetermined points of ...
        time for data; % size = n x 1
    Output = [datestr(Time, 13), ... % time column
                   repmat(',', length(Time), 1), ... % comma to separate time
                   num2str(data, '%g, '), ... % data columns
                   repmat(char(10), length(Time), 1)] % carriage return
    fid = fopen('test.csv', 'w');
    fprintf(fid, '%s', Output');
    fclose(fid);

What I've got works just fine, but the people that want this CSV don't want to see NaN's. Is there a way to get num2str to suppress printing NaN and get it to just print spaces instead?

TIA

Try this -
x=num2str(data, '%g, ');
y = regexprep(x,'nan,', ' ','ignorecase');

Now plug in 'y' when building your 'Output' variable at the place you add the data columns.

~S