Re: GREP help: dig into the report of the cash register

2018-12-14 Thread m.osti
Hi Chris, thank you for the support ;) > I can write another script that will parse these into variables that can be inserted into your web page. This is over my skill Chris :( but for your information, I have to put other data in 3 consecutive web pages. I set up 2 macros with Keyboad

Re: GREP help: dig into the report of the cash register

2018-12-14 Thread m.osti
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

Re: GREP help: dig into the report of the cash register

2018-12-07 Thread ThePorgie
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\.

Re: GREP help: dig into the report of the cash register

2018-12-07 Thread Christopher Stone
On 12/06/2018, at 13:44, Christopher Stone mailto:listmeis...@suddenlink.net>> wrote: > Here's an updated script that produces cleaner output. > From here I would probably turn the output into tab-delimited single lines. Hey Marco, The newest incarnation of the script (appended) produces output

Re: GREP help: dig into the report of the cash register

2018-12-07 Thread m.osti
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+)

Re: GREP help: dig into the report of the cash register

2018-12-06 Thread Christopher Stone
On 12/06/2018, at 11:30, m.osti mailto:mk0...@gmail.com>> wrote: > of course, this way the result is even cleaner and easier then to use Hey Marco, Here's an updated script that produces cleaner output. >From here I would probably turn the output into tab-delimited single lines. Because from

Re: GREP help: dig into the report of the cash register

2018-12-06 Thread ThePorgie
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

Re: GREP help: dig into the report of the cash register

2018-12-06 Thread m.osti
with this option there is an error: it get sales #4 (sale without CF = unnecessary) but it ignore sale #5 (with CF = necessary) of course, this way the result is even cleaner and easier then to use Il giorno mercoledì 5 dicembre 2018 18:25:36 UTC+1, ThePorgie ha scritto: > > > oops...you might

Re: GREP help: dig into the report of the cash register

2018-12-06 Thread m.osti
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

Re: GREP help: dig into the report of the cash register

2018-12-05 Thread ThePorgie
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 >

Re: GREP help: dig into the report of the cash register

2018-12-05 Thread ThePorgie
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

Re: GREP help: dig into the report of the cash register

2018-12-05 Thread @lbutlr
On Tue Dec 04 2018 03:19:02 m.osti said: > > 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,

Re: GREP help: dig into the report of the cash register

2018-12-05 Thread m.osti
Il giorno martedì 4 dicembre 2018 21:41:43 UTC+1, David Wagner ha scritto: > > You state what you need is in red, but you do not show any date in red. > Please clarify... > Sorry Wags, it's cause I'm on google groups via web browser, and it allows HTML view. Below the picture. ty -m [image:

Re: GREP help: dig into the report of the cash register

2018-12-05 Thread m.osti
Il giorno martedì 4 dicembre 2018 23:12:49 UTC+1, Christopher Stone ha scritto: > > On 12/04/2018, at 04:19, 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,

Re: GREP help: dig into the report of the cash register

2018-12-04 Thread Christopher Stone
On 12/04/2018, at 04:19, m.osti mailto:mk0...@gmail.com>> 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

Re: GREP help: dig into the report of the cash register

2018-12-04 Thread David G Wagner
You state what you need is in red, but you do not show any date in red. Please clarify... thank you... Wags ;) WagsWorld Hebrews 4:15 Ph(primary) : 408-914-1341 Ph(secondary): 408-761-7391 On Dec 4, 2018, 05:14 -0800, m.osti , wrote: > Hello, every day when I have to close up my shop I get this

GREP help: dig into the report of the cash register

2018-12-04 Thread m.osti
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