I see you've got a script, but I like a puzzle... seems to work like this.
t_fiscale (\d{4})(\d{2})(\d{2}) (\d+) (\d+)$(?s).+?TOTALE EURO
+([0-9,]+).+?C\.F\. +([\w,]+)
I used this with the extract option
On Tuesday, December 4, 2018 at 8:14:34 AM UTC-5, m.osti wrote:
>
> Hello, every day when I have to close up my shop I get this report from
> the cash register. I have the obligation to transmit some sales data
> through a web page, and I have to insert one receipt at a time, sigh.
> Only sales that have the "C.F." are valid.
> In this case I need it in the order:
> the date
> the receipt number
> the total euro
> the alphanumeric part after C.F. for example ABCDEF12G34H567I which is of
> 16 characters always in this order 6 alphabetic characters, 2 numbers, 1
> character, 2 numbers, 1 character, 3 numbers, 1 character.
>
> Now I copy them by hand and then I use a macro that I created in
> KeyboardMaestro. Since there is a lot of data that I don't need, to speed
> up I tried to extract only the necessary values through a GREP search, but
> I failed, failed, failed and after many attempts I decided to ask.
> If it were possible I would also like the date separator to be / instead
> of -
>
> I'm going to put on the cash register closure below: the values I need are
> in red.
> Thank you and sorry for my english.
> ciao from italy
>
> -m
>
> ---
>
> t_fiscale 20170422 0846 *1*
> EURO
> LENTI OFT 110,00
> MONTAGGIO LENTI 20,00
> TOTALE EURO *130,00*
> CONTANTE 130,00
> C.F. *ABCDEF12G34H567I*
>
> CASSA: 01
> *22-04-2017* 08:46
> N.SCONTR.FISCALE 1
> t_fiscale 20170422 0936 *2*
> EURO
> LENTI CONTATTO 100,00
> TOTALE EURO *100,00*
> CONTANTE 100,00
> C.F. *ABCDEF12G34H567I*
>
> CASSA: 01
> 22-04-2017 09:36
> N.SCONTR.FISCALE 2
> t_fiscale 20170422 1037 *3*
> EURO
> MONTATURE OFT 120,00
> LENTI OFT 120,00
> MONTAGGIO LENTI 20,00
> TOTALE EURO *260,00*
> CONTANTE 260,00
> C.F. *LMNOPQ89R01S234T*
>
> CASSA: 01
> 22-04-2017 10:37
> N.SCONTR.FISCALE 3
> t_fiscale 20170422 1055 4
> EURO
> IVA 22 8,00
> TOTALE EURO 8,00
> CONTANTE 8,00
>
> CASSA: 01
> 22-04-2017 10:55
> N.SCONTR.FISCALE 4
> t_fiscale 20170422 1826 *5*
> EURO
> SOLUZIONI LAC 23,00
> TOTALE EURO 23,00
> CONTANTE *23,00*
> C.F. *LMNOPQ89R01S234T*
>
> CASSA: 01
> 22-04-2017 18:26
> N.SCONTR.FISCALE 5
> t_non fiscale 20170422 1843 1
> NON FISCALE
> RAPPORTO REPARTI "Z"
> PERIODICO 1
> *(++ BELOW UNNECESSARY DATA ++)*
> DATA ULTIMO AZZERAMENTO
> 21-04-2017
>
> CASSA: 01
> 22-04-2017 18:43
> N.SCONTR.NON FISC 1
> NON FISCALE
> t_fiscale 20170422 1843 6
> RAPPORTO *Z*
> CHIUSURA FISCALE
> DATI IN EURO
>
> ------------------------
> CORRISPETTIVI
> SCONTRINI
> ------------------------
> CORRISP. GIORNALIERI
> 1 234,00
> PROGR. CORRISPETTIVI
> 123 456,78
> NOTE DI CREDITO GIORN.
> 0,00
>
> ------------------------
> CORRISPETTIVI
> DOCUMENTI CL.II
> ------------------------
> CORRISP. GIORNALIERI
> 0,00
> *FATTURE 0,00
> *RICEVUTE 0,00
> NOTE DI CREDITO GIORN.
> 0,00
>
> ------------------------
> DETTAGLIO
> OPERAZIONI
> ------------------------
> SCONTI 0,00
> N. 0
> MAGGIORAZ. 0,00
> N. 0
> BONIFICI 0,00
> N. 0
> RETTIFICHE 0,00
> N. 0
> CORRISP. NON RISCOSSI
> *SCONTRINI 0,00
> *RICEVUTE 0,00
> CORRISP. RISCOSSI
> *SCONTRINI 1 234,00
> *FATTURE 0,00
> *RICEVUTE 0,00
>
> ------------------------
> DOCUMENTI
> GIORNALIERI
> ------------------------
> N.SCONTR.FISCALI 6
> *N.SCONTR./NOTE CRED. 0
> N.SCONTR.N FISCALI 1
> *N.RAPP.LETTURE DGFE 0
>
> N.DOCUMENTI CL.II 0
> *N.FATTURE 0
> *N.FATTURE/NOTE CRED. 0
> *N.RICEVUTE 0
>
> ------------------------
> DATI GENERALI
> ------------------------
> N.LETT.MEM.FISCALE 0
>
> PROGR. AZZERAMENTI 960
> NUM. RIPRISTINI 0
>
> ------------------------
> DISPOS.GIORN.ELETTRONICO
> N.2 DEL 02-05-2014
> MATR. 05 30005163
>
> CASSA: 01
> 22-04-2017 18:43
> N.SCONTR.FISCALE 6
>
>
--
This is the BBEdit Talk public discussion group. If you have a
feature request or need technical support, please email
"supp...@barebones.com" rather than posting to the group.
Follow @bbedit on Twitter: <https://www.twitter.com/bbedit>
---
You received this message because you are subscribed to the Google Groups
"BBEdit Talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to bbedit+unsubscr...@googlegroups.com.
To post to this group, send email to bbedit@googlegroups.com.
Visit this group at https://groups.google.com/group/bbedit.
