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"

2 个评论

attach part of your string array as .mat file
For a string array the correct method to way to cound the number of characters is to use strlength:

请先登录,再进行评论。

 采纳的回答

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

2 个评论

Alternative (faster):
a(~strcmp(a(:,2),""),:)
if i want to remove columns containing all empty values in the string. Then how this can be modified?

请先登录,再进行评论。

更多回答(0 个)

类别

帮助中心File Exchange 中查找有关 Characters and Strings 的更多信息

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by