Import not consistent table data
1 回表示 (過去 30 日間)
古いコメントを表示
Hi! Sorry again for a (maybe) naif question, but I have been struggling all day trying to figure out how I can import a not consistent .txt dataset. I show you in figure what I mean:
From that, I just need to extract the column with inside the blu limiters. I tried to set import option and get the column where those numbers are in by the following code:
opts = detectImportOptions(sample_txt_file);
disp([opts.VariableNames' opts.VariableTypes']);
opts = setvartype(opts,{'x1100071'},'char');
disp([opts.VariableNames' opts.VariableTypes']);
values = readtable(sample_txt_file,opts);
times = values{:,4};
As result, I got 4 table columns and then I extracted the last one, the one with numbers I need.
Checking on how I could change 'char' values into a numeric array I coded:
S = sprintf('%s',times{:});
D = sscanf(S, '%f');
So I got an array containing number values of all those from column 4 but still don't understand how it works or if there are more suitable ways to extract data from that dataset.
Hope you could help me and thank you again :)
3 件のコメント
採用された回答
Mathieu NOE
2022 年 11 月 18 日
hello again
so this first simple code will extract the data as one single block
if you need to separate the data in individual blocks as organized in your file , that needs a bit of extra code but shoudn't be very difficult :
str = readlines('samples.txt');% read the file:
C = regexp(str,' MODfromPPD:: PARA:'); % find lines that contains that string
ind = find(~cellfun('isempty',C)); % indice of non empty cells
data_lines = split(str(ind)); % split columns of selected rows
your_data = str2double(data_lines(:,7)); % your data are in the 7th column of data_lines
3 件のコメント
Mathieu NOE
2022 年 11 月 18 日
yes , it takes some time to figure out how to deal with the multiple file formats , but after some time you go faster as you get more experienced.
also this forum is a good place to ask and learn from other's Q & A
その他の回答 (0 件)
参考
カテゴリ
Help Center および File Exchange で Logical についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!