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.