MATLAB: Changing portions of variable names

.datcsvMATLABsave

This may be a very simple question but I have been struggling with it for a bit and would appreciate the help.

rawdatafile = dir('*.csv');
rawdata = rawdatafile.name;
RawDataMatrix = csvread(rawdata, 13,0);
dlmwrite( strcat(rawdata,'.dat'), RawDataMatrix)

I have some code that finds a .csv file and imports it then deletes the first 13 rows and I am wanting to save the matrix as the same filename except instead of .csv I want to save it as .dat. The current code I have above saves it as filename.csv.dat so I am wondering how to get rid of the '.csv' portion before I save it. Thanks for the help!

Best Answer

Use this as the new filename:

strrep(rawdata,'.csv','.dat')

Or more robustly:

[~,fnm] = fileparts(rawdata);
sprintf('%s.dat',fnm)

Related Solutions

MATLAB: Importing text files into matlab in order to manipulate the data

http://matlab.wikia.com/wiki/FAQ#How_can_I_process_a_sequence_of_files.3F

For each file name that is found use

fid = fopen(CompleteFileName, 'rt');
datacell = textscan(fid, '%s%f%f%f%f%f%f%f%f', 'Delimiter', ',');
fclose(fid);

Then datacell{1} would be a cell array of strings that held the first column, datacell{2} would be a numeric column vector holding the second column, and so on through datacell{9} holding the 8th numeric column.

Here CompleteFileName is the fully qualified file name you extracted by using dir() and fullfile

MATLAB: Help creating a for loop for research purposes

You have frame numbers in the first column of the file, which can be used to build a cell array.

Try this:

RawDataMatrix = csvread('2020_July_16_12_34_43.csv', 1,0);
% After reading your matrix, give the frame ID where you would like to start
frame_id = 2; 
frame_count = 1;
i_start = 1;
% Initialize cell array for frames
nFrames  = 60;
Temp_frame_array = cell(nFrames,1);
% Start loop
for i = 1:size(RawDataMatrix,1)
    if RawDataMatrix(i,1) == frame_id
        % Do Nothing
    else
        % Store eveything till this row in to a cell
        Temp_frame_array{frame_count,1} = RawDataMatrix(i_start:i-1,:);
        
        % Update the row number for next set
        i_start = i;
        
        % update frame_id, frame_count and resume binning
        frame_id    = RawDataMatrix(i,1);
        frame_count = frame_count + 1;
    end
end
% For the last frame the IF condition won't go to ELSE, so
Temp_frame_array{frame_count,1} = RawDataMatrix(i_start:end,:);
% Now loop through frames
for i = 1:nFrames
    Tempdata     = Temp_frame_array{i,1};
    N2peak(i,1)  = sum(Tempdata(436:461,3));
    N2low(i,1)   = sum(Tempdata(476:491,3));
    N2high(i,1)  = sum(Tempdata(520:610,3));
    H20peak(i,1) = sum(Tempdata(1279:1303,3));    
end

Hope this helps.

Best Answer

Related Solutions

MATLAB: Importing text files into matlab in order to manipulate the data

MATLAB: Help creating a for loop for research purposes

Related Question