processing a file but keeping blank lines intact
显示 更早的评论
Hello,
I have a script that takes a file which contains 2 columns of data (in scientific notation), then subtracts a constant value from the first column, in order to commensate for a glitch in our machine which makes the measuremetns. A new file is then produced with the new values.
However, the original file contains blank lines throughout the sequence, and the new file does not.
How do I add a line into the script that tells it to keep blank lines?
Is this possible?
Thank you!
4 个评论
dpb
2023-9-27
Almost anything is possible, but to have a klew as to how to do your particulary anything we'd have to see at least the processing code you have...
The issue revolves about having numeric data and blanks together in a numeric array -- they can't coincide. Probably the best way to go at it would be to read with a function that has the facility to indicate missing values -- they'll then be NaN which are easy enough to deal with; then to rewrite the file convert to cellstr array and replace the NaN with the empty string.
Alternatively, if you were to process line by line, you could simply test that the given line is empty and echo it back out to the file unchanged while processing those which do have data before rewriting them.
Again, "it all depends"; as per usual, it would help to see a small(ish) sample file that contains the problem/feature for folks to poke at ...
Christina Verhagen
2023-9-29
Walter Roberson
2023-9-29
Please post code rather than pictures of code. We cannot execute pictures of code.
Voss
2023-9-29
@Christina Verhagen: I've modified my answer to work with your example file, please try to run it and see if it does what you want.
采纳的回答
Here's one way:
input_file = 'file.txt';
output_file = 'file_modified.txt';
constant_offset = 100;
input_format = "%f,%f"; % modify this to match your file's format for reading
output_format = '%+.6E,%+.6E'; % modify this to try to match your file's format for writing
type(input_file); % show the original file's contents
L = readlines(input_file);
has_numbers = false(numel(L),1);
M = zeros(0,2);
for ii = 1:numel(L)
vals = textscan(L(ii),input_format);
vals = [vals{:}];
if numel(vals) == 2
has_numbers(ii) = true;
M(end+1,:) = vals;
end
end
M(:,1) = M(:,1)-constant_offset;
L(has_numbers) = compose(output_format,M);
writelines(L,output_file);
type(output_file); % show the modified file's contents
更多回答（1 个）
Walter Roberson
2023-9-27
编辑：Walter Roberson
2023-9-27
ConstantOffset = as appropriate;
filename_in = 'as appropriate';
filename_out = 'as appropriate preferably not the same';
C = readcell(filename_in);
mask = cellfun(@(V) isnumeric(V) && ~isempty(V), C(:,1));
C(mask) = cellfun(@(V)V-constant_offset, C(mask,1), 'uniform', 0);
writecell(C, filename_out);
类别
在 帮助中心 和 File Exchange 中查找有关 Data Type Identification 的更多信息
产品
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
