regex101: PCRE (Legacy) Substitution Workspace

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

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

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

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

the literal (32₁₀ / 40₈ / 20₁₆)

Group 1(.*?)

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

the literal (32₁₀ / 40₈ / 20₁₆)

\d+a digit, repeated at least once

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

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

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

Search reference

Regular Expression

.*\d{4}-\d{2} (.*?) \d+,\d{2}.*

New

201700000000111 01/02/2017 11.111.111/0001-74 ADAMA BRASIL S/A ATIVA 0,00 160,00 160,00 0,00 0,00 0,00 0,00 0,00
201700000000122 01/02/2017 22.222.222/0002-75 AGRITEX COMERCIAL AGRÍCOLA LTDA (QUERÊNCIA) ATIVA 2,79 170,00 170,00 0,00 0,00 0,00 4,74 0,00
201700000000133 07/02/2017 33.333.333/0001-76 CREMONESE WANDSCHEER & CIA LTDA - ME ATIVA 0,00 50,00 50,00 0,00 0,00 0,00 0,00 0,00
201700000000144 23/02/2017 44.444.444/0001-77 G3 SEMENTES LTDA ATIVA 0,00 230,00 230,00 0,00 0,00 0,00 0,00 0,00

Regular Expressions 101

Regular Expression

Extraction