Sorting data extracted from the name of a group of files

Question

Peter 2014-12-29

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/168393-sorting-data-extracted-from-the-name-of-a-group-of-files

评论： Peter 2014-12-29

采纳的回答： Jan

在 MATLAB Online 中打开

Hello,

I have a group of files named like this:

files=[{' x+0.000mm_y_+0.000mm_z_+0.000mm.dat_ '} 
{' x+5.000mm_y_+10.000mm_z_+0.000mm.dat_ '
{' x+10.000mm_y_+20.000mm_z_+30.000mm.dat_ '} 
{' x+15.000mm_y_+40.000mm_z_+0.000mm.dat_ '} 
{' x+20.000mm_y_+60.000mm_z_+0.000mm.dat_ '}]

I need to have the X and Y coordinates this way and order:

When i use:

coord = regexp(files,'\d+(\.\d+)?','match')

I oibtain the three coordenates but HOWEVER they are not displayed in the same order as the name of the files, and it is a very important problem, to solve.

I need somehow to have the 3 coordinates in the same order as the files whose they are extracted.

Do you know how to doi it? Why do they follow another order? Is this about the 'match'??

Thanks

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

请先登录，再进行评论。

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

Answer 1

Jan 2014-12-29

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/168393-sorting-data-extracted-from-the-name-of-a-group-of-files#answer_163531

在 MATLAB Online 中打开

files = {' x+0.000mm_y_+0.000mm_z_+0.000mm.dat_ ', ...
         ' x+5.000mm_y_+10.000mm_z_+0.000mm.dat_ ', ...
         ' x+10.000mm_y_+20.000mm_z_+30.000mm.dat_ ', ...
         ' x+15.000mm_y_+40.000mm_z_+0.000mm.dat_ ', ...
         ' x+20.000mm_y_+60.000mm_z_+0.000mm.dat_ '}
coordC = regexp(files,'\d+(\.\d+)?','match');
coord  = cat(1, coords{:});

Reply:

    '0.000'     '0.000'     '0.000' 
    '5.000'     '10.000'    '0.000' 
    '10.000'    '20.000'    '30.000'
    '15.000'    '40.000'    '0.000' 
    '20.000'    '60.000'    '0.000'

This exactly the same order as the list of file names. Therefore I do not understand the question. Please post, what you observe.

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

Peter 2014-12-29

Yes, exactly.

Both answers worked properly.

Thank you very much for the the help and for the explanation.

请先登录，再进行评论。

Answer 2

Azzi Abdelmalek 2014-12-29

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/168393-sorting-data-extracted-from-the-name-of-a-group-of-files#answer_163529

在 MATLAB Online 中打开

coord=cell2mat(cellfun(@str2double,regexp(files,'(?<=(x\+)|(y_\+))\d+(\.\d+)?', 'match'),'un',0))

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

请先登录，再进行评论。

Answer 3

Geoff Hayes 2014-12-29

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/168393-sorting-data-extracted-from-the-name-of-a-group-of-files#answer_163530

在 MATLAB Online 中打开

Peter - what order are they appearing in? If I do the following

 files=[{' x+0.000mm_y_+0.000mm_z_+0.000mm.dat_ '} 
        {' x+5.000mm_y_+10.000mm_z_+0.000mm.dat_ '}
        {' x+10.000mm_y_+20.000mm_z_+30.000mm.dat_ '} 
        {' x+15.000mm_y_+40.000mm_z_+0.000mm.dat_ '} 
        {' x+20.000mm_y_+60.000mm_z_+0.000mm.dat_ '}];
 coord = regexp(files,'\d+(\.\d+)?','match');
 xyzCoords = cell2mat(cellfun(@(x)str2num(char(x))',coord,'UniformOutput',false));

then

 xyzCoords =
   0     0
  10     0
  20    30
  40     0
  60     0

In the above line of code, since coord is a cell array, we use the cellfun to apply a function to each cell in the array. This function, @(x)str2num(char(x))', converts each element to a string (via char) then to a numeric array (3x1, via str2num), which is then transposed to get a row. As the result of cellfun is another cell array of numeric data, we just convert it from the cell array to a matrix via cell2mat.