regex101: Golang Substitution Workspace

Pro

^start of line

Non-Capturing Group(?:[^N\n]|N(?:[^O\n]|O(?:[^A\n]|$)|$)|$)+

+repeats the group contents below at least once:

1st Alternative[^N\n]

Negated Character Class[^N\n]

Nthe literal N (78₁₀ / 116₈ / 4E₁₆) (case sensitive)

\na line-feed (newline) character (ASCII 10)

2nd AlternativeN(?:[^O\n]|O(?:[^A\n]|$)|$)

Nthe literal N (78₁₀ / 116₈ / 4E₁₆) (case sensitive)

Non-Capturing Group(?:[^O\n]|O(?:[^A\n]|$)|$)

1st Alternative[^O\n]

Negated Character Class[^O\n]

Othe literal O (79₁₀ / 117₈ / 4F₁₆) (case sensitive)

\na line-feed (newline) character (ASCII 10)

2nd AlternativeO(?:[^A\n]|$)

Othe literal O (79₁₀ / 117₈ / 4F₁₆) (case sensitive)

Non-Capturing Group(?:[^A\n]|$)

1st Alternative[^A\n]

Negated Character Class[^A\n]

Athe literal A (65₁₀ / 101₈ / 41₁₆) (case sensitive)

\na line-feed (newline) character (ASCII 10)

2nd Alternative$

$end of line

3rd Alternative$

$end of line

3rd Alternative$

$end of line

Global pattern flags

g modifier: global. Finds all matches instead of stopping after the first

m modifier: multiline. Causes ^ and $ to match the start and end of each line, not only the start and end of the string

25 tokens

Regular Expression

^(?:[^N\n]|N(?:[^O\n]|O(?:[^A\n]|$)|$)|$)+

New

I want to delete anything in a line but stop before the word NOA if that is present in a line. NOA will also follow a colon.

1: NOA Keep this)
2 lkajsflk: DONT KEEP THIS
asdlkjfaskldjf: Dont keep this
asdfjlka: NOA
asdf:NOA(lkjasdlfkjasf)


Version: RE2 for Google Sheets

Substitution

I want to delete anything in a line but stop before the word NOA if that is present in a line. NOA will also follow a colon.

1: NOA Keep this)
2 lkajsflk: DONT KEEP THIS
asdlkjfaskldjf: Dont keep this
asdfjlka: NOA
asdf:NOA(lkjasdlfkjasf)


Version: RE2 for Google Sheets