How to replace specific text in .csv file

48 次查看（过去 30 天）

显示更早的评论

Daniel Berveiller 2021-1-27

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/728593-how-to-replace-specific-text-in-csv-file

评论： per isakson 2021-1-29

采纳的回答： per isakson

I have a lot of "NAN" in a .csv as following :

"2020-01-03 05:00:00",7094,-0.0333308,-0.5147614,-0.8675244,38.42,0,6.799,0.508,-1,0,-1

"2020-01-03 05:30:00",7095,"NAN","NAN","NAN",38.42,1.216,6.799,0.508,-1,0,-1

"2020-01-03 06:00:00",7096,0,0,0,38.61,0,6.833,0.505,-1,0,-1

How can I replace "NAN" by -9999. I tried using eg Notepad++ but it does not recognize the quotes ! It would be nice to have a matlab code to do that automaticaly cause I have a lot of simlar files.

Thanks

采纳的回答

per isakson 2021-1-27

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/728593-how-to-replace-specific-text-in-csv-file#answer_607658

编辑：per isakson 2021-1-29

在 MATLAB Online 中打开

Another approach, which avoids conversion to numerical and back to text. (And, I think, works with R2006 and later releases.)

%%
chr = fileread('test.csv');
chr = strrep( chr, '"NAN"', '-9999' );
fid = fopen( 'test.csv', 'w' ); 
fprintf( fid, '%s', chr );
fclose( fid );
type test.csv

outputs

"2020-01-03 05:00:00",7094,-0.0333308,-0.5147614,-0.8675244,38.42,0,6.799,0.508,-1,0,-1
"2020-01-03 05:30:00",7095,-9999,-9999,-9999,38.42,1.216,6.799,0.508,-1,0,-1
"2020-01-03 06:00:00",7096,0,0,0,38.61,0,6.833,0.505,-1,0,-1

In response to comment

% ** Datafile to work on
ficin='file.dat'; 
% Noun of output file
idot=strfind(ficinOK,'.');
ficout=strcat(ficin(1:(idot-1)),'_OK',ficin(idot:end)); %fichier produit par le script
% Find any "NAN" and replace by -9999
chr = fileread(ficin);              % read from "Datafile to work on"
chr = strrep( chr,'"NAN"','-9999'); % replace any "NAN" by -9999
fid = fopen(ficout,'w');            
fprintf(fid,'%s',chr);              % write to output file
fclose(fid);
% Import data                       % read from output file
data = importdata( ficout );

Importing data from files is a pain. That's the reason why The MathWorks continuously adds new data reading functions/features. importdata is supposed to be smart, but with your sample file it only produces a mess (when used by me). It has something to do with the lines 2,3,4. I cannot care. This old time function does the job.

%%
ffs = 'D:\m\cssm\2020_B_HTGSoil-2_Soil_GfluxP5_test.txt';
fid = fopen( ffs );
cac = textscan( fid, '%q%f%f%f%f%f%f%f%f%f%f%f', 'CollectOutput',true   ...
            , 'HeaderLines',4, 'Delimiter',',', 'TreatAsEmpty','"NAN"'  ...
            , 'EmptyValue', -9999 );
[~] = fclose( fid );