MATLAB: Trim cell array from known characters

cell manipulationdata importdata processingdeblankMATLABstrtrimtrimcelltruncate cell

Hi There,

How do you trim down a cell array from a space or empty element in the cell and as well remove all commas and semi colons from data?

Variable C is a 654×1 cell containing the first four rows 1×9 cell 1×2 cell 1×29 cell 1×218 cell . . . 1×126 cell

An individual cell array contains spaces I would like to remove. Ultimately I would like to truncate this from space/empty. For example data is as follows:

{AB XY; ' ' ' ' ' ' ' ' ' 'PO,' ' ' ' ' ' SE''''LO,' ' ' ' ' ' W:,TT …} Where ' ' denotes a space/empty cell. I would like this to become {AB XY PO SE LO W TT} This will truncate the number of columns from the previous 218.

I guess I have to utilize the strtrim or deblank functions not exactly sure how.

Thank You.

Best Answer

Assuming

a = {'AB XY';'     ,    PO;';'SE ,  '}

use

regexprep( a, '[\s;,]', '')

to remove spaces, semicolons and commas, '\s' indicates any whitespace character

Related Solutions

MATLAB: Does STRMATCH in MATLAB cause an error for a cell array containing a numeric value

In this example:

str = 9;
strs = strvcat('This is a string array','with two rows');
ind = strmatch(str,strs);

the normal STRMATCH is used, since the first input is not a cell array. In this case, 9 could be used as an ASCII value, and converted to a tab character. That character can then be compared with the other strings.

In this example:

str ={9};
strs = strvcat('This is a cell array of strings','with two rows');
ind = strmatch(str,strs);

@CELL/STRMATCH will be used, since the first input is a cell array. In this case, the code checks that the cell array contains strings, and converts it to a char array:

if iscellstr(str), str = char(str); end

Cell arrays of strings are special cases of cell arrays, which are commonly used to store strings together which have different lengths, and there are many instances where cell arrays of strings and strings can be used interchangeably. However, {9} is not a cell array of strings, so it is not converted to a character array, which leads to the error being thrown by this code:

if ~ischar(str) | ~ischar(strs)
    error('Requires character array or cell array of strings as inputs.')
end

MATLAB: Cell array of nested cells

It's simply:

vertcat(cellarray{:});

Best Answer

Related Solutions

MATLAB: Does STRMATCH in MATLAB cause an error for a cell array containing a numeric value

MATLAB: Cell array of nested cells

Related Question