Strings: delete rows with empty values

26 visualizaciones (últimos 30 días)
Matthew Tyler Jeffries
Matthew Tyler Jeffries el 25 de Feb. de 2019
Comentada: Stephen23 el 14 de Jul. de 2020
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 comentarios
madhan ravi
madhan ravi el 25 de Feb. de 2019
attach part of your string array as .mat file
Stephen23
Stephen23 el 14 de Jul. de 2020
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

Iniciar sesión para comentar.

Iniciar sesión para responder a esta pregunta.

Respuesta aceptada

madhan ravi
madhan ravi el 25 de Feb. de 2019
a(~any(cellfun('isempty',a),2),:) % where a is your string array
  2 comentarios
madhan ravi
madhan ravi el 25 de Feb. de 2019
Alternative (faster):
a(~strcmp(a(:,2),""),:)
Aishwarya Venkatesh
Aishwarya Venkatesh el 14 de Jul. de 2020
if i want to remove columns containing all empty values in the string. Then how this can be modified?

Iniciar sesión para comentar.

Más respuestas (0)

Categorías

Más información sobre Characters and Strings en Help Center y File Exchange.

Etiquetas

Community Treasure Hunt

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

Start Hunting!

Translated by