convert char to table or cell

Question

Nurfaiz Fathurrahman 2023-3-17

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1930375-convert-char-to-table-or-cell

回答： 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

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

请先登录，再进行评论。

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

Answer 1

Vilém Frynta 2023-3-17

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1930375-convert-char-to-table-or-cell#answer_1194950

在 MATLAB Online 中打开

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 个评论
显示 -1更早的评论隐藏 -1更早的评论

Nurfaiz Fathurrahman 2023-3-19

thank you

请先登录，再进行评论。

Answer 2

Stephen23 2023-3-19

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1930375-convert-char-to-table-or-cell#answer_1196065

在 MATLAB Online 中打开

data.txt

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