oops...you might need the replace info
\5\n\1/\2/\3\n\6\n\7
On Wednesday, December 5, 2018 at 12:20:28 PM UTC-5, ThePorgie wrote:
>
> 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
"[email protected]" 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 [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/bbedit.
