How to delete file columns?

Question

Bruno Souza 2017-12-24

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/374357-how-to-delete-file-columns

评论： Bruno Souza 2017-12-24

I've the file below, and I would like delete the columns 2, 3 and 4. And If It's possible, put a header file "In Temp" in column 1, and "Time" in column 5.

99475    0.00000000    1     1      01.00.00
93432    0.00000000    1     1      02.00.00
95047    0.00000000    1     1      03.00.00
94692    0.00000000    1     1      04.00.00
94284    0.00000000    1     1      05.00.00
93054    0.00000000    1     1      06.00.00
91392    0.00000000    1     1      07.00.00
91620    0.00000000    1     1      08.00.00
07122    0.00000000    1     1      09.00.00
74621    0.00000000    1     1      10.00.00
82622    0.00000000    1     1      11.00.00
26688    0.00000000    1     1      12.00.00
74946    0.00000000    1     1      13.00.00
38718    0.00000000    1     1      14.00.00
84582    0.00000000    1     1      15.00.00
75560    0.00000000    1     1      16.00.00
99042    0.00000000    1     1      17.00.00
62772    0.00000000    1     1      18.00.00
07095    0.00000000    1     1      19.00.00
41968    0.00000000    1     1      20.00.00
66041    0.00000000    1     1      21.00.00
82444    0.00000000    1     1      22.00.00
97447    0.00000000    1     1      23.00.00
05386    0.00000000    1     2      00.00.00
17622    0.00000000    1     2      01.00.00
37835    0.00000000    1     2      02.00.00
70272    0.00000000    1     2      03.00.00
...

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2017-12-24

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/374357-how-to-delete-file-columns#answer_297557

在 MATLAB Online 中打开

fid = fopen('YourFile.txt', 'rt');
datacell = textscan(fid, '%s%*s%*s%*s%s', 'CollectOutput', true);
fclose(fid);
data_to_print = [{'ln Temp', 'Time'}; datacell{1}] .';  %transpose is important
fmt = '%8s%15s\n';
fid = fopen('NewFile.txt', 'wt');
fprintf(fid, fmt, data_to_print{:});
fclose(fid);

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Bruno Souza 2017-12-24

Thank you!

请先登录，再进行评论。

Answer 2

Image Analyst 2017-12-24

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/374357-how-to-delete-file-columns#answer_297556

在 MATLAB Online 中打开

Try this to have the user specify the input file and the output file and create the output file.

% Have user browse for a file, from a specified "starting folder."
% For convenience in browsing, set a starting folder from which to browse.
startingFolder = pwd;
if ~exist(startingFolder, 'dir')
  % If that folder doesn't exist, just start in the current folder.
  startingFolder = pwd;
end
% Get the name of the file that the user wants to use.
defaultFileName = fullfile(startingFolder, '*.*');
[baseFileName, folder] = uigetfile(defaultFileName, 'Select input file');
if baseFileName == 0
  % User clicked the Cancel button.
  return;
end
fullInputFileName = fullfile(folder, baseFileName)
% Have user browse for a file, from a specified "starting folder."
% For convenience in browsing, set a starting folder from which to browse.
startingFolder = pwd;
if ~exist(startingFolder, 'dir')
  % If that folder doesn't exist, just start in the current folder.
  startingFolder = pwd;
end
% Get the name of the file that the user wants to use.
defaultFileName = fullfile(startingFolder, '*.*');
[baseFileName, folder] = uiputfile(defaultFileName, 'Select output file');
if baseFileName == 0
  % User clicked the Cancel button.
  return;
end
fullOutputFileName = fullfile(folder, baseFileName)
% Open the files.
inputFileID = fopen(fullInputFileName, 'rt');
outputFileID = fopen(fullOutputFileName, 'wt');
% Write hearder line to output file.
fprintf(outputFileID, 'In Temp     Time\n');
% Read the first line of the file.
textLine = fgetl(inputFileID);
while ischar(textLine)
  % Read the remaining lines of the file.
  fprintf('%s\n', textLine);
  % Read the next line.
  textLine = fgetl(inputFileID);
  if textLine == -1
    % End of file so break
    break;
  end
  % Delete columns 9-39
  textLine(9:33) = [];
  % Write the line out to the output file.
  fprintf(outputFileID, '%s\n', textLine);
end
% All done reading all lines, so close the files.
fclose(inputFileID);
fclose(outputFileID);
% Open it in Notepad or whatever the default program for opening a text file is
winopen(fullOutputFileName);