I'm trying to match certain text and then replace with the text plus some extra characters. Minimal example text:
#10 Oranges. These are citrus fruits
Desired output:
#10 Oranges.
These are citrus fruits
Regex: (#\d{1,2}[^.]*\.)\s*
Replace with: $1\n
(I have Match using regular expressions
checked)
The regex successfully matches #10 Oranges.
. However the numbered backreference doesn't replace the text with the capture group but just goes in literally (literal output is $1\n
). I have also tried using a backslash for the numbered backreference \1
and the result is the same.
Is there something I'm missing? How do I reinsert matched text in google docs using regular expressions?
Note: Capture groups only work with Google Sheets.
See support.google.com/docs/answer/62754#regular_expressions