title: Regex in Google Sheets full value + Value Splited
body: <p>In SpreadSheet I have the following text:</p>
  <pre><code>Ann Nutr Metab. 2022 May 11:1-8. doi: 10.1
  </code></pre>
  <p>Need to extract the date (2022 May 11) and split it in columns (year/month/date)</p>
  <p>In B1 y wrote the formula</p>
  <pre><code>=REGEXEXTRACT($A$1,&quot;(((?:\d){4})(...\w)\s(\d*)).*?:&quot;)
  </code></pre>
  <p>But for some reason I have the date required in the formula cell plus the date splited (four colums) and I only need the columns for (year/month/date)</p>
  <pre><code>2022 May 11|2022|May|11|
  </code></pre>
  <p>How can I recode to have this? <code>|2022|May|11|</code>
  Thank you!</p>
  <p><a href="https://i.stack.imgur.com/JQqAC.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/JQqAC.png" alt="enter image description here" /></a></p>