can any one help me on this how to convert this text file into excel sheet..

this is my text file

Answer 1

[Star Strider]

Try this:

T = readtable('RD-120101-031900.txt', 'PreserveVariableNames',1);
FirstFiveRows = T(1:5,:);                                              % Sample Input Result
writetable(T, 'RD-120101-031900.xlsx');                                % Write Excel File
T2 = readtable('RD-120101-031900.xlsx', 'PreserveVariableNames',1);    % Read Excel File
FirstFiveRows2 = T2(1:5,:);                                            % Sample Input Result

See the documentation for the various functions for details on their use.

.

[surya pramod Jalakam]

thank you. but when it comes to excel the date format is changing..any how thank you soo much.

[Star Strider]

As always, my pleasure!

I did not catch the date format change. It is straightforward to change them back after you read the Excel file:

T2 = readtable('RD-120101-031900.xlsx', 'PreserveVariableNames',1);    % Read Excel File
T2.('YYYY-MM-DD').Format = 'yyyy-MM-dd';                                                    % Re-Format Date Variable

That restores them to their original format.

.

[surya pramod Jalakam]

Thank you, I have 379 files is it possible to change all them at a time with their own file names. And also have to choose a particular location to save them. I am very beginer to matlab thats why this many questions.!

[Star Strider]

As always, my pleasure!

You would have to use a loop. See: Import or Export a Sequence of Files for a detailed description. I just used the same as the original filename, changing only the extension. With respect to the location to save them, that would be a directory on your MATLAB search path. See: What Is the MATLAB Search Path? and associated links for those details.

.

[surya pramod Jalakam]

Thank you so much for your support & explanation.

[Star Strider]

As always, my pleasure!