title: Filter rows with colon-separated text in a column based on a list
body: <p>Apologies if this has been answered before. I struggled to find the answer that helps me.</p>
  <p>Let's say I have a data frame: -</p>
  <pre><code>Name &lt;- c('P1','P2;P3','P4','P5','P6;P7', &quot;P8&quot;, &quot;P9&quot;)
  Count &lt;- c(15,3,10,4,3,11,9)
  df &lt;- data.frame(Name, Count)
  </code></pre>
  <p>I want to filter the rows where text in column Name match with the list below: -</p>
  <pre><code>list &lt;- c(&quot;P1&quot;, &quot;P2&quot;, &quot;P6&quot;, &quot;P9&quot;)
  </code></pre>
  <p>Note, list has fewer values than the number of rows in the df. The resulting data frame should be:-</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Name</th>
  <th>Count</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>P1</td>
  <td>15</td>
  </tr>
  <tr>
  <td>P2;P3</td>
  <td>3</td>
  </tr>
  <tr>
  <td>P6;P7</td>
  <td>3</td>
  </tr>
  <tr>
  <td>P9</td>
  <td>9</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>Every way I try, R doesn't recognize the values separated by semi-colons and leaves them out of the filtering process. I prefer using Tidyverse-based functions but any help would be greatly received.</p>
  <p>Many thanks in advance,
  Andy</p>