Regular Expressions 101

Pro

1st Alternative^NA(?:\s+NA)*\b\s*

^start of line

NAthe literal text NA (case sensitive)

Non-Capturing Group(?:\s+NA)*

*repeats the group contents below any number of times:

\s+any whitespace character, repeated at least once

NAthe literal text NA (case sensitive)

\ban ASCII word boundary

\s*any whitespace character, repeated any number of times

2nd Alternative\s*\bNA(?:\s+NA)*$

\s*any whitespace character, repeated any number of times

\ban ASCII word boundary

NAthe literal text NA (case sensitive)

Non-Capturing Group(?:\s+NA)*

*repeats the group contents below any number of times:

\s+any whitespace character, repeated at least once

NAthe literal text NA (case sensitive)

$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

Detailed match information will be displayed here automatically.

25 tokens

Regular Expression

^NA(?:\s+NA)*\b\s*|\s*\bNA(?:\s+NA)*$

New

Gene1 Gene2 Gene3 NA NA NA NA
Gene41 NAGene218 GeneX NA
Gene19 GeneNA NA NA NA NA NA

NA NA Gene19 GeneNA NA NA NA NA NA
NAGene19 GeneNA NA NA NA NA NA

Substitution

Gene1 Gene2 Gene3 NA NA NA NA
Gene41 NAGene218 GeneX NA
Gene19 GeneNA NA NA NA NA NA

NA NA Gene19 GeneNA NA NA NA NA NA
NAGene19 GeneNA NA NA NA NA NA