regex101: PCRE (Legacy) Match Workspace

^start of line

Non-Capturing Group(?:[^,\r\n]*,){6}

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

Negated Character Class[^,\r\n]*

*matches any number of characters outside the set below:

,the literal , (44₁₀ / 54₈ / 2C₁₆)

\ra carriage return (ASCII 13)

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

,the literal , (44₁₀ / 54₈ / 2C₁₆)

.*any character (except for line terminators), repeated any number of times

\r?optionally matches a carriage return (ASCII 13)

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

Non-Capturing Group(?:[^,\r\n]*,){9}

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

Negated Character Class[^,\r\n]*

*matches any number of characters outside the set below:

,the literal , (44₁₀ / 54₈ / 2C₁₆)

\ra carriage return (ASCII 13)

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

,the literal , (44₁₀ / 54₈ / 2C₁₆)

.*any character (except for line terminators), repeated any number of times

Non-Capturing Group(?:\r?\n(?!(?:[^,\r\n]*,){6}.*\r?\n(?:[^,\r\n]*,){9}).*)*

*repeats the group contents below any number of times:

\r?optionally matches a carriage return (ASCII 13)

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

Negative Lookahead(?!(?:[^,\r\n]*,){6}.*\r?\n(?:[^,\r\n]*,){9})

Non-Capturing Group(?:[^,\r\n]*,){6}

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

Negated Character Class[^,\r\n]*

*matches any number of characters outside the set below:

,the literal , (44₁₀ / 54₈ / 2C₁₆)

\ra carriage return (ASCII 13)

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

,the literal , (44₁₀ / 54₈ / 2C₁₆)

.*any character (except for line terminators), repeated any number of times

\r?optionally matches a carriage return (ASCII 13)

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

Non-Capturing Group(?:[^,\r\n]*,){9}

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

Negated Character Class[^,\r\n]*

*matches any number of characters outside the set below:

,the literal , (44₁₀ / 54₈ / 2C₁₆)

\ra carriage return (ASCII 13)

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

,the literal , (44₁₀ / 54₈ / 2C₁₆)

.*any character (except for line terminators), repeated any number of times

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

Search reference

Regular Expression

^(?:[^,\r\n]*,){6}.*\r?\n(?:[^,\r\n]*,){9}.*(?:\r?\n(?!(?:[^,\r\n]*,){6}.*\r?\n(?:[^,\r\n]*,){9}).*)*

New

LB,32736,0,T,NRJ.POMPES_BACHE.PUISSANCE_ELEC_INST,20190811T080000.000Z,20190811T194400.000Z
TR,NRJ.POMPES_BACHE.PUISSANCE_ELEC_INST,0,65535,1,1,,0,0,2
20190811T080000.000Z,0.00800000037997961,192
20190811T080100.000Z,0.008999999612569809,192
20190811T080200.000Z,0.008999999612569809,192
LB,32734,0,T,NRJ.POMPES_BACHE.PUISSANCE_ELEC_CPT,20190811T080000.000Z,20190811T201200.000Z
TR,NRJ.POMPES_BACHE.PUISSANCE_ELEC_CPT,0,65535,1,1,,0,0,2
20190811T080000.000Z,0.6743068099021912,192
20190811T080100.000Z,0.6744459867477417,192
20190811T080200.000Z,0.6745882630348206,192
20190811T080300.000Z,0.6747232675552368,192
20190811T080400.000Z,0.6748600006103516,192
20190811T080500.000Z,0.6749916672706604,192
20190811T080600.000Z,0.6751362681388855,192

1,2,3,4,5,6,7
1,2,3,4,5,7,7,8,9,10
1,2,3
1,2,3,4,5,6,7
1,2,3,4,5,7,7,8,9,10
1,2,3

Regular Expressions 101

Regular Expression

Extraction