Extract data from a cell contains of alphabet and number

6 次查看（过去 30 天）
K3iTH
K3iTH 2021-6-10
编辑： Stephen23 2021-6-10
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 个评论
Stephen23
Stephen23 2021-6-10
编辑：Stephen23 2021-6-10
@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?

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

Stephen23
Stephen23 2021-6-10
编辑：Stephen23 2021-6-10
Ran in:
"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
  2 个评论
Image Analyst
Image Analyst 2021-6-10
@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

请先登录，再进行评论。

更多回答（1 个）

KSSV
KSSV 2021-6-10
编辑：KSSV 2021-6-10
idx = loc+1 ;
iwant = cell2mat(C{idx})
  2 个评论
K3iTH
K3iTH 2021-6-10
Hi, I have tried your method but it shows the error
Operator '+' is not supported for
operands of type 'cell'.
Thanks
KSSV
KSSV 2021-6-10
You have the indices loc, using these indices you can try extracting cell.

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Text Data Preparation 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by