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
"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.
