regex101: VlrDApceiCred

CRthe literal text CR (case sensitive)

.any character (except for line terminators)

DITOthe literal text DITO (case sensitive)

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

Non-Capturing Group(?:DA)?

?repeats the group contents below at most once:

DAthe literal text DA (case sensitive)

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

TUSDthe literal text TUSD (case sensitive)

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

KWthe literal text KW (case sensitive)

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

\-the literal - (45₁₀ / 55₈ / 2D₁₆)

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

APCEIthe literal text APCEI (case sensitive)

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

\d{2}a digit, repeated exactly 2 times

\/the literal / (47₁₀ / 57₈ / 2F₁₆)

\d{4}a digit, repeated exactly 4 times

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

Group VlrDApceiCred(?<VlrDApceiCred>[0-9.-]+\,?\d*)

Character Class[0-9.-]+

+matches at least one character from the set below:

0-9one character from 0 (48₁₀) to 9 (57₁₀)

.the literal . (46₁₀ / 56₈ / 2E₁₆)

-the literal - (45₁₀ / 55₈ / 2D₁₆)

\,?optionally matches the literal , (44₁₀ / 54₈ / 2C₁₆)

\d*a digit, repeated any number of times

Global pattern flags

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

Search reference

Regular Expression

CR.DITO\s*(?:DA)?\s*TUSD\s*KW\s*\-\s*APCEI\s*\d{2}\/\d{4}\s*(?<VlrDApceiCred>[0-9.-]+\,?\d*)

New

Junho 2019
 
0606 DEBITO TUSD KW - APCEI 04/2019 65,16 0,00 0 0,00 0,00 0,00 0,00
0606 DEB. DA TUSD KW-APCEI- N CONS. 04/2019 1,73 0,00 0 0,00 0,00 0,00 0,00
0606 CREDITO DA TUSD KW - APCEI 06/2019 -22.034,82 0,00 0 0,00 0,00 0,00 0,00
0606 CREDITO TUSD KW-APCEI -N CONS. 06/2019 -238,64 0,00 0 0,00 0,00 0,00 0,00
 
Janeiro 2020
 
0606 DEBITO TUSD KW - APCEI 11/2019 50,85 0,00 0 0,00 0,00 0,00 0,00
0606 DEB. DA TUSD KW-APCEI- N CONS. 11/2019 0,92 0,00 0 0,00 0,00 0,00 0,00
0606 CREDITO DA TUSD KW - APCEI 01/2020 -22.514,07 0,00 0 0,00 0,00 0,00 0,00
0606 CREDITO TUSD KW-APCEI -N CONS. 01/2020 -404,71 0,00 0 0,00 0,00 0,00 0,00
 
Abril 2020
 
0606 DÉBITO TUSD KW-APCEI 02/2020 102,86 0,00 0 0,00 0,00 0,00 0,00
0606 DÉBITO TUSD KW-APCEI - N CONSUMIDA 02/2020 0,92 0,00 0 0,00 0,00 0,00 0,00
0606 CREDITO TUSD KW-APCEI 04/2020 -23.968,26 0,00 0 0,00 0,00 0,00 0,00
0601 Substituição Tributária - Crédito 378.862,670 0,248265 94.058,22 94.058,22 32 30.098,63 0,00 0,00 0,00
0906 Substituição Tributária - Débito 378.862,670 0,248265 -63.959,60 0,00 0 0,00 0,00 0,00 0,00

Regular Expressions 101

Regular Expression

Extraction