How to read alphanumeric(alphabetic+numeric) columns to MatLab?

Question

Chathu 2015-1-12

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/169613-how-to-read-alphanumeric-alphabetic-numeric-columns-to-matlab

评论： Chathu 2015-1-14

I want to read data from a 'txt' file to MatLab. Please note that 3 columns of this 'txt' file consist of numerical values and the remaining column is an alphanumeric column (eg: 01f500000309, 01f50000030a ). I want to extract all those 4 columns to MatLab with their headers. I tried tblread,tblwrite but none of them worked. Any suggestions?

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Stephen23 2015-1-14

Your comments to Per Isakson's answer indicate that it really would be simpler if you uploaded the data file, or a shortened version of it, so that we can try it for ourselves. Please make a comment here (to your question), with an upload of the data file.

请先登录，再进行评论。

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

Answer 1

per isakson 2015-1-12

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/169613-how-to-read-alphanumeric-alphabetic-numeric-columns-to-matlab#answer_164622

编辑：per isakson 2015-1-14

在 MATLAB Online 中打开

Try textscan

    fid = fopen( 'cssm.txt' );
    cac = textscan( fid, '%f%f%s'          ...
                  , 'CollectOutput', true  ...
                  , 'Delimiter'    , ','   );
    [~] = fclose( fid );

where cssm.txt contains

     1, 2, 01f500000309
     3, 4, 01f50000030a

&nbsp

    >> cac{:}
    ans =
         1     2
         3     4
    ans = 
        '01f500000309'
        '01f50000030a '

&nbsp

and see textscan, Read formatted data from text file or string

&nbsp

Addendum

    fid = fopen( 'cssm.txt' );
    hdr = textscan( fid, '%s%s%s%s', 1     ... 
                  , 'CollectOutput', true  ...
                  , 'Delimiter'    , ','   );
    cac = textscan( fid, '%f%f%f%s'        ...
                  , 'CollectOutput', true  ...
                  , 'Delimiter'    , ','   );
    [~] = fclose( fid );
    hdr{:}
    cac{:}

outputs

    ans = 
        'Num1'    'Num2'    'Num3'    'Char1 '
    ans =
        17     1     2
        18     3     4
    ans = 
        '01f500000309'
        '01f50000030a'

where cssm.txt contains

    Num1,Num2,Num3,Char1 
    17,  1, 2, 01f500000309
    18,  3, 4, 01f50000030a

&nbsp

Second addendum

    >> importdata cssm.txt
    ans = 
        'Num1 Num2 Char1  ABCDEFGHIJK  ABCDEFGH  ABCDEF  ABCDEFGH '
        '1  2  xxxxxxxxxxxx  192.168.20.2  UDP  60  01f600000234'
        '3  4  yyyyyyyyyyyy  192.168.20.2  UDP  60  01f600000234'

The script below outputs

    ans = 
        'ABCDEFGHIJK'    'ABCDEFGH'    'ABCDEF'    'ABCDEFGH'
    ans = 
        '192.168.20.2'    'UDP'
        '192.168.20.2'    'UDP'
    ans =
        60
        60
    ans = 
        '01f600000234'
        '01f600000234'
    >>
    fid = fopen( 'cssm.txt' );
    hdr = textscan( fid,'%*s%*s%*s%s%s%s%s', 1 ... 
                    ,   'CollectOutput', true  );
    cac = textscan( fid,'%*s%*s%*s%s%s%f%s', inf ... 
                    ,   'CollectOutput', true  );
    [~] = fclose( fid );
    hdr{:}
    cac{:}

where cssm.txt contains

    Num1 Num2 Char1  ABCDEFGHIJK  ABCDEFGH  ABCDEF  ABCDEFGH 
    1  2  xxxxxxxxxxxx  192.168.20.2  UDP  60  01f600000234
    3  4  yyyyyyyyyyyy  192.168.20.2  UDP  60  01f600000234

6 个评论
显示 4更早的评论隐藏 4更早的评论

per isakson 2015-1-14

编辑：per isakson 2015-1-14

@Chathu, Still confused about what you have and what you want, I have added another example based on your recent comment. That should be enough for you to solve your problem with the help of the documentation on textscan. If you have the Stat Toolbox you might want to look at dataset

Chathu 2015-1-14

@Stephen- got your point. Thanks for your reply.

@per isakson- thank you so much for your responses. Really admire your continuous support. Actually, my data set is huge. I would have emailed you the data set rather than elaborating it. I really apologize for confusing you.

"textscan" (as mentioned in the 2nd addendum ) worked quite closer to my interest. Thanks a million for your guidance.

请先登录，再进行评论。