Filter löschen
Filter löschen

Problem with reading text file and making changes

1 Ansicht (letzte 30 Tage)
GEORGIOS BEKAS
GEORGIOS BEKAS am 2 Jan. 2018
Bearbeitet: Guillaume am 3 Jan. 2018
I have a file in a txt format with the following data
0 584547.75 4052042.76
1 584543.25 4052030.13
2 584542.06 4052009.10
3 584556.55 4052005.46
4 584565.18 4052000.66
5 584576.33 4051992.03
6 584594.05 4051981.91
7 584599.05 4051986.77
8 584609.27 4052003.61
9 584604.24 4052007.05
10 584603.98 4052020.41
11 584602.32 4052021.53
12 584605.89 4052029.20
13 584601.43 4052036.84
14 584597.00 4052041.34
15 584584.83 4052048.62
16 584576.23 4052056.49
17 584569.15 4052051.59
18 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')

Akzeptierte Antwort

GEORGIOS BEKAS
GEORGIOS BEKAS am 3 Jan. 2018
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 Kommentar
Guillaume
Guillaume am 3 Jan. 2018
Bearbeitet: Guillaume am 3 Jan. 2018
"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.

Melden Sie sich an, um zu kommentieren.

Weitere Antworten (1)

Guillaume
Guillaume am 2 Jan. 2018
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);

Kategorien

Mehr zu Data Import and Export finden Sie in Help Center und File Exchange

Produkte

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by