{"id":7186,"date":"2016-05-13T17:05:52","date_gmt":"2016-05-13T21:05:52","guid":{"rendered":"https:\/\/blogs.mathworks.com\/pick\/?p=7186"},"modified":"2016-07-01T13:30:02","modified_gmt":"2016-07-01T17:30:02","slug":"flatten-nested-cell-arrays","status":"publish","type":"post","link":"https:\/\/blogs.mathworks.com\/pick\/2016\/05\/13\/flatten-nested-cell-arrays\/","title":{"rendered":"Flatten (Nested) Cell Arrays"},"content":{"rendered":"
\r\n \r\n

Sean<\/a>'s pick this week is Flatten (Nested) Cell Arrays<\/a> by Yung-Yeh<\/a>.\r\n <\/p>\r\n <\/introduction>\r\n

Background<\/a><\/h3>\r\n

I recently have been using webread<\/tt><\/a> to scan websites and mine information to do data analysis with.\r\n <\/p>\r\n

This requires a lot of regular expressions<\/a>. Regular expressions are one of those things that are incredibly frustrating but fun at the same time. I'm usually looking\r\n for some text pattern inside of html tags which means I'm going to be grabbing 'tokens'<\/i> or the unknown part that matches the expression.\r\n <\/p>\r\n

Let's do a simple example where we grab the list of MathWorks' products from the website https:\/\/www.mathworks.com\/products.html<\/a>.\r\n <\/p>\r\n

First, let's identify the pattern we'll be looking for. I like to do this in a web browser thanks to the syntax highlighting\r\n and other editor features. Here's a first view:\r\n <\/p>\r\n

<\/p>\r\n

There are two patterns we need to parameterize. The first, in yellow is the product reference. The second, in green, is\r\n the product name, the token we want to capture.\r\n <\/p>\r\n

<\/p>\r\n

Now let's code this up. First, we'll grab the html.<\/p>

html = webread('https:\/\/www.mathworks.com\/products.html'<\/span>);<\/pre>
Next, we'll build the regular expression.  It's always nice to keep the doc page<\/a> open for this.\r\n   <\/p>\r\n   
\r\n      
    \r\n         
  1. Match the string literal \"\/product\/\"<\/li>\r\n         
  2. Match any \"[]\" characters \"\\w\" or hyphens \"\\w\"<\/li>\r\n         
  3. As many times as possible \"*\"<\/li>\r\n         
  4. Match the next backslash and closing double quote and greater than sign \"\/\"\"<\/li>\r\n         
  5. Start the token with parenthesis (<\/li>\r\n         
  6. Match any words, hyphens, or spaces \"\\s\" as many times as possible.<\/li>\r\n         
  7. Close the token )<\/li>\r\n      <\/ol>\r\n   <\/div>
    expr = '\/products\/[\\w\\-]*\/\">([\\w\\-\\s]*)'<\/span>;<\/pre>
    Run the regular expression capturing tokens.<\/p>
    tokens = regexp(html, expr, 'tokens'<\/span>);<\/pre>
    This is where Yung-Yeh's file comes in.  The output from regexp<\/tt> with tokens is a nested cell that can have many nesting levels depending on number of tokens and token nesting level.  cellflat<\/tt> allows me to flatten it as many levels as necessary into a cell string.\r\n   <\/p>
    tokens = cellflat(tokens);<\/pre>
    Now we can look at the unique products with white space at the end removed.<\/p>
    disp(unique(deblank(tokens))')<\/pre>
        '...'\r\n    'Aerospace Blockset'\r\n    'Aerospace Toolbox'\r\n    'Antenna Toolbox'\r\n    'Audio System Toolbox'\r\n    'Bioinformatics Toolbox'\r\n    'Communications System Toolbox'\r\n    'Computer Vision System Toolbox'\r\n    'Control System Toolbox'\r\n    'Curve Fitting Toolbox'\r\n    'DO Qualification Kit'\r\n    'DSP System Toolbox'\r\n    'Data Acquisition Toolbox'\r\n    'Database Toolbox'\r\n    'Datafeed Toolbox'\r\n    'Econometrics Toolbox'\r\n    'Embedded Coder'\r\n    'Filter Design HDL Coder'\r\n    'Financial Instruments Toolbox'\r\n    'Financial Toolbox'\r\n    'Fixed-Point Designer'\r\n    'Fuzzy Logic Toolbox'\r\n    'Global Optimization Toolbox'\r\n    'HDL Coder'\r\n    'HDL Verifier'\r\n    'IEC Certification Kit'\r\n    'Image Acquisition Toolbox'\r\n    'Image Processing Toolbox'\r\n    'Instrument Control Toolbox'\r\n    'LTE System Toolbox'\r\n    'MATLAB'\r\n    'MATLAB Coder'\r\n    'MATLAB Compiler'\r\n    'MATLAB Compiler SDK'\r\n    'MATLAB Distributed Computing Server'\r\n    'MATLAB Mobile'\r\n    'MATLAB Production Server'\r\n    'MATLAB Report Generator'\r\n    'MATLAB for Home Use'\r\n    'Mapping Toolbox'\r\n    'Model Predictive Control Toolbox'\r\n    'Model-Based Calibration Toolbox'\r\n    'Neural Network Toolbox'\r\n    'OPC Toolbox'\r\n    'Optimization Toolbox'\r\n    'Parallel Computing Toolbox'\r\n    'Partial Differential Equation Toolbox'\r\n    'Phased Array System Toolbox'\r\n    'Polyspace Bug Finder'\r\n    'Polyspace Code Prover'\r\n    'RF Toolbox'\r\n    'Robotics System Toolbox'\r\n    'Robust Control Toolbox'\r\n    'Signal Processing Toolbox'\r\n    'SimBiology'\r\n    'SimEvents'\r\n    'SimRF'\r\n    'Simscape'\r\n    'Simscape Driveline'\r\n    'Simscape Electronics'\r\n    'Simscape Fluids'\r\n    'Simscape Multibody'\r\n    'Simscape Power Systems'\r\n    'Simulink'\r\n    'Simulink 3D Animation'\r\n    'Simulink Code Inspector'\r\n    'Simulink Coder'\r\n    'Simulink Control Design'\r\n    'Simulink Design Optimization'\r\n    'Simulink Design Verifier'\r\n    'Simulink Desktop Real-Time'\r\n    'Simulink PLC Coder'\r\n    'Simulink Real-Time'\r\n    'Simulink Report Generator'\r\n    'Simulink Test'\r\n    'Simulink Verification and Validation'\r\n    'Spreadsheet Link'\r\n    'Stateflow'\r\n    'Statistics and Machine Learning Toolbox'\r\n    'Symbolic Math Toolbox'\r\n    'System Identification Toolbox'\r\n    'Trading Toolbox'\r\n    'Vehicle Network Toolbox'\r\n    'Vision HDL Toolbox'\r\n    'WLAN System Toolbox'\r\n    'Wavelet Toolbox'\r\n<\/pre>
    Comments<\/a><\/h3>\r\n   
    Give it a try and let us know what you think here<\/a> or leave a comment<\/a> for Yung-Yeh.\r\n   <\/p>