MATLAB: Conveter a string with space in a number

convertdata importstring

A have one vector returned by the function textscan which have spaces inside the numerical string.

E.g.:

' 0 0 , 2 3 '
' 1 2 , 1 5 '

First, a have to substitute the ',' by '.' (it's simple) but how I remove the spaces? Because using str2num in this vector is returned error.

Best Answer

It's pretty much the same except that you set it equal to [] instead of a decimal point:

str(str == ' ') = []; % Remove spaces

Related Solutions

MATLAB: Using regexp for space delimited strings in text file.

Try this:

% textscan options:
opt = {'MultipleDelimsAsOne',true,'CollectOutput',true};
% required arrays:
str = 'X';
dtv = [];
dat = {};
% open textfile:
fid = fopen('data.txt','rt');
while ischar(str)
    % skip lines until first char is '*' (date vector):
    while ~strcmp(str(1),'*')
        str = fgetl(fid);
    end
    % convert date vector to numeric:
    dtv(end+1,:) =  str2double(regexp(str(2:end),'\S+','match')); %#ok<SAGROW>

    % get file position:
    pos = ftell(fid);
    % read first line of matrix:
    str = fgetl(fid);
    if ischar(str)
        % calculate how many columns in the matrix:
        N = numel(regexp(str(5:end),'\S+','match'));
        fmt = repmat('%f',1,N);
        % rewind one line:
        fseek(fid,pos,'bof');
        % read entire matrix:
        dat{end+1} = textscan(fid,['%4[^*]',fmt],opt{:}); %#ok<SAGROW>
    end
end
% concatenate data in cell arrays:
dat = vertcat(dat{:});
mat = vertcat(dat{:,2});

This reads the entire data matrix (between the date vectors) into a numeric matrix inside the cell array dat, and the date vectors in dtv. It automatically adjusts for the different numbers of columns in your matrices. Some important assumptions:

the first columns comprise of exactly four characters (which may be spaces).
the date vectors always start with asterisks, but no other lines do.
no empty lines between the date vectors and the data matrices.
the matrices contain numeric data only.

Have a look inside dat, and pick the data that you need:

>> cell2mat(cellfun(@(m)m(1,[1,2,3]),dat(:,2),'UniformOutput',false))
ans =
   1.0e+04 *
    0.6445   -2.4080   -0.8935
    0.6645   -2.2892   -1.1498

I also concatenated the matrices into mat, which lets gives you all of the matrices in one. This might be easier to access:

>> mat([1,10],[1,2,3])
ans =
   1.0e+04 *
    0.6445   -2.4080   -0.8935
    0.6645   -2.2892   -1.1498

I tested this code on both of the files that you have provided (this question, and your last question), which are also available here:

MATLAB: How to delete spaces and ‘[ ‘, ‘]’ characters from all data array string cells

Posting some example data would reduce the need to guess, what you exactly want.

CStr = {' This contains spaces ', 'This has some [ and ]'};
CStr = strrep(CStr, ' ', '');
CStr = strrep(CStr, '[', '');
CStr = strrep(CStr, ']', '');

Best Answer

Related Solutions

MATLAB: Using regexp for space delimited strings in text file.

MATLAB: How to delete spaces and ‘[ ‘, ‘]’ characters from all data array string cells

Related Question