Please enable JavaScript to use regex101
/
^
r
e
g
e
x
[
\
-
_
]
?
1
0
1
$
/
i
Reg
ular
Ex
pressions
101
Upgrade to Pro
Enterprise
Regular Expression
/
^(990122.*?),(.*?),(.*?)$
/
gm
Input 1
New
0000000000001,reparto 1, 0000000000002,ABBIGLIAMENTO, 0000000000003,SCARPE, 0000000000004,BIGIOTTERIA, 0000000000005,GLADE AUTOMATIC,3.5 0000000000006,PELLETTERIA, 0000000000007,COSMETICI, 0000000000008,BIANCHERIA, 0000000000009,CASALINGHI, 0000000000020,SCONTO 20% ALLA, 0000000000050,SCONTO 50% ALLA, 0000000001111,OFFERTA 3.00,3 0000000031481,VETRO TEMPERATO,9.9 0000000032783,VETRO TEMPERATO,5.9 0000000075138,ABB MODA 19,10.9 0000000431990,CAPPELLO,14.9 0000000621694,borsa,19.9 0000000621905,borsa,24.9 0000000672016,papillon,3.9 0000000672184,papillon,4.9 0000000672252,papillon,2.9 0000000751070,ABBIGLIAMENTO,12.9 0000000751384,ABBIGLIAMENTO,9.9 0000000751834,ABBIGLIAMENTO,12.9 0000000751902,ABBIGLIAMENTO,14.9 0000000752138,ABBIGLIAMENTO,9.9 0000000951050,portamoneta,9.9 0000000951128,portamoneta,9.9 0000000951296,portamoneta,9.9 0000001360376,CAPPELLO,5.9 00000093,PANNOPELL PAV.5,1.1 0000040150628,CORRETTORE PRIT,1.9 0000084155863,PRITT COLLA STI,1.9 0000084195135,CORRETTORE 20PZ,1.9
Extraction
0000000000001,reparto 1, 0000000000002,ABBIGLIAMENTO, 0000000000003,SCARPE, 0000000000004,BIGIOTTERIA, 0000000000005,GLADE AUTOMATIC,3.5 0000000000006,PELLETTERIA, 0000000000007,COSMETICI, 0000000000008,BIANCHERIA, 0000000000009,CASALINGHI, 0000000000020,SCONTO 20% ALLA, 0000000000050,SCONTO 50% ALLA, 0000000001111,OFFERTA 3.00,3 0000000031481,VETRO TEMPERATO,9.9 0000000032783,VETRO TEMPERATO,5.9 0000000075138,ABB MODA 19,10.9 0000000431990,CAPPELLO,14.9 0000000621694,borsa,19.9 0000000621905,borsa,24.9 0000000672016,papillon,3.9 0000000672184,papillon,4.9 0000000672252,papillon,2.9 0000000751070,ABBIGLIAMENTO,12.9 0000000751384,ABBIGLIAMENTO,9.9 0000000751834,ABBIGLIAMENTO,12.9 0000000751902,ABBIGLIAMENTO,14.9 0000000752138,ABBIGLIAMENTO,9.9 0000000951050,portamoneta,9.9 0000000951128,portamoneta,9.9 0000000951296,portamoneta,9.9 0000001360376,CAPPELLO,5.9 00000093,PANNOPELL PAV.5,1.1 0000040150628,CORRETTORE PRIT,1.9 0000084155863,PRITT COLLA STI,1.9 0000084195135,CORRETTORE 20PZ,1.9