How do I read out a specific string/value out of one excel cell
2 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Benedikt Friedl
le 5 Oct 2021
Réponse apportée : Geoff Hayes
le 5 Oct 2021
Hi,
I want to lable my x-axis with a string from a excle cell. My problem is that in that specific cell are more then one strings. So e.g. in my cell 'A14' is "house, garden, dog", all seperated with a comma and I just want to have the string "garden" to lable my x-axis.
hope you can help me
0 commentaires
Réponse acceptée
Geoff Hayes
le 5 Oct 2021
@Benedikt Friedl - take the cell data which is the comma-separated string and then use split to split the string at the commas:
myString = 'house,garden,dog';
splitStringArray = split(myString, ',');
xLabel = splitStringArray{2}
0 commentaires
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Produits
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!