Strings: delete rows with empty values

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"

[madhan ravi]

attach part of your string array as .mat file

[Stephen23]

For a string array the correct method to way to cound the number of characters is to use strlength:

https://www.mathworks.com/help/matlab/ref/strlength.html

Answer 1

[madhan ravi]

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

[madhan ravi]

Alternative (faster):

a(~strcmp(a(:,2),""),:)

[Aishwarya Venkatesh]

if i want to remove columns containing all empty values in the string. Then how this can be modified?