Borrar filtros
Borrar filtros

convert char to table or cell

53 visualizaciones (últimos 30 días)
Nurfaiz Fathurrahman
Nurfaiz Fathurrahman el 17 de Mzo. de 2023
Respondida: Stephen23 el 19 de Mzo. de 2023
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

Respuesta aceptada

Vilém Frynta
Vilém Frynta el 17 de Mzo. de 2023
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'});

Más respuestas (1)

Stephen23
Stephen23 el 19 de Mzo. de 2023
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

Categorías

Más información sobre Data Type Conversion en Help Center y File Exchange.

Etiquetas

Productos


Versión

R2018a

Community Treasure Hunt

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

Start Hunting!

Translated by