Hi, I tried this also and seems to me the result is the same as the
previous one: perfect.
I use the multi search function of bbedit: it scans all the folders
containing the files (one per day) and in 4 seconds extracts all the data.
awesome!
Ah, there was only a receipt with an amount of 1000,00 and the script
extracts just "1", same for the previous script as well. I saw it
immediately because it was without ", 00" so no problem.
Here it is:
5
02/10/2018
1
MCCGLC87A49V111R
Thank you again, you save me a lot of time, of very boring time ;)
Il giorno venerdì 7 dicembre 2018 15:37:47 UTC+1, ThePorgie ha scritto:
>
> Ok, I think I've narrowed down the greedy over-run to only look between
> matching register numbers...So basically this should work regardless of
> varying number of item lines in your receipt.
>
> Search:
> t_fiscale (\d{4})(\d{2})(\d{2}) (\d+) (\d+)$(?s).*?TOTALE EURO
> +([0-9,]+).*?C\.F\. +([\w]+).*?N\.SCONTR\.FISCALE +\5
>
> Replace:
> \5\n\3/\2/\1\n\6\n\7\n\n
>
> On Friday, December 7, 2018 at 4:03:26 AM UTC-5, m.osti wrote:
>>
>> Well ThePorgie, not sure to have understood your note but... now it's
>> perfect.
>> thank you
>>
>> Il giorno giovedì 6 dicembre 2018 19:33:55 UTC+1, ThePorgie ha scritto:
>>>
>>> Right you are. I didn't notice that when I last tested. Try this:
>>> t_fiscale (\d{4})(\d{2})(\d{2}) (\d+) (\d+)$(?:.*\n){1,8}?TOTALE EURO
>>> +([0-9,]+)(?:.*\n){1,3}?C\.F\. +([\w]+)
>>>
>>> and replace:
>>> \5\n\3/\2/\1\n\6\n\7\n\n
>>>
>>> Note: I'm not sure how many items you can have listed on your receipt
>>> which causes me pause even with this grep string as 1 receipt with a long
>>> list will get skipped. I couldn't come up with a way to stop the greedy
>>> over-run if the string didn't contain the "C.F...." line. If someone else
>>> notices something in this regard that I overlooked that would be great.
>>>
>>>
>>> On Thursday, December 6, 2018 at 12:27:43 PM UTC-5, m.osti wrote:
>>>>
>>>> thank you for your concern. this GREP search is quite good: it get also
>>>> the sale(s) without CF that are unnecessary but I can just ignore them at
>>>> a
>>>> fast glance.
>>>>
>>>> Il giorno mercoledì 5 dicembre 2018 18:20:28 UTC+1, ThePorgie ha
>>>> scritto:
>>>>>
>>>>> 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.
