split value in single cell

Given a txt file, there are numbers in a single cell, eg. 2.02208101128e+11

and there are columns for that.

I want to make it into 5 columns so it will be 2022 08 10 11 28

How can I do that?

Answer 1

[Image Analyst]

You forgot to attach your text file.

About all I can guess is this

% Extract the contents of the cell.  The contents are presumably a character array.
cellContents = yourCellArray{index};
% Split apart character array and put into different columns
t{row, 1} = strrep(cellContents(1:5), '.', '');
t{row, 2} = cellContents(6:7);
t{row, 3} = cellContents(8:9);
t{row, 4} = cellContents(10:11);
t{row, 5} = cellContents(12:13);

If you have any more questions, then attach your data and code to read it in with the paperclip icon after you read this:

TUTORIAL: How to ask a question (on Answers) and get a fast answer

[zhi cheng]

thank you for your reply

given 3 different text file(52560 x 2 double)

example: txt 1 : 2.02209101558e+11 3.9798

2.02021031210e+11 4.3032

........

txt 2 : 2.02209101558e+11 5.1234

2.02021031210e+11 6.9876

.........

txt 2 : 2.02209101558e+11 1.2345

2.02021031210e+11 9.2468

.........

I want to make a new matrix(52560 x 8) : 2022 09 10 15 58 3.9798 5.1234 1.2345

2020 03 21 12 10 4.3032 6.9876 9.2468

[Image Analyst]

This should work:

% Get a list of files
filePattern = fullfile(pwd, 'text f*.txt');
fileList = dir(filePattern);
numFiles = numel(fileList)
for fileNumber = 1 : numFiles
    % Read in this particular file.
    fullFileName = fullfile(fileList(fileNumber).folder, fileList(fileNumber).name);
    fprintf('Reading in file #%d of %d.\n', fileNumber, numFiles);
    data = readmatrix(fullFileName);
    [rows, columns] = size(data);
    if fileNumber == 1
        % Declare output array with the number of rows that the first file has.
        outDates = zeros(rows, 5);
        rows1 = rows;
        columns1 = columns;
    end
    % See that this file has the same number of rows and columns as the first file.
    if rows ~= rows || (columns ~= columns1)
        warningMessage = sprintf('Warning: this file does not match the first one:\n"%s"', fullFileName)
        uiwait(warndlg(warningMessage));
        % Skip it since something is wrong.
        continue;
    end
    for row = 1 : rows
        str = sprintf('%.15f', data(row, 1));
        % Split apart character array and put into different columns
        outDates(row, 1) = str2double(str(1:5));
        outDates(row, 2) = str2double(str(6:7));
        outDates(row, 3) = str2double(str(8:9));
        outDates(row, 4) = str2double(str(10:11));
        outDates(row, 5) = str2double(str(12:13));
        outDates(row, fileNumber+5) = data(row, 2);
    end
end
message = sprintf('Done processing %d files.', numFiles);
fprintf('%s\n', message);
uiwait(helpdlg(message))

[zhi cheng]

it works, thank you so much!