how to obtain comma delimited output

Hello; I am inexperienced in coding. can anyone help me please about my attached file. I would like to transpose some some data with a specific format in txt. The data may vary but i have made an example for you to understand it with an example output. The data in sheets and number of sheets in csv may change based on data i have. In attached csv file there is only one sheet for first set, however there are some other sheet in same format, but i could not add to csv file as multiple sheets. Any kind of help is appreciated. Thank you

[Image Analyst]

csv files can't have "sheets" since they're just flat text files. Only .xlsx files can have sheets.

Answer 1

[Walter Roberson]

S = fileread('input.csv');
newS = regexprep(S, {'^\*PART[^\n]*\n', '^(\d)'}, {'', '*PART\r\n$1'}, 'lineanchors');

fid = fopen('sample output.txt', 'w');
fwrite(fid, newS);
fclose(fid)

[Muhsin]

Dear Walter; Can I use .xlsx instead of .csv in excel file? Also , I have more than on sheet in excel file in same format. Does this affect your code ? Thank you

[Walter Roberson]

in_filename = 'input.xlsx';
[filepath, basename, ext] = fileparts(in_filename);

[status, sheets] = xlsfinfo(in_filename);
if isempty(status)
  error('file "%s" is not a readable excel sheet', in_filename);
end

out_dir = fullfile(filepath, [basename, '_sheets']);
if ~exist(outdir, 'dir')
  try
     [status, msg] = mkdir(outdir);
     if ~status
       error('Could not create output directory "%s" because "%s"', outdir, msg);
     end
  catch ME
     error('Could not create output directory "%s"', outdir);
  end
end

fprintf('Output is in directory: "%s"\n', outdir);

for idx = 1 : length(sheets)
  thissheet = sheets{idx};
  num = xlsread(in_filename, thissheet);
  numcols = size(num, 2);
  fmt = ['*PART\n', repmat('%f,', 1, numcols-1), '%f\n'];
  outfile = fullfile(outdir, [thissheet '.txt']);
  [fid, msg] = fopen(outfile, 'wt');
  if fid < 0
    error('Failed to open output file "%s" because "%s"', outfile, msg);
  end
  fprintf(fid, fmt, num.' );   %transpose is important
  fclose(fid);
end

[Muhsin]

Dear Walter; The data in output has decimals. Can you please tell me how I can remove those decimals and gatter all output data in one txt file please? Thank you very much

[Walter Roberson]

You can change the

    fmt = ['*PART\n', repmat('%f,', 1, numcols-1), '%f\n'];

line to use %d instead of %f

How do you want the sheets to be separated from each other in the text file? Or should the information for all of the sheets be put together without indicating which sheet it is from?

[Muhsin]

it is not important to have the information of sheets in the data. I just want it have all the data in one txt file. Thank you

[Walter Roberson]

in_filename = 'input.xlsx';
out_filename = 'output.txt';

[filepath, basename, ext] = fileparts(in_filename);

[status, sheets] = xlsfinfo(in_filename);
if isempty(status)
  error('file "%s" is not a readable excel sheet', in_filename);
end

allnum = [];

for idx = 1 : length(sheets)
  thissheet = sheets{idx};
  num = xlsread(in_filename, thissheet);
  allnum = [allnum; num];
end

numcols = size(allnum, 2);
fmt = ['*PART\n', repmat('%f,', 1, numcols-1), '%f\n'];

[fid, msg] = fopen(out_filename, 'wt');
if fid < 0
    error('Failed to open output file "%s" because "%s"', outfile, msg);
end

fprintf(fid, fmt, allnum.' );   %transpose is important
fclose(fid);