Extract data from a cell contains of alphabet and number
6 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Hi all, I have read the contents from file and I have a cell which contians 10133x1 cell array. The cell array contains of letter and number. I have strfind function to find the position of the letter, z and I want to extract all the number below the position of z to be a 1d array. Any tips and suggestions is appreciated. I have attached the example of the data.
My code is looks like below,
inputfile = sprintf('read_data','r'); %'r' = read
fileID = fopen(inputfile,'r');
C = textscan(fileID, '%s');
loc = strfind(C{1}(:), 'z');
1 commentaire
Réponse acceptée
Stephen23
le 10 Juin 2021
Modifié(e) : Stephen23
le 10 Juin 2021
"I have read the contents from file and I have a cell which contians 10133x1 cell array. The cell array contains of letter and number."
This does not seem like a very efficient way to import that data. I doubt that STRFIND is suitable for this task:
Here is a simple and very efficient approach which does not read the entire file as text:
[fid,msg] = fopen('Example.txt','rt');
assert(fid>=3,msg)
fscanf(fid,'%[^z]');
fscanf(fid,'z');
vec = fscanf(fid,'%f')
fclose(fid);
unique(vec) % in case anyone wonders, yes those values repeat in the file!
Alternatively, if you really want to import the filedata as text:
str = fileread('Example.txt');
vec = sscanf(regexprep(str,'^.+z',''),'%f')
unique(vec) % in case anyone wonders, yes those values repeat in the file!
2 commentaires
Image Analyst
le 10 Juin 2021
@K3iTH, let me be even more direct. Please attach your text file with the paperclip icon. Or attach your .mat file with your cell array stored inside it.
Voir également
Catégories
En savoir plus sur Text Data Preparation 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!