How to Use Regex to Match Carriage Returns and Line Feed Characters in Search and Replace

Document created by dprostko on Jun 13, 2011Last modified by Adam Arrowsmith on Apr 3, 2017
Version 6Show Document
  • View in full screen mode

Use Case

You need to match 'Carriage Returns' and 'Line Feed' characters to either change them or remove them using a Data Process >> Search & Replace with a regular expression.

 

Solution

As you may have Carriage Returns but not Line Feeds, vice versa, or both, you can use the following expression, which will match any combination of those characters:

[\r\n]

6 people found this helpful

Attachments

    Outcomes