Regular Expressions 101

^start of line

Group 1([^|]*\|){9}

{9}repeats the group contents below exactly 9 times:

Negated Character Class[^|]*

*matches any number of characters outside the set below:

|the literal | (124₁₀ / 174₈ / 7C₁₆)

\|the literal | (124₁₀ / 174₈ / 7C₁₆)

Negated Character Class[^|]*

*matches any number of characters outside the set below:

|the literal | (124₁₀ / 174₈ / 7C₁₆)

$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.

Search reference

Regular Expression

^([^|]*\|){9}[^|]*$

Test String
New

Susan|Ward    |1     |1          |1     |1     |0     |||3250905     
Allen|Doe|4     |1          |1     |1     |0     ||
some text
text
more text in the same column|3250061     
Mary|James|4     |1          |1     |1     |0     |||3250061     Albert|Nordling|1     |1          |1     |0     |0     |||900434      
Henry|Johnson|1     |1          |1     |0     |0     |||900434      
Tony|Anderson    |1     |1          |1     |1     |0     |||3250905

Regular Expression

Test StringNew

SubstitutionProcessing...

Test String
New

Substitution
Processing...