Extract data from a cell contains of alphabet and number

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');

[Stephen23]

@K3iTH: What does this line of code actually do?:

inputfile = sprintf('read_data','r'); %'r' = read

Why did you add a superfluous 'r' which gets ignored? What does that misleading comment refer to?

Answer 1

[Stephen23]

"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:

https://xyproblem.info

https://en.wikipedia.org/wiki/XY_problem

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')

vec = 41×1

0.913545457642601 0.913545457642601 0.913545457642601 0.913545457642601 0.913545457642601 0.913545457642601 0.913545457642601 0.913545457642601 0.913545457642601 0.913545457642601

fclose(fid);
unique(vec) % in case anyone wonders, yes those values repeat in the file!

ans = 3×1

0.309016994374947 0.669130606358858 0.913545457642601

Alternatively, if you really want to import the filedata as text:

str = fileread('Example.txt');
vec = sscanf(regexprep(str,'^.+z',''),'%f')

vec = 41×1

0.913545457642601 0.913545457642601 0.913545457642601 0.913545457642601 0.913545457642601 0.913545457642601 0.913545457642601 0.913545457642601 0.913545457642601 0.913545457642601

unique(vec) % in case anyone wonders, yes those values repeat in the file!

ans = 3×1

0.309016994374947 0.669130606358858 0.913545457642601

[Image Analyst]

@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.

TUTORIAL: How to ask a question (on Answers) and get a fast answer

[K3iTH]

Hi there. I have attache an example text file. Thanks

Answer 2

[KSSV]

idx = loc+1 ; 
iwant = cell2mat(C{idx})

[K3iTH]

Hi, I have tried your method but it shows the error

Operator '+' is not supported for
operands of type 'cell'.

Thanks

[KSSV]

You have the indices loc, using these indices you can try extracting cell.