title: How to remove line feed?
body: <p>This script for Outlook returns the desired date but doesn't remove the line feed.</p>
  <p>String I want to get the date from:<br />
  1_c Anruf/Meldung am (Datum): 04.Mai.2020</p>
  <pre class="lang-vb prettyprint-override"><code>With Reg1
      .Pattern = &quot;1_c Anruf\/Meldung am \(Datum\)\s*[:]+\s*(.*)\s+\n&quot;
      .Global = False
  End With
  If Reg1.Test(olMail.Body) Then
      Set M1 = Reg1.Execute(olMail.Body)
  End If
  For Each M In M1
      Debug.Print M.SubMatches(0)
      With xExcelApp
          Range(&quot;A5&quot;).Value = M.SubMatches(0)
      End With
  Next M
  </code></pre>
  <p>regex101 selects correctly but the debugger always shows something like &quot;02.12.2020 &quot;. &lt;- containing no whitespace but a line feed.</p>
  <p>In Excel the line feed is also visible. Also trailing whitespace isn't a problem since I can use TRIM but the line feed doesn't allow it to function.</p>