title: R extract house / street numers from adress string
body: <p>say I have the following data with addresses, i.e. street names. My goal is to separate street names from house numbers.</p>
  <pre><code>mydf &lt;- tribble(
    ~street,
    &quot;Some Way 10&quot;,
    &quot;Shiny Street   12b&quot;,
    &quot;Dark Street   from Netflix Movie 17c - 17d&quot;,
    &quot;Seasame Street&quot;,
    &quot;Dark Alley 15c&quot;,
  )
  
  mydf &lt;- mydf %&gt;% mutate(street= str_squish(street)) # get rid of whitespace
  </code></pre>
  <p>I tried the following</p>
  <pre><code>sub &lt;- tidyr::extract(mydf, &quot;street&quot;, c(&quot;street_name_only&quot;, &quot;house_number&quot;), &quot;(\\D+)(\\d.*)&quot;) %&gt;%
   print(n=5)
  </code></pre>
  <p>which works fine, as long as there is a street or house number present. If the string &quot;street&quot; is without a street number, then NAs will show up in the new variable &quot;street_name_only&quot; as well as &quot;house_number&quot;, as is the case with &quot;Sesame Street&quot;. ( I would like to have &quot;Sesame Street&quot; in the &quot;new_street_column&quot; and ideally &quot;&quot; (empty) in the house_number column, though I could mange the NA in the house_number column afterwards).</p>
  <p>Could anybody tell me where I went wrong and how to solve this issue?</p>
  <p>Thank you very much in advance.</p>