4

I would like to use the Google Spreadsheet Find and Replace function with the "Search using regular expressions" function activated to do a search and replace in my document.

Use case: Some of my cells contain erroneous linefeed characters at the end (leftovers from paste operation by some of the editors).

I'm using the following pattern to successfully find the cells

.*\012$

Is there some syntax for the "Replace with" field that lets me replace the cell's content by the string I found minus the \012 character at the end?

The Google Spreadsheet documentation does not contain any relevant information. https://support.google.com/docs/answer/62754?hl=en

Here's a screenshot of the box

Vivien Schreiber
  • 43
  • 1
  • 1
  • 5

1 Answers1

6

You may use a capturing group (...) in the pattern around the part you want to keep, and use a $1 backreference in the replacement:

(.*)\012$

to replace with $1.

See the regex demo.

Wiktor Stribiżew
  • 607,720
  • 39
  • 448
  • 563