title: How to use separate in tidyverse to split a column?
body: <p>I use <code>separate()</code> function to split column: Enterdateofexam2, it is character format, the value is like &quot;25.07&quot;,&quot;13.09&quot;,&quot;16.06&quot;... My aim is splitting it into day(25) and month(07), then use convert = true to turn them into numeric for filter in next step.</p>
  <p>My code is:</p>
  <pre><code>jimma3n &lt;- jimma3 %&gt;%
          select(Enterdateofexam2, Enterdayofexam, UniqueKey,MEDICALRECORD)%&gt;%
          separate(Enterdateofexam2,into=c(&quot;day&quot;, &quot;month&quot;), sep=&quot;.&quot;, convert = TRUE)
  view (jimma3n)
  </code></pre>
  <p>but the R keeps warning me like:</p>
  <pre><code>Expected 2 pieces. Additional pieces discarded in 4088 rows [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, ...].
  </code></pre>
  <p>So could anyone help to figure out which part is wrong about my code? Thanks~~!</p>