Using RegexReplace()

Question

Does this function support capturing groups, and if yes, how does one access the captured data? Intent is to use a this function looking for punctuation from a text field, and then add a new line to this. regex: ([.!?])\s*substitution: $1
Documentation doesn't state one way or the other. I've tried escaping the new line value without success. Perhaps I'm just missing something simple.

Mez · Accepted Answer

Found the solution: capturing is referred to with backslash 1, which needs to be escaped. RegexReplace( [Additional Notes], "([.!?])\s*", "\1
" )

MarkShnier · Answer

Can you give an example of the before and after results you are looking for?

Sign up

Login to the community