Problem with reading text file and making changes

Question

GEORGIOS BEKAS 2018-1-2

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/375209-problem-with-reading-text-file-and-making-changes

编辑： Guillaume 2018-1-3

I have a file in a txt format with the following data

584547.75  4052042.76
584543.25  4052030.13
584542.06  4052009.10
584556.55  4052005.46
584565.18  4052000.66
584576.33  4051992.03
584594.05  4051981.91
584599.05  4051986.77
584609.27  4052003.61
584604.24  4052007.05
584603.98  4052020.41
584602.32  4052021.53
584605.89  4052029.20
584601.43  4052036.84
584597.00  4052041.34
584584.83  4052048.62
584576.23  4052056.49
584569.15  4052051.59
584555.92  4052047.8

I want to know through which commands, it can be openned, so as to abolish the first row and so as for a comma to be put between the second and the third column. I started with the following code:

fileID = fopen(C:\Users\GB\Desktop\topo);
c = textscan(fileID,'%f %f %f')

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

GEORGIOS BEKAS 2018-1-3

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/375209-problem-with-reading-text-file-and-making-changes#answer_298545

在 MATLAB Online 中打开

I have found the answer:

M = dlmread('C:\Users\G\Desktop\topo.txt','  '); %replace path as appropriate 
M(:,1) = []
dlmwrite('C:\Users\G\Desktop\myfile.txt',M,',')

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Guillaume 2018-1-3

编辑：Guillaume 2018-1-3

"I have found the answer"

... to a different question than you asked. The above will put a comma between all the columns not just "between the second and the third column" as you asked.

请先登录，再进行评论。

Answer 2

Guillaume 2018-1-2

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/375209-problem-with-reading-text-file-and-making-changes#answer_298387

在 MATLAB Online 中打开

If I understood correctly:

filecontent = fileread('C:\somewhere\somefile.txt'); %replace path as appropriate
filecontent = regexprep(filecontent, '.*[\n\r]+', '', 'once', 'dotexceptnewline');   %remove first line
filecontent = regexprep(filecontent, '(\s+)([0-9.]+\r?)$', ',$2', 'lineanchors'); %replace whitespaces by , before last column
fid = fopen('C:\somewhere\newfile.txt', 'w');  %replace path as appropriate
assert(fid > 0, 'failed to open file for writing');
fwrite(fid, filecontent);
fclose(fid);