MATLAB: Strings: delete rows with empty values

delete rowsdelete string rows

I have a very large string array (part of it is shown below), and sometimes the secound column contains "empty" values. I would like to delete each row whose second column is empty.

"laterite-00047" "" "zeros(0,1)"

"laterite-00048" "" "zeros(0,1)"

"laterite-00049" "204186,54901" "204186"

"laterite-00050" "204186,54901" "54901"

"laterite-00051" "" "zeros(0,1)"

"laterite-00052" "204186,54901" "54901"

Best Answer

a(~any(cellfun('isempty',a),2),:) % where a is your string array

Related Solutions

MATLAB: Conversion from char to cell is not possible

Despite your statement, A is not a cell array, but a 2D char array. You can convert A into a cell array of char vectors using cellstr. So:

 C = [cellstr(A), num2str(B)]

would be the simplest way to obtain what you want.

Note: Since R2016b, string is a new type different from the char arrays you're using. To avoid ambiguity use the term char array (or vector) instead of string.

MATLAB: How I can know if a string is empty or not!

How about the helpfully named isempty?:

>>isempty('aaa')
ans = 
    0
>>isempty('')
ans = 
    1

Note that because strings are just matrices (of characters), it's the same test you use for matrix emptiness.

Best Answer

Related Solutions

MATLAB: Conversion from char to cell is not possible

MATLAB: How I can know if a string is empty or not!

Related Question