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