convert char to table or cell

22 次查看（过去 30 天）
Nurfaiz Fathurrahman
回答： Stephen23 2023-3-19
i have char below separated by '|'
#Network | Station | Latitude | Longitude | Elevation | SiteName | StartTime | EndTime
AU|XMI|-10.4495|105.689499|277.7|Christmas Island Airport, Australia|2007-11-19T00:00:00.0000|2008-10-14T00:00:00.0000
AU|XMI|-10.4501|105.6884|252.0|Christmas Island Airport|2008-10-14T00:00:00.0000|
AU|XMIS|-10.4807|105.651901|243.5|Christmas Island, Australia|2005-08-16T00:00:00.0000|2008-07-29T00:00:00.0000
AU|XMIS|-10.4807|105.652|210.0|Christmas Island Grants Well|2008-07-29T00:00:00.0000|
DW|LEM|-6.8333|107.616699|1252.0|Lembang, Indonesia|1982-06-02T00:00:00.0000|1988-11-06T00:00:00.0000
GE|BKB|-1.2558|116.915497|0.0|GEOFON Station Balikpapan, Kalimantan, Indonesia|2005-12-06T00:00:00.0000|2009-06-08T00:00:00.0000
GE|BKB|-1.1073|116.9048|110.0|GEOFON Station Balikpapan, Kalimantan, Indonesia|2009-06-09T00:00:00.0000|
how to convert to table or cell ?
thanks

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

采纳的回答

Vilém Frynta
Vilém Frynta 2023-3-17
Something like this should work. It would be easier to work with it you attached the file so we can work with it.
Hope I helped.
% Define the format of the data
formatSpec = '%s %s %f %f %f %q %s %s';
% Read the data using textscan with the format you defined
data = textscan(fid, formatSpec, 'Delimiter', '|', 'HeaderLines', 1);
fclose(fid);
% Convert the cell array to a table
table_data = table(data{1}, data{2}, data{3}, data{4}, data{5}, data{6}, data{7}, data{8}, ...
'VariableNames', {'Network', 'Station', 'Latitude', 'Longitude', 'Elevation', 'SiteName', 'StartTime', 'EndTime'});

更多回答（1 个）

Stephen23
Stephen23 2023-3-19
Ran in:
T = readtable('data.txt', 'Delimiter','|', 'VariableNamingRule','preserve')
T = 7×8 table
#Network Station Latitude Longitude Elevation SiteName StartTime EndTime ________ ________ ________ _________ _________ ____________________________________________________ _______________________ _______________________ {'AU'} {'XMI' } -10.45 105.69 277.7 {'Christmas Island Airport, Australia' } 2007-11-19T00:00:00.000 2008-10-14T00:00:00.000 {'AU'} {'XMI' } -10.45 105.69 252 {'Christmas Island Airport' } 2008-10-14T00:00:00.000 NaT {'AU'} {'XMIS'} -10.481 105.65 243.5 {'Christmas Island, Australia' } 2005-08-16T00:00:00.000 2008-07-29T00:00:00.000 {'AU'} {'XMIS'} -10.481 105.65 210 {'Christmas Island Grants Well' } 2008-07-29T00:00:00.000 NaT {'DW'} {'LEM' } -6.8333 107.62 1252 {'Lembang, Indonesia' } 1982-06-02T00:00:00.000 1988-11-06T00:00:00.000 {'GE'} {'BKB' } -1.2558 116.92 0 {'GEOFON Station Balikpapan, Kalimantan, Indonesia'} 2005-12-06T00:00:00.000 2009-06-08T00:00:00.000 {'GE'} {'BKB' } -1.1073 116.9 110 {'GEOFON Station Balikpapan, Kalimantan, Indonesia'} 2009-06-09T00:00:00.000 NaT

类别

在 Help Center 和 File Exchange 中查找有关 Large Files and Big Data 的更多信息

标签

产品


版本

R2018a

Community Treasure Hunt

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

Start Hunting!

Translated by