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.