Convert .txt to .csv with prespecified format

9 次查看（过去 30 天）
Ancalagon8
Ancalagon8 2024-4-17
编辑： Cris LaPierre 2024-4-18
I have a seismic catalog (.txt) with this format
DATE TIME LAT. LONG. DEPTH MAGNITUDE
(GMT) (N) (E) (km) (Local)
2023 JAN 1 00 31 34.1 38.5625 23.6833 14 2.0
2023 JAN 1 00 38 24.7 38.3304 20.4172 19 1.0
2023 JAN 1 00 47 15.0 38.3940 21.9118 7 0.9
and i want to make a .csv file with the following format:
DATETIME;LAT;LONG;DEPTH;MAG
01-01-2023T00:31:34.1;38.5625;23.6833;14;2.0
01-01-2023T00:38:24.7;38.3304;20.4172;19;1.0
01-01-2023T00:47:15.0;38.3940;21.9118;7;0.9
Any help?

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

采纳的回答

Cris LaPierre
Cris LaPierre 2024-4-17
编辑：Cris LaPierre 2024-4-17
Ran in:
Assuming your input file can be duplicated by copying and pasting the text above into a text file, here is how I would do it.
  • Treat the file as a fixed-width file
  • Import the date and time as a single variable of type datetime
  • Set the display format of the datetime variable to be your desired output format
  • Set the variable names to be your desired output names
With the table formatted the way you want, use writetable to create your output file, specifying the desired delimirter.
% set up import options
opts = fixedWidthImportOptions("VariableWidths",[25,8,8,5,12],"NumVariables",5,'DataLines',3);
opts = setvartype(opts,'Var1','datetime');
opts = setvaropts(opts,"Var1",'InputFormat','yyyy MMM d HH mm ss.S','DatetimeFormat','MM-dd-yyyy''T''HH:mm:ss.S');
opts.VariableNames = ["DATETIME" "LAT" "LONG" "DEPTH" "MAG"];
% import original file
data = readtable("originalFile.txt",opts)
data = 3x5 table
DATETIME LAT LONG DEPTH MAG _____________________ ___________ ___________ ______ _______ 01-01-2023T00:31:34.1 {'38.5625'} {'23.6833'} {'14'} {'2.0'} 01-01-2023T00:38:24.7 {'38.3304'} {'20.4172'} {'19'} {'1.0'} 01-01-2023T00:47:15.0 {'38.3940'} {'21.9118'} {'7' } {'0.9'}
% create output file
writetable(data,'outputFile.txt','Delimiter',';')
Now preview the output file
type('outputFile.txt')
DATETIME;LAT;LONG;DEPTH;MAG 01-01-2023T00:31:34.1;38.5625;23.6833;14;2.0 01-01-2023T00:38:24.7;38.3304;20.4172;19;1.0 01-01-2023T00:47:15.0;38.3940;21.9118;7;0.9
  10 个评论
显示 8更早的评论
Cris LaPierre
Cris LaPierre 2024-4-18
编辑：Cris LaPierre 2024-4-18
Ran in:
The bottom of the fixedWidthImportOptions page indicates it was added in R2017a, but I can reporduce the error in R2018a, so I did some digging. It is indeed available in R2017a, but the calling syntax is different. From the R2018a doc:
Alternatively, for a messy fixed-width text file that is not automatically detected by the detectImportOptions function, create a custom FixedWidthImportOptions object:
opts = matlab.io.text.FixedWidthImportOptions
% set up import options
opts = matlab.io.text.FixedWidthImportOptions;
opts.VariableNames = {'DATETIME' 'LAT' 'LONG' 'DEPTH' 'MAG'};
opts.VariableWidths = [25,8,8,5,12];
opts.DataLines = 3;
opts = setvartype(opts,'DATETIME','datetime');
opts = setvaropts(opts,'DATETIME','InputFormat','yyyy MMM d HH mm ss.S','DatetimeFormat','MM-dd-yyyy''T''HH:mm:ss.S');
% import original file
data = readtable('data.txt',opts)
data = 3x5 table
DATETIME LAT LONG DEPTH MAG _____________________ ___________ ___________ ______ _______ 01-01-2023T00:31:34.1 {'38.5625'} {'23.6833'} {'14'} {'2.0'} 01-01-2023T00:38:24.7 {'38.3304'} {'20.4172'} {'19'} {'1.0'} 01-01-2023T00:47:15.0 {'38.3940'} {'21.9118'} {'7' } {'0.9'}
% create output file
writetable(data,'outputFile.txt','Delimiter',';')
Now preview the output file
type('outputFile.txt')
DATETIME;LAT;LONG;DEPTH;MAG 01-01-2023T00:31:34.1;38.5625;23.6833;14;2.0 01-01-2023T00:38:24.7;38.3304;20.4172;19;1.0 01-01-2023T00:47:15.0;38.3940;21.9118;7;0.9

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Dates and Time 的更多信息

标签

产品


版本

R2018a

Community Treasure Hunt

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

Start Hunting!

Translated by