organize the inside of the .txt file

How can I organize the data.txt file to get the data_new.txt file?

Answer 1

[Star Strider]

Define the delimiter in your writetable call to be the tab '\t' character —

type('data.txt')

data 1,data 2,data 3
50,140,36

type('data_new.txt')

data 1	data 2	data 3
50	140	36

T1 = readtable('data.txt', 'VariableNamingRule','preserve')

T1 = 1×3 table
    data 1    data 2    data 3
    ______    ______    ______

      50       140        36  

writetable(T1, 'new_file.txt', 'Delimiter','\t')           % Write New File
type('new_file.txt')

data 1	data 2	data 3
50	140	36

I am not certain that it is possible to change the delimiter from a comma (,) to a tab except by writiing it to a new file.

EDIT — Corrected typographical errors.

.

[Alberto Acri]

Thank you for your reply. In the case where I have data_1.txt, the code does not work correctly. Can it be solved?

[Star Strider]

It appears to me to woork correctly as written —

type('data_1.txt')

data first parameter,data,software used
50,140,matlab

T1 = readtable('data_1.txt', 'VariableNamingRule','preserve')

T1 = 1×3 table
    data first parameter    data    software used
    ____________________    ____    _____________

             50             140      {'matlab'}  

writetable(T1, 'new_file.txt', 'Delimiter','\t')                    % Write New File
type('new_file.txt')

data first parameter	data	software used
50	140	matlab

T2 = readtable('new_file.txt', 'VariableNamingRule','preserve')     % Read New File (Check)

T2 = 1×3 table
    data first parameter    data    software used
    ____________________    ____    _____________

             50             140      {'matlab'}  

.

[Alberto Acri]

Thank you for your reply. The table that is generated in the matlab workspace is fine. I should save the .txt as that table. Currently, the inside of the new .txt file (saved with writetable) does not match the table created on the workspace.

type('data_1.txt');
T1 = readtable('data_1.txt', 'VariableNamingRule','preserve');
writetable(T1, 'data_new.txt', 'Delimiter','\t');

[Star Strider]

What the file contains internally is irrelevant. It only has to produce the correct result when read.

If you want it to look like that internally, use the Contact Support link to submit an enhancement request. Include the URL of this thread in your note to MathWorks.