Find a specific value(word) in csv file
4 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
In this csv file
I want to extract specific section(ex.2022) in Part 1 and "D" value(ex.1) in Part 2
Finally I want to extract it
2022 1
2021 2
2020 3
2019 4
2018 5
0 comentarios
Respuestas (1)
Voss
el 16 de Jul. de 2022
Editada: Voss
el 16 de Jul. de 2022
C = readcell('table_data (1).csv', ...
'Delimiter','\t', ...
'NumHeaderLines',1)
years = regexp(C(:,1),'/(\d{4})','tokens','once');
years = vertcat(years{:})
d = regexp(C(:,2),'"D":"(\d+)"','tokens','once');
d = vertcat(d{:})
% result as a cell array of character vectors:
result = [years d]
% or, result as a numeric matrix:
result = str2double([years d])
0 comentarios
Ver también
Categorías
Más información sobre String Parsing en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!