csv file to text file

3 vues (au cours des 30 derniers jours)
YOGITAA YOGITAA
YOGITAA YOGITAA le 29 Sep 2022
Modifié(e) : Jan le 29 Sep 2022
Hi ,
I want to generate a text file for the chosen csv file by extracting some values from the specific index and not to read the whole csv.
Please let me know
Thanks in advance :)
  1 commentaire
KSSV
KSSV le 29 Sep 2022
How the csv file and what data you want to extract.

Connectez-vous pour commenter.

Réponses (1)

Jan
Jan le 29 Sep 2022
Modifié(e) : Jan le 29 Sep 2022
% [UNTESTED CODE!]
function Value = GetCSVElement(File, R, C)
% INPUT: File: File name
% R: Row index of wanted element. 1 row for the header assumed.
% C: Column index of wanted element
[fid, msg] = fopen(File, 'r');
assert(fid > 0, msg);
for k = 1:R + 1
s = fgetl(fid);
end
fclose(fid);
if isequal(s, -1)
error('File %s has less than %d rows.', File, R);
end
V = strsplit(s, ',');
if numel(V) < C
error('Row %d of file %s has less than %d columns.', R + 1, File, C);
end
Value = sscanf(V{C}, '%g');
end

Catégories

En savoir plus sur Text Data Preparation dans Help Center et File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by