Re: Grep help for musicxml

['Marcel Lamers' via BBEdit Talk]

Thx JJ, that works great!

On Monday, 5 December 2022 at 21:45:30 UTC+1 jj wrote:

> Hi Marcel,
>
> You could try this.
>
> Find:
>
>
>  
> (?s)())+)()\n((?:.(?!)
>
> Replace:
>
> 
> \n\n\2\n\n\n\1\3
>
> HTH
>
> Jean Jourdain
> On Monday, December 5, 2022 at 8:27:49 PM UTC+1 Marcel Lamers wrote:
>
>> It gets much simpler if I add e.g. a ! before every  first.
>> I can then search for
>> ()([^!]+)()([^!]+)()
>>
>> On Monday, 5 December 2022 at 17:13:42 UTC+1 Marcel Lamers wrote:
>>
>>> Hi,
>>>
>>> I have a musicxml file that is not properly imported into my music 
>>> notation app and I have to change the syntax to do a better import.
>>> I gave it a go with grep but can't seem to get the proper pattern to 
>>> make the change.
>>>
>>> In short, I want to remove the dynamics tags plus content from a note 
>>> tag and place it before the note tag with new closing tags.
>>> Difficulty is the occurrence of several  tags and the greediness 
>>> of the patterns I tested.
>>> I also gave the must not occur (?!) a go but to no avail. 
>>> Any help in the matter would be greatly appreciated
>>>
>>> Here is an example:
>>>
>>> before
>>>
>>> 
>>> 
>>> 
>>> 48
>>> 
>>> 
>>> 
>>> D
>>> 6
>>> 
>>> 48
>>> 1
>>> quarter
>>> 1
>>> 
>>> 
>>> 
>>> G
>>> 5
>>> 
>>> 48
>>> 1
>>> quarter
>>> 1
>>> 
>>> 
>>> 
>>> D
>>> 5
>>> 
>>> 48
>>> 1
>>> quarter
>>> 1
>>> 
>>> 
>>> 
>>> 
>>> 
>>> 
>>> 
>>> 
>>> G
>>> 5
>>> 
>>> 48
>>> 1
>>> quarter
>>> 1
>>> 
>>> 
>>>
>>>
>>> **
>>> 
>>> 
>>> 
>>> 
>>>
>>> after
>>>
>>> 
>>> 
>>> 
>>> 48
>>> 
>>> 
>>> 
>>> D
>>> 6
>>> 
>>> 48
>>> 1
>>> quarter
>>> 1
>>> 
>>> 
>>> 
>>> G
>>> 5
>>> 
>>> 48
>>> 1
>>> quarter
>>> 1
>>> 
>>> 
>>> 
>>> D
>>> 5
>>> 
>>> 48
>>> 1
>>> quarter
>>> 1
>>> 
>>> 
>>> 
>>> 
>>> 
>>> 
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> **
>>> 
>>> 
>>> G
>>> 5
>>> 
>>> 48
>>> 1
>>> quarter
>>> 1
>>> 
>>> 
>>> 
>>> 
>>> 
>>> 
>>>
>>

-- 
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 here. Follow @bbedit on Twitter: 
--- 
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 view this discussion on the web visit 
https://groups.google.com/d/msgid/bbedit/125a0d7f-cda4-478d-b617-b1697d9f70e1n%40googlegroups.com.

Re: Grep help for musicxml

[jj]

Hi Marcel,

You could try this.

Find:

   
 (?s)())+)()\n((?:.(?!)

Replace:

\n\n\2\n\n\n\1\3

HTH

Jean Jourdain
On Monday, December 5, 2022 at 8:27:49 PM UTC+1 Marcel Lamers wrote:

> It gets much simpler if I add e.g. a ! before every  first.
> I can then search for
> ()([^!]+)()([^!]+)()
>
> On Monday, 5 December 2022 at 17:13:42 UTC+1 Marcel Lamers wrote:
>
>> Hi,
>>
>> I have a musicxml file that is not properly imported into my music 
>> notation app and I have to change the syntax to do a better import.
>> I gave it a go with grep but can't seem to get the proper pattern to make 
>> the change.
>>
>> In short, I want to remove the dynamics tags plus content from a note tag 
>> and place it before the note tag with new closing tags.
>> Difficulty is the occurrence of several  tags and the greediness of 
>> the patterns I tested.
>> I also gave the must not occur (?!) a go but to no avail. 
>> Any help in the matter would be greatly appreciated
>>
>> Here is an example:
>>
>> before
>>
>> 
>> 
>> 
>> 48
>> 
>> 
>> 
>> D
>> 6
>> 
>> 48
>> 1
>> quarter
>> 1
>> 
>> 
>> 
>> G
>> 5
>> 
>> 48
>> 1
>> quarter
>> 1
>> 
>> 
>> 
>> D
>> 5
>> 
>> 48
>> 1
>> quarter
>> 1
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> G
>> 5
>> 
>> 48
>> 1
>> quarter
>> 1
>> 
>> 
>>
>>
>> **
>> 
>> 
>> 
>> 
>>
>> after
>>
>> 
>> 
>> 
>> 48
>> 
>> 
>> 
>> D
>> 6
>> 
>> 48
>> 1
>> quarter
>> 1
>> 
>> 
>> 
>> G
>> 5
>> 
>> 48
>> 1
>> quarter
>> 1
>> 
>> 
>> 
>> D
>> 5
>> 
>> 48
>> 1
>> quarter
>> 1
>> 
>> 
>> 
>> 
>> 
>> 
>>
>>
>>
>>
>>
>>
>>
>>
>> **
>> 
>> 
>> G
>> 5
>> 
>> 48
>> 1
>> quarter
>> 1
>> 
>> 
>> 
>> 
>> 
>> 
>>
>

-- 
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 here. Follow @bbedit on Twitter: 
--- 
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 view this discussion on the web visit 
https://groups.google.com/d/msgid/bbedit/12abf2b1-9373-4b60-8647-36ac016b1c65n%40googlegroups.com.

Re: Grep help for musicxml

['Marcel Lamers' via BBEdit Talk]

It gets much simpler if I add e.g. a ! before every  first.
I can then search for
()([^!]+)()([^!]+)()

On Monday, 5 December 2022 at 17:13:42 UTC+1 Marcel Lamers wrote:

> Hi,
>
> I have a musicxml file that is not properly imported into my music 
> notation app and I have to change the syntax to do a better import.
> I gave it a go with grep but can't seem to get the proper pattern to make 
> the change.
>
> In short, I want to remove the dynamics tags plus content from a note tag 
> and place it before the note tag with new closing tags.
> Difficulty is the occurrence of several  tags and the greediness of 
> the patterns I tested.
> I also gave the must not occur (?!) a go but to no avail. Any 
> help in the matter would be greatly appreciated
>
> Here is an example:
>
> before
>
> 
> 
> 
> 48
> 
> 
> 
> D
> 6
> 
> 48
> 1
> quarter
> 1
> 
> 
> 
> G
> 5
> 
> 48
> 1
> quarter
> 1
> 
> 
> 
> D
> 5
> 
> 48
> 1
> quarter
> 1
> 
> 
> 
> 
> 
> 
> 
> 
> G
> 5
> 
> 48
> 1
> quarter
> 1
> 
> 
>
>
> **
> 
> 
> 
> 
>
> after
>
> 
> 
> 
> 48
> 
> 
> 
> D
> 6
> 
> 48
> 1
> quarter
> 1
> 
> 
> 
> G
> 5
> 
> 48
> 1
> quarter
> 1
> 
> 
> 
> D
> 5
> 
> 48
> 1
> quarter
> 1
> 
> 
> 
> 
> 
> 
>
>
>
>
>
>
>
>
> **
> 
> 
> G
> 5
> 
> 48
> 1
> quarter
> 1
> 
> 
> 
> 
> 
> 
>

-- 
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 here. Follow @bbedit on Twitter: 
--- 
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 view this discussion on the web visit 
https://groups.google.com/d/msgid/bbedit/10227a12-e144-4d6b-b6ff-05d6140ed85cn%40googlegroups.com.

Re: Grep help - removing text within a tag

[a k]

Thanks so much! This did the trick. I've been familiarizing myself with 
multi-file search and am very excited to now have such a powerful tool to 
use for these repetitive tasks. Hoping to learn more about grep as well as 
Text Factory

On Monday, October 10, 2022 at 4:46:33 PM UTC-5 fletc...@cumuli.com wrote:

> The find pattern would be "" with "Grep" checked. You 
> can use the Multi-File Search... dialog to run this against a folder 
> containing your .txt files to see how many matches there are.
>
> When I'm doing multi-file work like this I'll usually start out doing a 
> Find All in the multi-file dialog and looking at all the results. If it 
> looks like I want to do a replace all then I can go back into the dialog 
> and do that. The replace pattern would be blank if you want to remove the 
> iframe tags.
>
> If I need to be more discerning I'll work through each file by file in the 
> results using Find Next to make sure that I want to replace all the 
> iframes. Or refine the find pattern to be more specific.
>
> [fletcher]
>
>
> On Oct 10, 2022, at 2:22 PM, a k  wrote:
>
> Hey all, 
>
> I'm looking to use grep to remove text contained within a tag (including 
> the tag itself). More specifically - I need to find and remove a bunch of 
> iframe tags from multiple .txt files. 
>
> Here's an example tag:
>
> * src="https://website.com/1.0/ifr?zid=123456=${CACHEBUSTER}_imp=${AUC_ID}=${CLICK_URL_ENC};
>  
> "
>  
> frameborder="0" scrolling="no" width="123" height="456">*
>
> because the zid, width and height always differ and appear in other places 
> in the document (that need to be preserved) I cant do a regular find and 
> replace.
>
>  a complete beginner to BBEDIT and grep so apologies if this question is a 
> bit remedial. I have bunch of code cleanup tasks that are very repetitive 
> and I'm confident could be solved with grep, just not 100% sure how to go 
> about it.
>
> -- 
> This is the BBEdit Talk public discussion group. If you have a feature 
> request or need technical support, please email "sup...@barebones.com" 
> rather than posting here. Follow @bbedit on Twitter: <
> https://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+un...@googlegroups.com.
> To view this discussion on the web visit 
> https://groups.google.com/d/msgid/bbedit/ba2bdebc-1e4e-4849-ad21-bfea60bd00e4n%40googlegroups.com
>  
> 
> .
>
>

-- 
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 here. Follow @bbedit on Twitter: 
--- 
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 view this discussion on the web visit 
https://groups.google.com/d/msgid/bbedit/14bb00e7-7ea5-4a3a-8a89-4255ccfa927bn%40googlegroups.com.

Re: Grep help - removing text within a tag

[a k]

Sorry for being unclear - I want to remove the text so output would be blank

On Monday, October 10, 2022 at 4:45:42 PM UTC-5 Kaveh wrote:

> Can you put the output you expect for this string?
>
> On Mon, 10 Oct 2022 at 22:25, a k  wrote:
>
>> Hey all, 
>>
>> I'm looking to use grep to remove text contained within a tag (including 
>> the tag itself). More specifically - I need to find and remove a bunch of 
>> iframe tags from multiple .txt files. 
>>
>> Here's an example tag:
>>
>> *> src="https://website.com/1.0/ifr?zid=123456=${CACHEBUSTER}_imp=${AUC_ID}=${CLICK_URL_ENC};
>>  
>> "
>>  
>> frameborder="0" scrolling="no" width="123" height="456">*
>>
>> because the zid, width and height always differ and appear in other 
>> places in the document (that need to be preserved) I cant do a regular find 
>> and replace.
>>
>>  a complete beginner to BBEDIT and grep so apologies if this question is 
>> a bit remedial. I have bunch of code cleanup tasks that are very repetitive 
>> and I'm confident could be solved with grep, just not 100% sure how to go 
>> about it.
>>
>> -- 
>> This is the BBEdit Talk public discussion group. If you have a feature 
>> request or need technical support, please email "sup...@barebones.com" 
>> rather than posting here. Follow @bbedit on Twitter: <
>> https://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+un...@googlegroups.com.
>> To view this discussion on the web visit 
>> https://groups.google.com/d/msgid/bbedit/ba2bdebc-1e4e-4849-ad21-bfea60bd00e4n%40googlegroups.com
>>  
>> 
>> .
>>
>
>
> -- 
> Kaveh Bazargan PhD
> Director
> River Valley Technologies  ● Twitter 
>  ● LinkedIn 
>  ● ORCID 
> 
> *Accelerating the Communication of Research*
>

-- 
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 here. Follow @bbedit on Twitter: 
--- 
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 view this discussion on the web visit 
https://groups.google.com/d/msgid/bbedit/e27b4656-7359-4f97-8eec-0ae3d985f110n%40googlegroups.com.

Re: Grep help - removing text within a tag

[Fletcher Sandbeck]

The find pattern would be "" with "Grep" checked. You can 
use the Multi-File Search... dialog to run this against a folder containing 
your .txt files to see how many matches there are.

When I'm doing multi-file work like this I'll usually start out doing a Find 
All in the multi-file dialog and looking at all the results. If it looks like I 
want to do a replace all then I can go back into the dialog and do that. The 
replace pattern would be blank if you want to remove the iframe tags.

If I need to be more discerning I'll work through each file by file in the 
results using Find Next to make sure that I want to replace all the iframes. Or 
refine the find pattern to be more specific.

[fletcher]


> On Oct 10, 2022, at 2:22 PM, a k  wrote:
> 
> Hey all, 
> 
> I'm looking to use grep to remove text contained within a tag (including the 
> tag itself). More specifically - I need to find and remove a bunch of iframe 
> tags from multiple .txt files. 
> 
> Here's an example tag:
> 
>  src="https://website.com/1.0/ifr?zid=123456=${CACHEBUSTER}_imp=${AUC_ID}=${CLICK_URL_ENC}&;
>  frameborder="0" scrolling="no" width="123" height="456">
> 
> because the zid, width and height always differ and appear in other places in 
> the document (that need to be preserved) I cant do a regular find and replace.
> 
>  a complete beginner to BBEDIT and grep so apologies if this question is a 
> bit remedial. I have bunch of code cleanup tasks that are very repetitive and 
> I'm confident could be solved with grep, just not 100% sure how to go about 
> it.
> 
> -- 
> 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 here. Follow @bbedit on Twitter: 
> >
> --- 
> 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 view this discussion on the web visit 
> https://groups.google.com/d/msgid/bbedit/ba2bdebc-1e4e-4849-ad21-bfea60bd00e4n%40googlegroups.com
>  
> .

-- 
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 here. Follow @bbedit on Twitter: 
--- 
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 view this discussion on the web visit 
https://groups.google.com/d/msgid/bbedit/0FF11031-E720-46E2-9E11-9B27B1BB20D7%40cumuli.com.

Re: Grep help - removing text within a tag

[Kaveh]

Can you put the output you expect for this string?

On Mon, 10 Oct 2022 at 22:25, a k  wrote:

> Hey all,
>
> I'm looking to use grep to remove text contained within a tag (including
> the tag itself). More specifically - I need to find and remove a bunch of
> iframe tags from multiple .txt files.
>
> Here's an example tag:
>
> * src="https://website.com/1.0/ifr?zid=123456=${CACHEBUSTER}_imp=${AUC_ID}=${CLICK_URL_ENC};
> "
> frameborder="0" scrolling="no" width="123" height="456">*
>
> because the zid, width and height always differ and appear in other places
> in the document (that need to be preserved) I cant do a regular find and
> replace.
>
>  a complete beginner to BBEDIT and grep so apologies if this question is a
> bit remedial. I have bunch of code cleanup tasks that are very repetitive
> and I'm confident could be solved with grep, just not 100% sure how to go
> about it.
>
> --
> 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 here. Follow @bbedit on Twitter: <
> https://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 view this discussion on the web visit
> https://groups.google.com/d/msgid/bbedit/ba2bdebc-1e4e-4849-ad21-bfea60bd00e4n%40googlegroups.com
> 
> .
>


-- 
Kaveh Bazargan PhD
Director
River Valley Technologies  ● Twitter
 ● LinkedIn
 ● ORCID

*Accelerating the Communication of Research*

-- 
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 here. Follow @bbedit on Twitter: 
--- 
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 view this discussion on the web visit 
https://groups.google.com/d/msgid/bbedit/CAJ2R9pi%2Bv9R%2B%3DgULdOLuYyQAvYykYj0RRdPcOX44hEG6mRvdEg%40mail.gmail.com.

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

[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 
Maestro: the 1st just copy (clic & drag to select) the 4 row: receipt 
number, date, amount, cf, and put them all into the related variables. then 
it switch to chrome and calls the second one macro. Not so elegant, nor 
fully automated, but it's fast and safe and I can check it easily. as 
always sry for my english.

Il giorno venerdì 7 dicembre 2018 11:21:49 UTC+1, Christopher Stone ha 
scritto:
>
> On 12/06/2018, at 13:44, Christopher Stone  > 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 like this:
>
> 1 130,00 ABCDEF12G34H567I 22-04-2017
> 2 100,00 ABCDEF12G34H567I 22-04-2017
> 3 260,00 LMNOPQ89R01S234T 22-04-2017
> 5 23,00 LMNOPQ89R01S234T 22-04-2017
>
> I can write another script that will parse these into variables that can 
> be inserted into your web page.
>
> Each pass will show a line item as processed like so:
>
> [✓] 1 130,00 ABCDEF12G34H567I 22-04-2017
>
> If you set the windows of your web browser and BBEdit up just so, you can 
> get realtime visual feedback on each pass.
>
> --
> Best Regards,
> Chris
>
> 
> # Auth: Christopher Stone
> # dCre: 2018/12/04 16:04
> # dMod: 2018/12/07 02:43
> # Appl: BBEdit
> # Task: Extract Cash Register Info.
> # Libs: None
> # Osax: None
> # Tags: @Applescript, @Script, @BBEdit, @Extract, @Cash, @Register, @Info, 
> @BBEdit-Talk
> # Vers: 1.02
> 
>
> *set* AppleScript's text item delimiters *to* ""
>
> *tell* *application* "BBEdit"
> *tell* *front* *text window's* *text*
>
> 
> *replace* "^\\h+EURO\\h*\\n" using "" options {search mode:*grep*, 
> case sensitive:*false*, starting at top:*true*}
> *replace* "^\\h+$" using "" options {search mode:*grep*, case 
> sensitive:*false*, starting at top:*true*}
> *replace* "\\h+$" using "" options {search mode:*grep*, case 
> sensitive:*false*, starting at top:*true*}
> *replace* "\\n{2,}" using "\\n" options {search mode:*grep*, case 
> sensitive:*false*, starting at top:*true*}
> *replace* "^N\\.SCONTR\\.FISCALE.*" using "&\\n" options {search 
> mode:*grep*, case sensitive:*false*, starting at top:*true*}
> *replace* "\\A\\s+|\\s+\\Z" using "" options {search mode:*grep*, 
> case 
> sensitive:*false*, starting at top:*true*}
>
> 
> *set* docText *to* *its* *text*
> *set* AppleScript's text item delimiters *to* linefeed & linefeed
> *set* recordList *to* *text items* *of* docText
>
> 
> *repeat* *with* i *in* recordList
> *if* contents *of* i *does not* *contain* "C.F." *then*
> *set* contents *of* i *to* *missing value*
> *end* *if*
> *end* *repeat*
>
> 
> *set* recordList *to* (*text* *of* recordList) *as* *text*
> *set* *its* *text* *to* recordList
>
> 
> *replace* 
> "^(?>(?:(?!(?:t_fiscale|C\\.F\\.|\\d{2}-\\d{2}-\\d{4}|TOTALE 
> EURO)).)*)$\\R?" using "" options {search mode:*grep*, case sensitive:
> *false*, starting at top:*true*}
>
> 
> *replace* "^t_fiscale" using "\\n&" options {search mode:*grep*, case 
> sensitive:*false*, starting at top:*true*}
> *replace* "\\A\\s+|\\s+\\Z" using "" options {search mode:*grep*, 
> case 
> sensitive:*false*, starting at top:*true*}
>
> 
> *replace* "^t_fiscale \\d{8} \\d{4} *" using "" options {search 
> mode:*grep*, case sensitive:*false*, starting at top:*true*}
> *replace* "^TOTALE EURO\\h+" using "" options {search mode:*grep*, 
> case sensitive:*false*, starting at top:*true*}
> *replace* "C\\.F\\.\\h*" using "" options {search mode:*grep*, case 
> sensitive:*false*, starting at top:*true*}
> *replace* "^(\\d{2}-\\d{2}-\\d{4})\\h+\\d{2}:\\d{2}" using "\\1" 
> options {search mode:*grep*, case sensitive:*false*, starting at top:
> *true*}
> *replace* "(?<=\\w)\\R(?=\\w)" using "\\t" options {search mode:
> *grep*, case sensitive:*false*, starting at top:*true*}
> *replace* "^$\\R" using "" options {search mode:*grep*, case 
> sensitive:*false*, starting at top:*true*}
>
> 
> *select* *insertion point* *before* *it*
>
> 
> *end* *tell*
> *end* *tell*
>
> 
>
>

-- 
This is the BBEdit Talk public discussion group. If you have a 
feature request or need technical support, please 

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

[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 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 LENTI20,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 CONTATTO100,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 LENTI20,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  

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

[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\. +([\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 LENTI20,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 CONTATTO100,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 LENTI20,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
> CONTANTE8,00
> 
> CASSA:01
> 22-04-2017 10:55
> N.SCONTR.FISCALE   4
> t_fiscale 20170422 1826 *5*
>   EURO  
> SOLUZIONI LAC  23,00
> TOTALE EURO23,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  
>

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

[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 like this:

1   130,00  ABCDEF12G34H567I22-04-2017
2   100,00  ABCDEF12G34H567I22-04-2017
3   260,00  LMNOPQ89R01S234T22-04-2017
5   23,00   LMNOPQ89R01S234T22-04-2017

I can write another script that will parse these into variables that can be 
inserted into your web page.

Each pass will show a line item as processed like so:

[✓] 1   130,00  ABCDEF12G34H567I22-04-2017

If you set the windows of your web browser and BBEdit up just so, you can get 
realtime visual feedback on each pass.

--
Best Regards,
Chris


# Auth: Christopher Stone
# dCre: 2018/12/04 16:04
# dMod: 2018/12/07 02:43
# Appl: BBEdit
# Task: Extract Cash Register Info.
# Libs: None
# Osax: None
# Tags: @Applescript, @Script, @BBEdit, @Extract, @Cash, @Register, @Info, 
@BBEdit-Talk
# Vers: 1.02


set AppleScript's text item delimiters to ""

tell application "BBEdit"
tell front text window's text

replace "^\\h+EURO\\h*\\n" using "" options {search mode:grep, case 
sensitive:false, starting at top:true}
replace "^\\h+$" using "" options {search mode:grep, case 
sensitive:false, starting at top:true}
replace "\\h+$" using "" options {search mode:grep, case 
sensitive:false, starting at top:true}
replace "\\n{2,}" using "\\n" options {search mode:grep, case 
sensitive:false, starting at top:true}
replace "^N\\.SCONTR\\.FISCALE.*" using "&\\n" options {search 
mode:grep, case sensitive:false, starting at top:true}
replace "\\A\\s+|\\s+\\Z" using "" options {search mode:grep, case 
sensitive:false, starting at top:true}

set docText to its text
set AppleScript's text item delimiters to linefeed & linefeed
set recordList to text items of docText

repeat with i in recordList
if contents of i does not contain "C.F." then
set contents of i to missing value
end if
end repeat

set recordList to (text of recordList) as text
set its text to recordList

replace "^(?>(?:(?!(?:t_fiscale|C\\.F\\.|\\d{2}-\\d{2}-\\d{4}|TOTALE 
EURO)).)*)$\\R?" using "" options {search mode:grep, case sensitive:false, 
starting at top:true}

replace "^t_fiscale" using "\\n&" options {search mode:grep, case 
sensitive:false, starting at top:true}
replace "\\A\\s+|\\s+\\Z" using "" options {search mode:grep, case 
sensitive:false, starting at top:true}

replace "^t_fiscale \\d{8} \\d{4} *" using "" options {search 
mode:grep, case sensitive:false, starting at top:true}
replace "^TOTALE EURO\\h+" using "" options {search mode:grep, case 
sensitive:false, starting at top:true}
replace "C\\.F\\.\\h*" using "" options {search mode:grep, case 
sensitive:false, starting at top:true}
replace "^(\\d{2}-\\d{2}-\\d{4})\\h+\\d{2}:\\d{2}" using "\\1" options 
{search mode:grep, case sensitive:false, starting at top:true}
replace "(?<=\\w)\\R(?=\\w)" using "\\t" options {search mode:grep, 
case sensitive:false, starting at top:true}
replace "^$\\R" using "" options {search mode:grep, case 
sensitive:false, starting at top:true}

select insertion point before it

end tell
end tell



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

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

[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+) (\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 LENTI20,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 CONTATTO100,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 LENTI20,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
 CONTANTE8,00
 
 CASSA:01
 22-04-2017 10:55
 N.SCONTR.FISCALE   4
 t_fiscale 20170422 1826 *5*
   EURO  
 SOLUZIONI LAC  23,00
 TOTALE EURO23,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 

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

[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 there it's easy to write a macro to extract the data and insert it 
into your web page one line at a time.

--
Best Regards,
Chris


# Auth: Christopher Stone
# dCre: 2018/12/04 16:04
# dMod: 2018/12/06 13:37
# Appl: BBEdit
# Task: Extract Cash Register Info.
# Libs: None
# Osax: None
# Tags: @Applescript, @Script, @BBEdit, @Extract, @Cash, @Register, @Info, 
@BBEdit-Talk
# Vers: 1.01


set AppleScript's text item delimiters to ""

tell application "BBEdit"
tell front text window's text

replace "^\\h+EURO\\h*\\n" using "" options {search mode:grep, case 
sensitive:false, starting at top:true}
replace "^\\h+$" using "" options {search mode:grep, case 
sensitive:false, starting at top:true}
replace "\\n{2,}" using "\\n" options {search mode:grep, case 
sensitive:false, starting at top:true}
replace "^N\\.SCONTR\\.FISCALE.*" using "&\\n" options {search 
mode:grep, case sensitive:false, starting at top:true}
replace "\\A\\s+|\\s+\\Z" using "" options {search mode:grep, case 
sensitive:false, starting at top:true}

set docText to its text
set AppleScript's text item delimiters to linefeed & linefeed
set recordList to text items of docText

repeat with i in recordList
if contents of i does not contain "C.F." then
set contents of i to missing value
end if
end repeat

set recordList to (text of recordList) as text
set its text to recordList

replace "^(?>(?:(?!(?:t_fiscale|C\\.F\\.|\\d{2}-\\d{2}-\\d{4}|TOTALE 
EURO)).)*)$\\R?" using "" options {search mode:grep, case sensitive:false, 
starting at top:true}

replace "^t_fiscale" using "\\n&" options {search mode:grep, case 
sensitive:false, starting at top:true}
replace "\\A\\s+|\\s+\\Z" using "" options {search mode:grep, case 
sensitive:false, starting at top:true}

replace "^t_fiscale \\d{8} \\d{4} *" using "" options {search 
mode:grep, case sensitive:false, starting at top:true}
replace "^TOTALE EURO\\h+" using "" options {search mode:grep, case 
sensitive:false, starting at top:true}
replace "C\\.F\\.\\h*" using "" options {search mode:grep, case 
sensitive:false, starting at top:true}
replace "^(\\d{2}-\\d{2}-\\d{4})\\h+\\d{2}:\\d{2}" using "\\1" options 
{search mode:grep, case sensitive:false, starting at top:true}

select insertion point before it

end tell
end tell



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

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

[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 
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 LENTI20,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 CONTATTO100,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 LENTI20,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
>>> CONTANTE8,00
>>> 
>>> CASSA:01
>>> 22-04-2017 10:55
>>> N.SCONTR.FISCALE   4
>>> t_fiscale 20170422 1826 *5*
>>>   EURO  
>>> SOLUZIONI LAC  23,00
>>> TOTALE EURO23,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
>>> *FATTURE0,00
>>> *RICEVUTE   0,00
>>> NOTE DI 

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

[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 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 
>> +([0-9,]+).+?C\.F\. +([\w,]+)
>>
>> I used this with the extract option
>>
>
ohh yess,  that also works! kudos
thank you

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

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

[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 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 LENTI20,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 CONTATTO100,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 LENTI20,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
>> CONTANTE8,00
>> 
>> CASSA:01
>> 22-04-2017 10:55
>> N.SCONTR.FISCALE   4
>> t_fiscale 20170422 1826 *5*
>>   EURO  
>> SOLUZIONI LAC  23,00
>> TOTALE EURO23,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
>> *FATTURE0,00
>> *RICEVUTE   0,00
>> NOTE DI CREDITO GIORN.  
>> 0,00
>> 
>> 
>>DETTAGLIO
>>OPERAZIONI   
>> 
>> SCONTI  0,00
>>   N.0   
>> MAGGIORAZ.  0,00
>>   N.0   
>> BONIFICI0,00
>>   N.0   
>> RETTIFICHE  0,00
>>   N.0   
>> CORRISP. NON RISCOSSI   
>> *SCONTRINI  0,00
>> *RICEVUTE   0,00
>> CORRISP. RISCOSSI   
>> *SCONTRINI  1 234,00
>> *FATTURE0,00
>> *RICEVUTE   0,00
>> 
>> 
>>DOCUMENTI
>>   GIORNALIERI   
>> 
>> N.SCONTR.FISCALI   6
>> *N.SCONTR./NOTE 

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

[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 
> +([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 LENTI20,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 CONTATTO100,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 LENTI20,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
>> CONTANTE8,00
>> 
>> CASSA:01
>> 22-04-2017 10:55
>> N.SCONTR.FISCALE   4
>> t_fiscale 20170422 1826 *5*
>>   EURO  
>> SOLUZIONI LAC  23,00
>> TOTALE EURO23,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
>> *FATTURE0,00
>> *RICEVUTE   0,00
>> NOTE DI CREDITO GIORN.  
>> 0,00
>> 
>> 
>>DETTAGLIO
>>OPERAZIONI   
>> 
>> SCONTI  0,00
>>   N.0   
>> MAGGIORAZ.  0,00
>>   N.0   
>> BONIFICI0,00
>>   N.0   
>> RETTIFICHE  0,00
>>   N.0   
>> CORRISP. NON RISCOSSI   
>> *SCONTRINI  0,00
>> *RICEVUTE   0,00
>> CORRISP. RISCOSSI   
>> *SCONTRINI  1 234,00
>> *FATTURE0,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 

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

[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 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 LENTI20,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 CONTATTO100,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 LENTI20,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
> CONTANTE8,00
> 
> CASSA:01
> 22-04-2017 10:55
> N.SCONTR.FISCALE   4
> t_fiscale 20170422 1826 *5*
>   EURO  
> SOLUZIONI LAC  23,00
> TOTALE EURO23,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
> *FATTURE0,00
> *RICEVUTE   0,00
> NOTE DI CREDITO GIORN.  
> 0,00
> 
> 
>DETTAGLIO
>OPERAZIONI   
> 
> SCONTI  0,00
>   N.0   
> MAGGIORAZ.  0,00
>   N.0   
> BONIFICI0,00
>   N.0   
> RETTIFICHE  0,00
>   N.0   
> CORRISP. NON RISCOSSI   
> *SCONTRINI  0,00
> *RICEVUTE   0,00
> CORRISP. RISCOSSI   
> *SCONTRINI  1 234,00
> *FATTURE0,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.RICEVUTE0
> 
> 
>  DATI GENERALI  
> 
> N.LETT.MEM.FISCALE 0
> 
> PROGR. AZZERAMENTI   960
> NUM. 

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

[@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, failed and after many attempts I decided to ask.
> If it were possible I would also like the date separator to be / instead of -

The grep for the date is pretty straightforward, since you can match on 
# and I assume that the date is going to be the same on all the 
transactions. So grab the date and deal with the amount and CF separately.

It should be possible to setup a grep that looks for

fiscal[stuff](date)(number)[end of line][anystuff] EURO (numbers a comma 
numbers)[end of line][anystuff]C.F.[spaces](alphanumerics)[space][endofline]

\1 contains your date, and you can format it however you want ()(..)(..) 
gives you  mm dd
\2 contains your (transaction) number
\3 the Euro amount
\4 the C.F. ID

If you have a scanner that supports OCR (including an iOS app), scanning the 
receipts and putting them somewhere on your computer means that Hazel would be 
able to process the recipes automatically. Add an AppleScript and you can 
probably automate the submission to your web portal.

(It would take me a long time to build the actual grep, but basically the idea 
is there and some playing with it will yield something that works)

-- 
'He's mad, isn't he?' 'No, mad's when you froth at the mouth,' said
Gaspode. ' He's insane. That's when you froth at the brain.’





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

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

[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: Schermata 2018-12-05 alle 09.23.59.png]
 

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

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

[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, and I have to insert one receipt at a time, sigh.
> Only sales that have the "C.F." are valid.
>
> --
>
> Hey M.,
>
> This is a bit of a sticky problem, so I'm not surprised you had problems 
> when relying on grep alone.
>
> Run this AppleScript from the Applescript Editor against your register 
> tape in BBEdit.
>
> I believe I've extracted the relevant data from the tape.
>

Thank you Chris, this just _works_ !!!
You scripters save my life from time to time :)
-m

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

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

[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 that have the "C.F." are valid.


Hey M.,

This is a bit of a sticky problem, so I'm not surprised you had problems when 
relying on grep alone.

Run this AppleScript from the Applescript Editor against your register tape in 
BBEdit.

I believe I've extracted the relevant data from the tape.  If so then we need 
another pass to get just the values you want.

>From there it shouldn't be hard to pop those values into Keyboard Maestro 
>variables for insertion into your web page.

--
Best Regards,
Chris


# Auth: Christopher Stone
# dCre: 2018/12/04 16:04
# dMod: 2018/12/04 16:04 
# Appl: BBEdit
# Task: Extract Cash Register Info.
# Libs: None
# Osax: None
# Tags: @Applescript, @Script, @BBEdit, @Extract, @Cash, @Register, @Info, 
@BBEdit-Talk


set AppleScript's text item delimiters to ""

tell application "BBEdit"
tell front text window's text

replace "^\\h+EURO\\h*\\n" using "" options {search mode:grep, case 
sensitive:false, starting at top:true}
replace "^\\h+$" using "" options {search mode:grep, case 
sensitive:false, starting at top:true}
replace "\\n{2,}" using "\\n" options {search mode:grep, case 
sensitive:false, starting at top:true}
replace "^N\\.SCONTR\\.FISCALE.*" using "&\\n" options {search 
mode:grep, case sensitive:false, starting at top:true}
replace "\\A\\s+|\\s+\\Z" using "" options {search mode:grep, case 
sensitive:false, starting at top:true}

set docText to its text
set AppleScript's text item delimiters to linefeed & linefeed
set recordList to text items of docText

repeat with i in recordList
if contents of i does not contain "C.F." then
set contents of i to missing value
end if
end repeat

set recordList to (text of recordList) as text
set its text to recordList

replace "^(?>(?:(?!(?:t_fiscale|C\\.F\\.|\\d{2}-\\d{2}-\\d{4}|TOTALE 
EURO)).)*)$\\R?" using "" options {search mode:grep, case sensitive:false, 
starting at top:true}
replace "^t_fiscale" using "\\n&" options {search mode:grep, case 
sensitive:false, starting at top:true}
replace "\\A\\s+|\\s+\\Z" using "" options {search mode:grep, case 
sensitive:false, starting at top:true}

select insertion point before it

end tell
end tell



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

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

[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 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: 
> ---
> You received this message because you are subscribed to the Google Groups 
> "BBEdit Talk" group.
> To unsubscribe from this 

Re: grep help coordinates

[Marek Stepanek]

On 05.03.18 22:49, Steve Wilson wrote:
> Need help trying to figure out how to do a grep search and replace in BBEdit 
> of a couple of coordinates into KML. 
> Unfortunately the order of the lat/long needs to be flipped.
> Here is what it looks like:
> 
> (32.839098817184, -97.303764761793)
> 
> And I need it to look like this:
> 
> -97.303764761793,32.839098817184,0.0
> 
> Thanks for any help
> 


Hello Steve!


I don't know, whether there are some more characters around your data.

If the coordinates are pure one per line, this should work with grep:

search:
^(-?\d\d\.\d{12}),\s*(-?\d\d\.\d{12})\s*$

replace:
\02,\01,0.0


best greetings


marek


-- 
This is the BBEdit Talk public discussion group. If you have a 
feature request or would like to report a problem, please email
"supp...@barebones.com" rather than posting to the group.
Follow @bbedit on Twitter: 
--- 
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.

Re: grep help coordinates

[Steve Wilson]

Thanks!

-- 
This is the BBEdit Talk public discussion group. If you have a 
feature request or would like to report a problem, please email
"supp...@barebones.com" rather than posting to the group.
Follow @bbedit on Twitter: 
--- 
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.

Re: grep help coordinates

[Fletcher Sandbeck]

Something like this should do it. The unescaped parentheses define groups which 
are referred to by \1 and \2 in the replacement pattern. The escaped 
parentheses match the actual parentheses around the coordinates.

Find: \(([0-9.-]+), ([0-9.-]+)\)
Replace: \2,\1

Hope this helps,

[fletcher]


> On Mar 5, 2018, at 1:49 PM, Steve Wilson  wrote:
> 
> Need help trying to figure out how to do a grep search and replace in BBEdit 
> of a couple of coordinates into KML. 
> Unfortunately the order of the lat/long needs to be flipped.
> Here is what it looks like:
> 
> (32.839098817184, -97.303764761793)
> 
> And I need it to look like this:
> 
> -97.303764761793,32.839098817184,0.0
> 
> Thanks for any help
> 
> -- 
> This is the BBEdit Talk public discussion group. If you have a 
> feature request or would like to report a problem, please email
> "supp...@barebones.com" rather than posting to the group.
> Follow @bbedit on Twitter: 
> --- 
> 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.

-- 
This is the BBEdit Talk public discussion group. If you have a 
feature request or would like to report a problem, please email
"supp...@barebones.com" rather than posting to the group.
Follow @bbedit on Twitter: 
--- 
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.

Re: Grep help

[Lee Hinde]

Thanks. The sed example turned out to be recursive. Page 189 on the current
beta manual.

On Wed, Oct 11, 2017 at 1:15 PM, @lbutlr  wrote:

> On Oct 6, 2017, at 4:05 PM, Lee Hinde  wrote:
> > 
> >
> > I want to change all occurrences of a semi-colon within a url to
> something else, like .
> >
> > I started with this search string:
> >
> > (href=\".*);(.*\"[ ,>])
> >
> > and this replacement string:
> >
> > \1\\2
>
> One issue is that what you are replacing is contained in what you want to
> replace WITH, so you need to replace the semicolons that aren't part of the
> '' string.
>
> You'll need to check the BBEdit manual on this, starting not he bottom of
> page 187 of the 11.6 manual.
>
> "Positional Assertions
>
> Positional assertions “anchor” a pattern, without actually matching any
> characters."
>
> (?
> For example.
>
> --
> Apple broke AppleScripting signatures in Mail.app, so no random signatures.
>
>

-- 
This is the BBEdit Talk public discussion group. If you have a 
feature request or would like to report a problem, please email
"supp...@barebones.com" rather than posting to the group.
Follow @bbedit on Twitter: 
--- 
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.

Re: Grep help

[@lbutlr]

On Oct 6, 2017, at 4:05 PM, Lee Hinde  wrote:
> 
> 
> I want to change all occurrences of a semi-colon within a url to something 
> else, like .
> 
> I started with this search string:
> 
> (href=\".*);(.*\"[ ,>])
> 
> and this replacement string:
> 
> \1\\2

One issue is that what you are replacing is contained in what you want to 
replace WITH, so you need to replace the semicolons that aren't part of the 
'' string.

You'll need to check the BBEdit manual on this, starting not he bottom of page 
187 of the 11.6 manual.

"Positional Assertions

Positional assertions “anchor” a pattern, without actually matching any 
characters."

(?http://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.

Re: Grep help

[Lee Hinde]

thanks.

On Sun, Oct 8, 2017 at 9:24 AM, Roland Küffner 
wrote:

> Although this is the BBEdit forum, I would recommend good 'ol "sed" from
> the command line for this job. Something like this should work:
>
> sed '/new.html
>
> to do it on all files in the working directory:
> find . -name '*.txt' -exec sed -i '' '/
> Or, less cryptic, open the file in vim. Here, the same command would be
> :/
> These examples replace every ":" with "" only on lines that contain
> " - please adapt). And of course: try this on copies first - no guarantee,
> that command does not wreak havoc upon your files :-)
>
> To bring this back to BBEdit: It would be a nice addition if BBEdit's
> search window would someday get an additional "only search lines matching a
> pattern" functionality :-)
>
> Roland
>
> On Sat, Oct 7, 2017 at 12:05 AM, Lee Hinde  wrote:
>
>> I've taken over a project and have many many html files with strings like
>> this:
>>
>> 
>>
>> I want to change all occurrences of a semi-colon within a url to
>> something else, like .
>>
>> I started with this search string:
>>
>> (href=\".*);(.*\"[ ,>])
>>
>> and this replacement string:
>>
>> \1\\2
>>
>> The problem is it is only replacing one of the semi-colons (and oddly, to
>> me, not the first one) and I'd like to replace all of them.
>>
>> Pointers would be appreciated.
>>
>>
>

-- 
This is the BBEdit Talk public discussion group. If you have a 
feature request or would like to report a problem, please email
"supp...@barebones.com" rather than posting to the group.
Follow @bbedit on Twitter: 
--- 
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.

Re: Grep help

[Roland Küffner]

Although this is the BBEdit forum, I would recommend good 'ol "sed" from
the command line for this job. Something like this should work:

sed '/new.html

to do it on all files in the working directory:
find . -name '*.txt' -exec sed -i '' '/ wrote:

> I've taken over a project and have many many html files with strings like
> this:
>
> 
>
> I want to change all occurrences of a semi-colon within a url to something
> else, like .
>
> I started with this search string:
>
> (href=\".*);(.*\"[ ,>])
>
> and this replacement string:
>
> \1\\2
>
> The problem is it is only replacing one of the semi-colons (and oddly, to
> me, not the first one) and I'd like to replace all of them.
>
> Pointers would be appreciated.
>
> --
> This is the BBEdit Talk public discussion group. If you have a
> feature request or would like to report a problem, please email
> "supp...@barebones.com" rather than posting to the group.
> Follow @bbedit on Twitter: 
> ---
> 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.
>

-- 
This is the BBEdit Talk public discussion group. If you have a 
feature request or would like to report a problem, please email
"supp...@barebones.com" rather than posting to the group.
Follow @bbedit on Twitter: 
--- 
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.

Re: Grep help

[Ronald J Kimball]

On Mon, Feb 17, 2014 at 09:32:24PM -0800, Alan Truly wrote:
 Another case to be wary of is if you have double quotes in your text. They 
 are encoded in the CSV as 2 double quotes. 
 
 So for example:
 
 name story
 George  He said, Hello!
 JeffI agree with George
 
 Would be encoded as:
 name,story
 George,He said, Hello!
 Jeff,I agree with George
 
 In this scenario, Christopher's grep works, but Ronald's fails.

I forgot to account for double quotes within the field containing the
comma.  Here's the fixed version:

(\(?:[^\,\r]|\\)*),((?:[^\\r]|\\)*\)(?=(?:,(?:[^\,\r]+|\(?:[^\\r]|\\)*\))*$)


Note that Christopher's grep does not account for enclosed double quotes at
all.  It happens to work on your sample input, but it turns
,field
into
 field


Ronald

-- 
This is the BBEdit Talk public discussion group. If you have a 
feature request or would like to report a problem, please email
supp...@barebones.com rather than posting to the group.
Follow @bbedit on Twitter: http://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.

Re: Grep help

[Alan Truly]

No offense meant Ronald. You obviously have a strong understanding of grep. 
There are just so many issues involved with CSV parsing that it is hard to 
catch all of the cases.
 

 Note that Christopher's grep does not account for enclosed double quotes 
 at 
 all.  It happens to work on your sample input, but it turns 
 ,field 
 into 
  field 


 Ronald 


-- 
This is the BBEdit Talk public discussion group. If you have a 
feature request or would like to report a problem, please email
supp...@barebones.com rather than posting to the group.
Follow @bbedit on Twitter: http://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.

Re: Grep help?

[Rod Buchanan]

On Feb 21, 2013, at 9:22 PM, Oliver Taylor wrote:

 On Feb 21, 2013, at 3:58 AM, Kendall Conrad angelw...@gmail.com wrote:
 
 I had to switch the \n to \r before that would work.
 
 \n and \r are interchangeable in 10.5+

Sure, now that I finally got myself trained to type '\r'. :)

-- 
Rod Buchanan

-- 
-- 
You received this message because you are subscribed to the 
BBEdit Talk discussion group on Google Groups.
To post to this group, send email to bbedit@googlegroups.com
To unsubscribe from this group, send email to
bbedit+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/bbedit?hl=en
If you have a feature request or would like to report a problem, 
please email supp...@barebones.com rather than posting to the group.
Follow @bbedit on Twitter: http://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.
For more options, visit https://groups.google.com/groups/opt_out.

Re: Grep help?

[Kendall Conrad]

I had to switch the \n to \r before that would work.

Nice approach to it.

-Kendall


On Thursday, February 21, 2013 12:49:46 AM UTC-5, Oliver Taylor wrote:

 On Feb 20, 2013, at 5:47 PM, Lorin Rivers lri...@mosasaur.comjavascript: 
 wrote:

 Oh Mighty Ones,

 I have a big list that looks something like this:
 speedo_705494_001.jpg
 speedo_7051210_418.jpg
 speedo_7051210_418_bk.jpg
 speedo_7051200_041.jpg
 speedo_7051200_041_bk.jpg
 speedo_7051200_041_bk_a.jpg
 speedo_7050911_173.jpg
 speedo_7050911_173_bk.jpg
 speedo_7050804_001.jpg
 speedo_7050804_001_bk.jpg
 speedo_705032_001.jpg
 speedo_705031_001.jpg

 and I want to make it like this:
 speedo_705494_001.jpg
 speedo_7051210_418.jpg,speedo_7051210_418_bk.jpg

 speedo_7051200_041.jpg,speedo_7051200_041_bk.jpg,speedo_7051200_041_bk_a.jpg
 speedo_7050911_173.jpg,speedo_7050911_173_bk.jpg
 speedo_7050804_001.jpg,speedo_7050804_001_bk.jpg
 speedo_705032_001.jpg
 speedo_705031_001.jpg


 My brain is dead and I can't figure it out.

 Anyone have a suggestion for a regex that will accomplish this?


 Search: *\n(.+bk(_a)?.jpg)+*
 Replace: *,\1*


-- 
-- 
You received this message because you are subscribed to the 
BBEdit Talk discussion group on Google Groups.
To post to this group, send email to bbedit@googlegroups.com
To unsubscribe from this group, send email to
bbedit+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/bbedit?hl=en
If you have a feature request or would like to report a problem, 
please email supp...@barebones.com rather than posting to the group.
Follow @bbedit on Twitter: http://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.
For more options, visit https://groups.google.com/groups/opt_out.

Re: Grep help?

[Sumtingwong]

Here is what I came up with, also going to need a couple of passes.  

On the first run:

Find: 

\.jpg\n(.*?\_bk\_?.+)

Replace with:

\.jpg,\1

On the second run:

Find:

\.jpg\n(.*?\_bk\_.+)

Replace with the same as the first one:

\.jpg,\1

Hope this works!

Cheers,

Spencer

-- 
-- 
You received this message because you are subscribed to the 
BBEdit Talk discussion group on Google Groups.
To post to this group, send email to bbedit@googlegroups.com
To unsubscribe from this group, send email to
bbedit+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/bbedit?hl=en
If you have a feature request or would like to report a problem, 
please email supp...@barebones.com rather than posting to the group.
Follow @bbedit on Twitter: http://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.
For more options, visit https://groups.google.com/groups/opt_out.

Re: Grep help?

[Oliver Taylor]

On Feb 21, 2013, at 3:58 AM, Kendall Conrad angelw...@gmail.com wrote:

 I had to switch the \n to \r before that would work.

\n and \r are interchangeable in 10.5+

-- 
-- 
You received this message because you are subscribed to the 
BBEdit Talk discussion group on Google Groups.
To post to this group, send email to bbedit@googlegroups.com
To unsubscribe from this group, send email to
bbedit+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/bbedit?hl=en
If you have a feature request or would like to report a problem, 
please email supp...@barebones.com rather than posting to the group.
Follow @bbedit on Twitter: http://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.
For more options, visit https://groups.google.com/groups/opt_out.

Re: Grep help?

[Kendall Conrad]

I couldn't see a way to get a 100% solution with just one grep run, but 
this works for items that have two, but not when there's three. If you run 
the same regex replace all multiple times it will accommodate more than two.

Find:
((\w+_\d+_\d+).*\.jpg)(\r(\2(.*\.jpg)))

Replace with:
\1,\4

-Kendall


On Wednesday, February 20, 2013 8:47:14 PM UTC-5, Lorin Rivers wrote:

 Oh Mighty Ones, 

 I have a big list that looks something like this: 
 speedo_705494_001.jpg 
 speedo_7051210_418.jpg 
 speedo_7051210_418_bk.jpg 
 speedo_7051200_041.jpg 
 speedo_7051200_041_bk.jpg 
 speedo_7051200_041_bk_a.jpg 
 speedo_7050911_173.jpg 
 speedo_7050911_173_bk.jpg 
 speedo_7050804_001.jpg 
 speedo_7050804_001_bk.jpg 
 speedo_705032_001.jpg 
 speedo_705031_001.jpg 

 and I want to make it like this: 
 speedo_705494_001.jpg 
 speedo_7051210_418.jpg,speedo_7051210_418_bk.jpg 
 speedo_7051200_041.jpg,speedo_7051200_041_bk.jpg,speedo_7051200_041_bk_a.jpg 

 speedo_7050911_173.jpg,speedo_7050911_173_bk.jpg 
 speedo_7050804_001.jpg,speedo_7050804_001_bk.jpg 
 speedo_705032_001.jpg 
 speedo_705031_001.jpg 


 My brain is dead and I can't figure it out. 

 Anyone have a suggestion for a regex that will accomplish this? 

 Thanks! 
 -- 
 Lorin Rivers 
 Mosasaur: Killer Technical Marketing http://www.mosasaur.com 
 mailto:lri...@mosasaur.com javascript: 
 512/203.3198 (m) 




-- 
-- 
You received this message because you are subscribed to the 
BBEdit Talk discussion group on Google Groups.
To post to this group, send email to bbedit@googlegroups.com
To unsubscribe from this group, send email to
bbedit+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/bbedit?hl=en
If you have a feature request or would like to report a problem, 
please email supp...@barebones.com rather than posting to the group.
Follow @bbedit on Twitter: http://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.
For more options, visit https://groups.google.com/groups/opt_out.

Re: Grep help?

[Oliver Taylor]

On Feb 20, 2013, at 5:47 PM, Lorin Rivers lriv...@mosasaur.com wrote:

 Oh Mighty Ones,
 
 I have a big list that looks something like this:
 speedo_705494_001.jpg
 speedo_7051210_418.jpg
 speedo_7051210_418_bk.jpg
 speedo_7051200_041.jpg
 speedo_7051200_041_bk.jpg
 speedo_7051200_041_bk_a.jpg
 speedo_7050911_173.jpg
 speedo_7050911_173_bk.jpg
 speedo_7050804_001.jpg
 speedo_7050804_001_bk.jpg
 speedo_705032_001.jpg
 speedo_705031_001.jpg
 
 and I want to make it like this:
 speedo_705494_001.jpg
 speedo_7051210_418.jpg,speedo_7051210_418_bk.jpg
 speedo_7051200_041.jpg,speedo_7051200_041_bk.jpg,speedo_7051200_041_bk_a.jpg
 speedo_7050911_173.jpg,speedo_7050911_173_bk.jpg
 speedo_7050804_001.jpg,speedo_7050804_001_bk.jpg
 speedo_705032_001.jpg
 speedo_705031_001.jpg
 
 
 My brain is dead and I can't figure it out.
 
 Anyone have a suggestion for a regex that will accomplish this?

Search: \n(.+bk(_a)?.jpg)+
Replace: ,\1

-- 
-- 
You received this message because you are subscribed to the 
BBEdit Talk discussion group on Google Groups.
To post to this group, send email to bbedit@googlegroups.com
To unsubscribe from this group, send email to
bbedit+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/bbedit?hl=en
If you have a feature request or would like to report a problem, 
please email supp...@barebones.com rather than posting to the group.
Follow @bbedit on Twitter: http://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.
For more options, visit https://groups.google.com/groups/opt_out.

Re: grep help

[Terje Bless]

On Sun, Aug 5, 2012 at 6:20 AM, Steven katesglad...@gmail.com wrote:
 I am trying to remove a date string from an SQL file.

 I have ,'\d\d\d\d\-\d\d\-\d\d \d\d:\d\d:\d\d', as the string I wish to
 replace with  ,

 It does not like that.

What does does not like that mean? That it finds no matches? Or do
you see something that indicates an error?

 I assume I have to \- because - is a character grep uses

You should generally not need to escape the hyphen outside of
character classes (enclosed between [ and ]).

And to get help with this problem you really do need to provide an
example of the data you're trying to match against.

-link

-- 
-- 
You received this message because you are subscribed to the 
BBEdit Talk discussion group on Google Groups.
To post to this group, send email to bbedit@googlegroups.com
To unsubscribe from this group, send email to
bbedit+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/bbedit?hl=en
If you have a feature request or would like to report a problem, 
please email supp...@barebones.com rather than posting to the group.
Follow @bbedit on Twitter: http://www.twitter.com/bbedit

Re: grep help

[Steven]

As maarten guessed, I am trying to remove 560 instances of a date from an 
SQL file.   So I am looking for a way to grab everything from one comma to 
the other and including the quotes, all the numbers and dashes  and dots 
and replace it with one single comma,

Maarten's method didn't work either. It just goes beep and says not found.

On Monday, August 6, 2012 2:31:23 AM UTC-7, Terje Bless wrote:

 On Sun, Aug 5, 2012 at 6:20 AM, Steven  wrote: 
  I am trying to remove a date string from an SQL file. 
  
  I have ,'\d\d\d\d\-\d\d\-\d\d \d\d:\d\d:\d\d', as the string I wish to 
  replace with  , 
  
  It does not like that. 

 What does does not like that mean? That it finds no matches? Or do 
 you see something that indicates an error? 

  I assume I have to \- because - is a character grep uses 

 You should generally not need to escape the hyphen outside of 
 character classes (enclosed between [ and ]). 

 And to get help with this problem you really do need to provide an 
 example of the data you're trying to match against. 

 -link 


-- 
-- 
You received this message because you are subscribed to the 
BBEdit Talk discussion group on Google Groups.
To post to this group, send email to bbedit@googlegroups.com
To unsubscribe from this group, send email to
bbedit+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/bbedit?hl=en
If you have a feature request or would like to report a problem, 
please email supp...@barebones.com rather than posting to the group.
Follow @bbedit on Twitter: http://www.twitter.com/bbedit

Re: grep help

[Maarten Sneep]

Hi,

On 6 aug. 2012, at 15:45, Steven katesglad...@gmail.com wrote:

 As maarten guessed, I am trying to remove 560 instances of a date from an SQL 
 file.   So I am looking for a way to grab everything from one comma to the 
 other and including the quotes, all the numbers and dashes  and dots and 
 replace it with one single comma,
 
 Maarten's method didn't work either. It just goes beep and says not found.

You really need to provide us with an example. My crystal ball is working 
poorly right now.

Maarten

-- 
-- 
You received this message because you are subscribed to the 
BBEdit Talk discussion group on Google Groups.
To post to this group, send email to bbedit@googlegroups.com
To unsubscribe from this group, send email to
bbedit+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/bbedit?hl=en
If you have a feature request or would like to report a problem, 
please email supp...@barebones.com rather than posting to the group.
Follow @bbedit on Twitter: http://www.twitter.com/bbedit

Re: grep help

[John Delacour]

At 21:20 -0700 4/8/12, Steven wrote:



I am trying to remove a date string from an SQL file.

I have ,'\d\d\d\d\-\d\d\-\d\d \d\d:\d\d:\d\d', as the string I wish 
to replace with  ,


It does not like that.

I assume I have to \- because - is a character grep uses



The search pattern on the next line, with or without escaped hyphens:
,'\d\d\d\d-\d\d-\d\d \d\d:\d\d:\d\d',

will find strings like this:

,'2012-08-08 22:22:22',

in a plain text file.

What is your difficulty?

JD


--
--
You received this message because you are subscribed to the 
BBEdit Talk discussion group on Google Groups.

To post to this group, send email to bbedit@googlegroups.com
To unsubscribe from this group, send email to
bbedit+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/bbedit?hl=en
If you have a feature request or would like to report a problem, 
please email supp...@barebones.com rather than posting to the group.

Follow @bbedit on Twitter: http://www.twitter.com/bbedit

Re: grep help

[Bruce Van Allen]

On 8/4/12 at 9:20 PM, katesglad...@gmail.com (Steven) wrote:


I am trying to remove a date string from an SQL file.


From an SQL database file? Are you searching for text directly 
in that type of file? Which SQL database management system are 
you using?


??


   - Bruce

_bruce__van_allen__santa_cruz_ca_

--
--
You received this message because you are subscribed to the 
BBEdit Talk discussion group on Google Groups.

To post to this group, send email to bbedit@googlegroups.com
To unsubscribe from this group, send email to
bbedit+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/bbedit?hl=en
If you have a feature request or would like to report a problem, 
please email supp...@barebones.com rather than posting to the group.

Follow @bbedit on Twitter: http://www.twitter.com/bbedit

Re: grep help

[Maarten Sneep]

On 5 aug. 2012, at 06:20, Steven katesglad...@gmail.com wrote:

 I am trying to remove a date string from an SQL file.
 
 I have ,'\d\d\d\d\-\d\d\-\d\d \d\d:\d\d:\d\d', as the string I wish to 
 replace with  ,   
 
 It does not like that.
 
 I assume I have to \- because - is a character grep uses

Your question is somewhat incomplete, but let me try. The question would 
improve if you give a sample of the string you are looking for ('2012-08-05 
15:53:08', with or without the quotes?), and a clear indication what it should 
be replaced with ('').

1) Make sure that 'grep' is checked in the find window.
2) Try '[[:digit:]]{4}-[[:digit:]]{2}-[[:digit:]]{2} 
[[:digit:]]{2}:[[:digit:]]{2}:[[:digit:]]{2}' as the search string. 

   - [[:digit:]] is a character class that contains all digits. 
 I find this more readable than \d, but that would work too.
   - [[:digit:]]{4} searches for exactly 4 digits in a row. 
   - the rest are literals.

Hope this helps,

Maarten

-- 
-- 
You received this message because you are subscribed to the 
BBEdit Talk discussion group on Google Groups.
To post to this group, send email to bbedit@googlegroups.com
To unsubscribe from this group, send email to
bbedit+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/bbedit?hl=en
If you have a feature request or would like to report a problem, 
please email supp...@barebones.com rather than posting to the group.
Follow @bbedit on Twitter: http://www.twitter.com/bbedit

Re: GREP help

[Ronald J Kimball]

On Mon, Apr 16, 2012 at 10:54:55AM -0700, David wrote:
 I need some Grep help.
 
 I need to remove this type of entry from a large file.
 
 No Fly List:
 101508
 100698
 
 Other options
 
 
 ignore the quotation marks, I added them to illustrate the start and
 end of the string.
 
 Each six digit employee number begins with 1. Each line ends with a
 carriage return.
 
 The problem for a newbie like me is that there may be one or twenty
 employee numbers, each on its own line, and I'm not sure how to handle
 that. There is no hard limit on the number of 1x numbers to search
 for between No Fly List:\r   and Other Options

One line containing an employee number:

[ \t]*1\d{5}\r

One or more lines containing an employee number:

([ \t]*1\d{5}\r)+

:)


So, the complete pattern might look like this:

(?m)No Fly List:\r(\s*1\d{5}\r)+\rOther options


Ronald

-- 
You received this message because you are subscribed to the 
BBEdit Talk discussion group on Google Groups.
To post to this group, send email to bbedit@googlegroups.com
To unsubscribe from this group, send email to
bbedit+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/bbedit?hl=en
If you have a feature request or would like to report a problem, 
please email supp...@barebones.com rather than posting to the group.
Follow @bbedit on Twitter: http://www.twitter.com/bbedit

Re: GREP help

[David]

Ron,

Perfect! Thanks (again)!

Best regards,

David

-- 
You received this message because you are subscribed to the 
BBEdit Talk discussion group on Google Groups.
To post to this group, send email to bbedit@googlegroups.com
To unsubscribe from this group, send email to
bbedit+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/bbedit?hl=en
If you have a feature request or would like to report a problem, 
please email supp...@barebones.com rather than posting to the group.
Follow @bbedit on Twitter: http://www.twitter.com/bbedit

RE: grep help

[Rick Gordon]

FIND:
(th scope=row.?*)/td

CHANGE TO:
\1/th

--

On 3/26/12 at 12:23 PM -0700, JT wrote in a message entitled
grep help:

  I'm trying to replace the  /td in a long table with /th using
grep

th scope=row6-Grain   Flakes/td  .. to.. th scope=row6-
Grain   Flakes/th

i tried th scope=row*/td .. to.. th scope=row*/th to no
avail

there are over 100 rows ion this table


tr
th scope=row6-Grain   Flakes/td
td1 cup/td
td align=right3 3/8/td
  /tr
   tr
th scope=rowAlmond   flour, toasted/td
td1 cup/td
td align=right3 3/8/td
  /tr
   tr
th scope=rowAlmonds,   sliced/td
td1/2 cup/td
td align=right1 1/2/td
  /tr

--
You received this message because you are subscribed to the
BBEdit Talk discussion group on Google Groups.
To post to this group, send email to bbedit@googlegroups.com
To unsubscribe from this group, send email to
bbedit+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/bbedit?hl=en
If you have a feature request or would like to report a problem,
please email supp...@barebones.com rather than posting to the group.
Follow @bbedit on Twitter: http://www.twitter.com/bbedit


-- 
___

RICK GORDON
EMERALD VALLEY GRAPHICS AND CONSULTING
___

WWW:   http://www.shelterpub.com

-- 
You received this message because you are subscribed to the 
BBEdit Talk discussion group on Google Groups.
To post to this group, send email to bbedit@googlegroups.com
To unsubscribe from this group, send email to
bbedit+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/bbedit?hl=en
If you have a feature request or would like to report a problem, 
please email supp...@barebones.com rather than posting to the group.
Follow @bbedit on Twitter: http://www.twitter.com/bbedit

Re: grep help

[Christopher Stone]

On Mar 26, 2012, at 15:39, Rick Gordon wrote:
 FIND:
 (th scope=row.?*)/td
__

Hey Rick,

Didn't you switch up your non-greedy modifier?

Find:

(th scope=row.*?)/td

Replace:

\1/th

--
Best Regards,
Chris

-- 
You received this message because you are subscribed to the 
BBEdit Talk discussion group on Google Groups.
To post to this group, send email to bbedit@googlegroups.com
To unsubscribe from this group, send email to
bbedit+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/bbedit?hl=en
If you have a feature request or would like to report a problem, 
please email supp...@barebones.com rather than posting to the group.
Follow @bbedit on Twitter: http://www.twitter.com/bbedit

Re: grep help

[Ronald J Kimball]

On Mon, Mar 26, 2012 at 04:06:40PM -0500, Christopher Stone wrote:
 On Mar 26, 2012, at 15:39, Rick Gordon wrote:
  FIND:
  (th scope=row.?*)/td
 __
 
 Hey Rick,
 
 Didn't you switch up your non-greedy modifier?
 
 Find:
 
 (th scope=row.*?)/td
 
 Replace:
 
 \1/th

This regex will work on the sample text, which has the th and /td on
the same line, and no other cells on that line.  In general, however, it
may match too much; it matches from th scope=row to the next /td,
even with a /th in between.  (e.g. th scope=row/thtd/td)

To avoid that issue, you could use the below regex, which will not match a
th scope=row that is already closed with a /th, (and also can match
across multiple lines):

Find

(?s)(th scope=row(?(?!/th).)*)/td

Replace

\1/th


Ronald

-- 
You received this message because you are subscribed to the 
BBEdit Talk discussion group on Google Groups.
To post to this group, send email to bbedit@googlegroups.com
To unsubscribe from this group, send email to
bbedit+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/bbedit?hl=en
If you have a feature request or would like to report a problem, 
please email supp...@barebones.com rather than posting to the group.
Follow @bbedit on Twitter: http://www.twitter.com/bbedit

Re: grep help

[Rick Gordon]

I sure did switch up my non-greedy modifier. Thanks for noticing.

--

On 3/26/12 at 4:06 PM -0500, Christopher Stone wrote in a message entitled
Re: grep help:

On Mar 26, 2012, at 15:39, Rick Gordon wrote:
 FIND:
 (th scope=row.?*)/td
__

Hey Rick,

Didn't you switch up your non-greedy modifier?

Find:

(th scope=row.*?)/td

Replace:

\1/th

--
Best Regards,
Chris

--
You received this message because you are subscribed to the
BBEdit Talk discussion group on Google Groups.
To post to this group, send email to bbedit@googlegroups.com
To unsubscribe from this group, send email to
bbedit+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/bbedit?hl=en
If you have a feature request or would like to report a problem,
please email supp...@barebones.com rather than posting to the group.
Follow @bbedit on Twitter: http://www.twitter.com/bbedit


-- 
___

RICK GORDON
EMERALD VALLEY GRAPHICS AND CONSULTING
___

WWW:   http://www.shelterpub.com

-- 
You received this message because you are subscribed to the 
BBEdit Talk discussion group on Google Groups.
To post to this group, send email to bbedit@googlegroups.com
To unsubscribe from this group, send email to
bbedit+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/bbedit?hl=en
If you have a feature request or would like to report a problem, 
please email supp...@barebones.com rather than posting to the group.
Follow @bbedit on Twitter: http://www.twitter.com/bbedit

Re: Grep help with tide table formatting

[John Gold]

Question -- Now that you've laid it out, I understand what the
expression does, except for the \1 at the end of the search pattern.
What does that do?

Thanks again!

John


On Nov 10, 9:22 am, John Gold j...@pointseast.com wrote:
 Hey -- thank you very much. I'll give that a try!

 John

 On Nov 10, 1:33 am, Alex Satrapa gr...@goldweb.com.au wrote:







  On 10/11/2011, at 09:23 , John Gold wrote:

   1  4:09 AM 17.6    H
   1  10:30 AM        2.3     L
   1  4:34 PM 16.8    H
   1  10:52 PM        2.3     L
   2  5:02 AM 17.3    H
   2  11:24 AM        2.5     L
   2  5:30 PM 16.3    H
   2  11:45 PM        2.7     L
   3  5:56 AM 17.3    H
   3  12:20 PM        2.5     L
   3  6:26 PM 16.2    H

  My first attempt:

  Find:         ^(\d+)(.*)\r\1
  Replace with: \1\2\t\1

  This will require a couple of passes since it matches the lines by pairs.

  Hope this helps!
  Alex

   smime.p7s
  2KViewDownload

-- 
You received this message because you are subscribed to the 
BBEdit Talk discussion group on Google Groups.
To post to this group, send email to bbedit@googlegroups.com
To unsubscribe from this group, send email to
bbedit+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/bbedit?hl=en
If you have a feature request or would like to report a problem, 
please email supp...@barebones.com rather than posting to the group.
Follow @bbedit on Twitter: http://www.twitter.com/bbedit

Re: grep help

[Ronald J Kimball]

On Sun, Oct 23, 2011 at 01:50:08PM -0600, Doug McNutt wrote:
 These are so much fun...
 
 [ \t]*?\t[ \t]*
 
 any number of spaces or tabs, including none of them, followed, without being 
 greedy, by a required tab and some more spaces or tabs.
 
 whonoze?  All regular expressions are experimental and they often depend on 
 the software reading them.
 
 I worry about possibly making the second [ \t] not greedy. Ask Larry???

If you make the last thing in a regular expression non-greedy, then it
will always match nothing (in the case of *? or ??) or only once (in the
case of +?).

For example, if you have the text:

  ab

And you search for:

  a+b*?

Then it will match 'a'.

Ronald

-- 
You received this message because you are subscribed to the 
BBEdit Talk discussion group on Google Groups.
To post to this group, send email to bbedit@googlegroups.com
To unsubscribe from this group, send email to
bbedit+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/bbedit?hl=en
If you have a feature request or would like to report a problem, 
please email supp...@barebones.com rather than posting to the group.
Follow @bbedit on Twitter: http://www.twitter.com/bbedit

Re: grep help needed for spaces in mailto links

[oliver]

Finding all mailto:; URIs is pretty easy:

(?=href=)mailto:.+?(?=?)

You could then pass the results to something like Ruby's URL encode. But 
I'll let someone else more qualified help you with that.

-- 
You received this message because you are subscribed to the 
BBEdit Talk discussion group on Google Groups.
To post to this group, send email to bbedit@googlegroups.com
To unsubscribe from this group, send email to
bbedit+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/bbedit?hl=en
If you have a feature request or would like to report a problem, 
please email supp...@barebones.com rather than posting to the group.
Follow @bbedit on Twitter: http://www.twitter.com/bbedit

Re: grep help needed for spaces in mailto links

[RobS]

Ignore me. I recalled that that site had only ever used two different 
subjects in the mailto links. So I used plain old multi-file search and 
replace on them. Job done.

When brains fail, use brute force.

Rob

-- 
You received this message because you are subscribed to the 
BBEdit Talk discussion group on Google Groups.
To post to this group, send email to bbedit@googlegroups.com
To unsubscribe from this group, send email to
bbedit+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/bbedit?hl=en
If you have a feature request or would like to report a problem, 
please email supp...@barebones.com rather than posting to the group.
Follow @bbedit on Twitter: http://www.twitter.com/bbedit

Re: Grep Help.

[Chaz Larson]

I dealt with this a lot recently in another context.  Your file is not
corrupted.  Some fields just contain end-of-line characters.  For
example, the notes' field in Joan Fink's record contains:

Edward assistant[nl]
427-6119[nl]
562-0176

and the notes field in Aron Maure's record contains:

Jeff Masone[nl]
[nl]
Jack Hirsch, came from ICAA, since Oct 08[nl]

Where [nl] is a end-of-line [someone hit the return key while
entering the data in the notes field.  So, the data is exported just
as it should be, in that what you're seeing is what's stored in the
source.

I can think of a few ways to clean this up, but I'd like to know more
about the data set.  Does every line end with a http://foo.bar.baz;?

chazl

Chaz Larson - c...@jeck.com



On Thu, Sep 9, 2010 at 9:21 AM, m i l e s magicmi...@gmail.com wrote:
 Hi.

 I have data from a OUTLOOK export that's been corrupted.  It appears that 
 Outlook is putting extraneous data from the NOTES field into the TITLE field 
 of the export, which ends up column shifting the resulting records that 
 follow the first record.

 Look at the sample data below: its column shifted the following:

        Low             Normal          Web Page

 Down to the next line, and anything in the notes field gets stuffed into the 
 Title field, where there should be nothing at all.

 How would I fix this with Grep ?

 ==
              Columns
 ==

 Title   First Name      Middle Name     Last Name       Suffix  Company 
 Department      Job Title       Business Street Business Street 2     
 Business Street 3     Business City   Business State  Business Postal Code  
   Business Country/Region Home Street     Home Street 2 Home Street 3 
 Home City       Home State      Home Postal Code        Home Country/Region   
   Other Street    Other Street 2        Other Street 3        Other City  
     Other State     Other Postal Code       Other Country/Region    
 Assistant's Phone       Business Fax    Business Phone  Business Phone 2    
   Callback        Car Phone       Company Main Phone      Home Fax        
 Home Phone      Home Phone 2  ISDN    Mobile Phone    Other Fax       Other 
 Phone     Pager   Primary Phone   Radio Phone     TTY/TDD Phone   Telex   
 Account Anniversary     Assistant's Name        Billing Information     
 Birthday        Business Address PO Box Categories      Children        
 Directory Server        E-mail Address  E-mail Type     E-mail Display Name   
   E-mail 2 Address        E-mail 2 Type   E-mail 2 Display Name   E-mail 3 
 Address        E-mail 3 Type   E-mail 3 Display Name   Gender  Government ID 
 Number    Hobby   Home Address PO Box     Initials        Internet Free Busy  
     Keywords        Language        Location        Manager's Name  Mileage 
 Notes   Office Location Organizational ID Number        Other Address PO Box  
   Priority        Private Profession      Referred By     Sensitivity     
 Spouse  User 1        User 2        User 3        User 4        Web 
 Page

 ===
               Sample Data
 ===

        Joan            Fink            The Dance Center                135 
 Lexington Avenue                    New York        NY      10128             
                                                                               
                                                 212)415  - Amy K. - 
 JF                                                                            
                                                               0/0/00          
         0/0/00                                  jf...@x.org     SMTP  
                                                           Unspecified         
                                                                             
 Edward assistant
 427-6119
 562-0176                               Low                             
 Normal                                          http://www.x.org

        Maure           Aron            World Music/Crash Arts          
 Executive Director      720 Lindist Avenue                      Los Angeles   
   CA      90007                                                               
                                                                     
 617/679.    617)876-                                                  
                                                                               
             0/0/00                  0/0/00                                  
 ma...@x.org     SMTP                                                  
           Unspecified                                                         
                             Jeff Masone

 Jack Hirsch, came from ICAA, since Oct 08
                                Low                             Normal        
                                   http://www.xxx.org

 --
 You received this message because you 

Re: Grep Help.

[Bruce Van Allen]

On 2010-09-09, m i l e s wrote:


Hi.

I have data from a OUTLOOK export that's been corrupted.  It 
appears that Outlook is putting extraneous data from the NOTES 
field into the TITLE field of the export, which ends up column 
shifting the resulting records that follow the first record.


Look at the sample data below: its column shifted the following:
  Low Normal  Web Page

Down to the next line, and anything in the notes field gets stuffed
into the Title field, where there should be nothing at all.

How would I fix this with Grep ?


It's difficult to see the problem because email has broken your 
lines up.


A few things to try:

1. First, If you can go back to Outlook and re-do the export, 
pay attention to any options for line breaks, encoding, etc. 
Also, when there, see if this record has anything odd in it, 
such as extraneous quote marks, paragraph returns, etc.


2. Open the exported file in BBEdit with various encodings (see 
File menu Re-Open with Encoding. Might reveal something.


3. Viewing the file in BBEdit, choose Show Invisibles, and look 
for strange characters (sometimes shown as red upside-down 
question marks), etc). If they seem to be located near the 
problems, you might get somewhere by searching for them and 
deleting or replacing with something that doesn't force a new line.


HTH -- Just guessing



   - Bruce

_bruce__van_allen__santa_cruz_ca_

--
You received this message because you are subscribed to the 
BBEdit Talk discussion group on Google Groups.

To post to this group, send email to bbedit@googlegroups.com
To unsubscribe from this group, send email to
bbedit+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/bbedit?hl=en
If you have a feature request or would like to report a problem, 
please email supp...@barebones.com rather than posting to the group.

Follow @bbedit on Twitter: http://www.twitter.com/bbedit

Re: Grep Help.

[Doug McNutt]

At 11:09 -0700 9/9/10, Bruce Van Allen wrote:
On 2010-09-09, m i l e s wrote:

I have data from a OUTLOOK export that's been corrupted.  It appears that 
Outlook is putting extraneous data from the NOTES field into the TITLE field 
of the export, which ends up column shifting the resulting records that 
follow the first record.

Look at the sample data below: its column shifted the following:
  Low Normal  Web Page

Down to the next line, and anything in the notes field gets stuffed
into the Title field, where there should be nothing at all.

How would I fix this with Grep ?

It's difficult to see the problem because email has broken your lines up.

A few things to try, snipped by DPM


Another thing to try:

Select the lines you posted, or a more original source, and paste them into a 
spreadsheet. Excel, for instance, recognizes the tabs and will place items in 
columns across the page. BBEdit  offers no way to do that.

When I did that I found missing tabs with 135 Lexington Avenue coming under 
Job  Title instead of Business Street.

It's as if someone was adjusting the tabs so that the format would look right 
in his text-oriented display. Converting tabs to spaces could do that and 
create a terrible mess.

Using Excel's insert cells command it's possible to line some things up with 
what BBEdit would think are inserted tabs but you'd be guessing based on 
content and that's hard to automate. With a lot more items you might see usable 
patterns with the real column structure offered by a spreadsheet.

The Jack Hirsch item seems totally unrelated to the headings. It appears on a 
row by itself. The other items have nothing in the Title, column 1.

With all of those columns, mostly blank, you have a pretty good example of what 
xml files are for.

-- 
-- Give me liberty or give me Obamacare --

-- 
You received this message because you are subscribed to the 
BBEdit Talk discussion group on Google Groups.
To post to this group, send email to bbedit@googlegroups.com
To unsubscribe from this group, send email to
bbedit+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/bbedit?hl=en
If you have a feature request or would like to report a problem, 
please email supp...@barebones.com rather than posting to the group.
Follow @bbedit on Twitter: http://www.twitter.com/bbedit

Re: Grep Help

[Kendall Conrad]

This seems to work:

td([\s\S]*?a\s[\s\S]*?)/td

-Kendall

On Jan 17, 2:42 pm, Warren Michelsen wmichel...@gmail.com wrote:
 I need to search for a td/td tag set and everything in between, which may 
 include line breaks but which must include an anchor.

             td
                                     a   href=http://URL.WILL.BE.HERE;Link 
 Text here
                             /td

 I need to find and replace this entire table column. (Replacing with  so as 
 to delete.)

 What's the Grep pattern to find this?
-- 
You received this message because you are subscribed to the 
BBEdit Talk discussion group on Google Groups.
To post to this group, send email to bbedit@googlegroups.com
To unsubscribe from this group, send email to
bbedit+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/bbedit?hl=en
If you have a feature request or would like to report a problem, 
please email supp...@barebones.com rather than posting to the group.

Re: Grep Help

[Garth Fletcher]

Warren Michelsen wrote:

I need to search for a td/td tag set and everything in between, which may 
include line breaks but which must include an anchor.



I use:

td(?s)(.+?)/td

 where:
  (?s) = search across end of lines
   .+? = non-greedy match to anything
--
Garth Fletcher

-- 
You received this message because you are subscribed to the 
BBEdit Talk discussion group on Google Groups.
To post to this group, send email to bbedit@googlegroups.com
To unsubscribe from this group, send email to
bbedit+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/bbedit?hl=en
If you have a feature request or would like to report a problem, 
please email supp...@barebones.com rather than posting to the group.

Re: grep help, delete everything other than what I'm matching

[Doug McNutt]

At 09:30 -0700 10/28/09, BB Design wrote:
I'm using BB Edit grep to select a/a links like this:

(\a.*\\/a)

So I can paste the match using: \1

However, I basically want to delete everything else in the document
except these links, so that all I am left with is the links. Possible
to modify my code to accomplish this? Thanks!

First: you better make sure that regular expression isn't greedy. It's likely 
to select everything from the first a to the last /a in the line or possibly 
to the end of the file.

(\a.*\?\/a)

and next you'll need to allow for links that pass through lineend characters 
unless you know a lot about the structure of the html file.

In my favorite language it would be an s after the trailing quote of the 
overall expression, /a.*?\/a/is. In BBEdit it's (\s) or something like that 
at the end of the expression.

-- 
-- So do we celebrate the start of a new decade at the end of this year? Or do 
the tens start at in January 2011? Was the first year,  ACE, assigned Roman 
numeral I ?--

--~--~-~--~~~---~--~~
You received this message because you are subscribed to the 
BBEdit Talk discussion group on Google Groups.
To post to this group, send email to bbedit@googlegroups.com
To unsubscribe from this group, send email to
bbedit+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/bbedit?hl=en
If you have a feature request or would like to report a problem, 
please email supp...@barebones.com rather than posting to the group.
-~--~~~~--~~--~--~---

Re: grep help, delete everything other than what I'm matching

[Miraz Jordan]

On Thu, Oct 29, 2009 at 05:30, BB Design bradbans...@gmail.com wrote:
 I'm using BB Edit grep to select a/a links like this:

 (\a.*\\/a)

 So I can paste the match using: \1

 However, I basically want to delete everything else in the document
 except these links, so that all I am left with is the links. Possible
 to modify my code to accomplish this? Thanks!


I'd use an Applescript to do this:

remove all Return characters -- gets everything on one line
replace a with \ra -- puts a Return before a link
replace /a with /a\r -- puts a Return after a link
Process lines containing a and put them in a new document

Done.

Applescript experts would undoubtedly improve on this, but I just
tried it on the source of a random webpage and it appeared to do the
trick in a second or so:

-- This script pulls out all links
-- from an HTML source document

tell application BBEdit
activate
tell text 1 of text window 1

-- remove Returns
replace \\r using  options {search mode:grep, starting at
top:true, wrap around:false, backwards:false, case sensitive:false,
match words:false, extend selection:false}

-- isolate links
replace a using \\ra options {search mode:grep, starting 
at
top:true, wrap around:false, backwards:false, case sensitive:false,
match words:false, extend selection:false}
replace /a using /a\\r options {search mode:grep, 
starting at
top:true, wrap around:false, backwards:false, case sensitive:false,
match words:false, extend selection:false}

-- put out lines with links
process lines containing matching string a output options
{copying to new document:true}


end tell

end tell

-- end script


Cheers,

Miraz

-- 
Miraz Jordan

WordPress ebooks for non-techies: http://knowit.co.nz/bookstore
Dogs. Fun. Outdoors. : http://runspotrun.info
iPod, iPhone, Mac Tips: http://mactips.info

--~--~-~--~~~---~--~~
You received this message because you are subscribed to the 
BBEdit Talk discussion group on Google Groups.
To post to this group, send email to bbedit@googlegroups.com
To unsubscribe from this group, send email to
bbedit+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/bbedit?hl=en
If you have a feature request or would like to report a problem, 
please email supp...@barebones.com rather than posting to the group.
-~--~~~~--~~--~--~---

Re: grep help

[Ze'ev]

Here's some sample lines:

NOTE:r 307072427\na 0014017578\n\nr 307072427\na 0014017578\nr
307072427\na 0014017\n

NOTE:17 -2nd place (clinton-henry) 0D\nF\: carroll st fr\n\n17 -2nd
place (clinton-henry)

NOTE:Mailing Address\:\nBroadVoice\, Inc.\nPO Box 10\nBi\n\nMailing
Address\:\nBroadVoi\n\nMailing Address\:\nBroadVoice\, Inc.\nPO Box
10\nBi\n\nMailing Address\:\nBroadVoice\, Inc.\nPO Box 10\nBi\n

(Each vcard's 'note' field is on its own line starting with 'NOTE:',
and the \n's get converted to line feeds in Address Book.)

The repeats seem to always have at least one \n between them.

My latest effort is to search for:
(NOTE:.*?)(.+?)((?:\\n)+)\2

and replace with:
\1\2\3

... and this actually works, but it takes MULTIPLE passes (and leaves
me with extra \n's which are easy enough to get rid of afterwards)

Anyway to improve this?

--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google
Groups BBEdit Talk group.
To post to this group, send email to bbedit@googlegroups.com
To unsubscribe from this group, send email to
bbedit+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/bbedit?hl=en
If you have a specific feature request or would like to report a suspected (or 
confirmed) problem with the software, please email to supp...@barebones.com 
rather than posting to the group.
-~--~~~~--~~--~--~---

Re: grep help

[Patrick Woolsey]

Ze'ev zgi...@gmail.com sez:

I'm trying to clean up a bunch of vcards.

After various synchs, I have repeated information in my notes field,
e.g.:

NOTE:blabla\nJim's guy\n\numesh\nJim's guy\n\numesh\nunique\nJim's guy
\n\numesh\nJim's guy\n\numesh\n\nJim's guy\n\numesh\nJim's guy\n\numesh
\nJim's guy\n\numesh\nJim's guy\n\numesh

I want to end up with

NOTE:blabla\nJim's guy\n\numesh\nunique\n

I'm trying to write a grep expression that will eliminate all the
repeated text.


Sorry, no way to tell without more info about the structure of the note
contents, or some actual data.


Regards,

 Patrick Woolsey
==
Bare Bones Software, Inc.http://www.barebones.com
P.O. Box 1048, Bedford, MA 01730-1048

--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google
Groups BBEdit Talk group.
To post to this group, send email to bbedit@googlegroups.com
To unsubscribe from this group, send email to
bbedit+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/bbedit?hl=en
If you have a specific feature request or would like to report a suspected (or 
confirmed) problem with the software, please email to supp...@barebones.com 
rather than posting to the group.
-~--~~~~--~~--~--~---

Re: grep help

[Ronald J Kimball]

On Wed, May 13, 2009 at 09:12:39AM -0700, Ze'ev wrote:
 
 Any grep wizards out there?
 
 I'm trying to clean up a bunch of vcards.
 
 After various synchs, I have repeated information in my notes field,
 e.g.:
 
 NOTE:blabla\nJim's guy\n\numesh\nJim's guy\n\numesh\nunique\nJim's guy
 \n\numesh\nJim's guy\n\numesh\n\nJim's guy\n\numesh\nJim's guy\n\numesh
 \nJim's guy\n\numesh\nJim's guy\n\numesh
 
 I want to end up with
 
 NOTE:blabla\nJim's guy\n\numesh\nunique\n
 
 
 I'm trying to write a grep expression that will eliminate all the
 repeated text.
 
 I've tried replacing
 
 NOTE:(.*?)(.*?)(.*)\2

In your regex:

(.*?)(.*?)(.*)\2

the first two parenthesized groups will always match zero characters.  .*?
means match any number of characters, but as few as possible.

Suppose you're matching against this string:

Hello, world!

The first (.*?) will match zero characters at the start of the string.  The
second (.*?) will match at the same position.  The (.*) will match the
whole string.  The \2 will match the same thing that the second (.*?)
matched, which was zero characters.

I hope that helps somewhat.  As Patrick said, it would be helpful to have
more detailed information about the source data.

Ronald

--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google
Groups BBEdit Talk group.
To post to this group, send email to bbedit@googlegroups.com
To unsubscribe from this group, send email to
bbedit+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/bbedit?hl=en
If you have a specific feature request or would like to report a suspected (or 
confirmed) problem with the software, please email to supp...@barebones.com 
rather than posting to the group.
-~--~~~~--~~--~--~---

Re: Grep help?

[Robert A. Rosenberg]

At 21:22 + on 03/25/2009, Patrick James wrote about Re: Grep help?:

Hi

Assuming each list element is on a new line as per your example I 
think that:

ol.+\r(li.+\r){10,}/ol

should select what is required.

I am not up on my GREP but I have an impression that this might catch 
cases where there are more than one list and at least 10 LIs in total.
-- 


Robert A. Rosenberg

--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google
Groups BBEdit Talk group.
To post to this group, send email to bbedit@googlegroups.com
To unsubscribe from this group, send email to
bbedit+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/bbedit?hl=en
If you have a specific feature request or would like to report a suspected (or 
confirmed) problem with the software, please email to supp...@barebones.com 
rather than posting to the group.
-~--~~~~--~~--~--~---

Re: Grep help?

[le...@gmail]

On Mar 25, 2009, at 15:22, Patrick James pjl...@googlemail.com wrote:

 Assuming each list element is on a new line as per your example I
 think that:

 ol.+\r(li.+\r){10,}/ol

 should select what is required.

 There's no need for negative lookahead.

There is with multiple lists in the same file, which is where I run  
into trouble.






--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google
Groups BBEdit Talk group.
To post to this group, send email to bbedit@googlegroups.com
To unsubscribe from this group, send email to
bbedit+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/bbedit?hl=en
If you have a specific feature request or would like to report a suspected (or 
confirmed) problem with the software, please email to supp...@barebones.com 
rather than posting to the group.
-~--~~~~--~~--~--~---

Re: Grep help?

[G. T. Stresen-Reuter]

On Mar 26, 2009, at 7:53 AM, le...@gmail wrote:


 On Mar 25, 2009, at 15:22, Patrick James pjl...@googlemail.com  
 wrote:

 Assuming each list element is on a new line as per your example I
 think that:

 ol.+\r(li.+\r){10,}/ol

 should select what is required.

 There's no need for negative lookahead.

 There is with multiple lists in the same file, which is where I run
 into trouble.

Small modification (haven't been following the thread so I may have  
missed something)...

ol.+\r(li.+\r){1,10}/ol

Should now select at least one LI and at most 10 LI. Is that what you  
want?

Ted Stresen-Reuter


--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google
Groups BBEdit Talk group.
To post to this group, send email to bbedit@googlegroups.com
To unsubscribe from this group, send email to
bbedit+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/bbedit?hl=en
If you have a specific feature request or would like to report a suspected (or 
confirmed) problem with the software, please email to supp...@barebones.com 
rather than posting to the group.
-~--~~~~--~~--~--~---

Re: Grep help?

[Seth Dillingham]

On 3/25/2009, le...@gmail said:

I know I can do this with a negative look-ahead something or 
other,  but despite years and years of regexs, I do not grok 
that particular  mechanism.

I want to search for lists that contain at least 10 list items.

Try this:

(?s:([uo]l)[^]*\s*(?li[^]*.*?/li\s*){10,}/\1)

Seth


--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google
Groups BBEdit Talk group.
To post to this group, send email to bbedit@googlegroups.com
To unsubscribe from this group, send email to
bbedit+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/bbedit?hl=en
If you have a specific feature request or would like to report a suspected (or 
confirmed) problem with the software, please email to supp...@barebones.com 
rather than posting to the group.
-~--~~~~--~~--~--~---

Re: Grep help?

[Jonathan Lundell]

On Mar 26, 2009, at 11:39 AM, le...@gmail wrote:

 On 26-Mar-2009, at 10:42, Ronald J Kimball wrote:
 (?s:([uo]l)[^]*\s*(?li[^]*.*?(?:/li\s*|(?=li))){10,}/\1)


 In my test data that only matches against the third list.

 ---test file
 olli1/lili2/lili3li4li5/lili6/
 lili7li8li9li10li11/lili12li13/li/
 ololli1li2li3/lili4li5/lili6li7li8/lili9/
 li/ololli1li2li3li4li5li6li7li8li9/
 lili10li11li12/li/ol
 ---test file

It matches the first and third for me.



--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google
Groups BBEdit Talk group.
To post to this group, send email to bbedit@googlegroups.com
To unsubscribe from this group, send email to
bbedit+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/bbedit?hl=en
If you have a specific feature request or would like to report a suspected (or 
confirmed) problem with the software, please email to supp...@barebones.com 
rather than posting to the group.
-~--~~~~--~~--~--~---

Re: Grep help?

[le...@gmail]

On 26-Mar-2009, at 12:52, Ronald J Kimball wrote:


 On Thu, Mar 26, 2009 at 12:39:44PM -0600, le...@gmail wrote:

 On 26-Mar-2009, at 10:42, Ronald J Kimball wrote:
 (?s:([uo]l)[^]*\s*(?li[^]*.*?(?:/li\s*|(?=li))){10,}/\1)

 In my test data that only matches against the third list.

 ---test file
 olli1/lili2/lili3li4li5/lili6/
 lili7li8li9li10li11/lili12li13/li/
 ololli1li2li3/lili4li5/lili6li7li8/lili9/
 li/ololli1li2li3li4li5li6li7li8li9/
 lili10li11li12/li/ol
 ---test file


 It works fine for me in Perl.  There's no substantive difference  
 between
 your first list and your third list.  Are you sure you're searching  
 the
 whole file?

Yes.  Results of Find all

http://home.kreme.com/grepresult.png

If I split it all up into mcultiple lines, then the match works.  All  
one line (like if the source had been saved in 'compact' mode) and it  
fails.


-- 
Amazingly Beautiful Creatures Dancing Excites the Forest
Glade, in my Heart how I do Jump like the Kudo Listen to the
Music so Nice the Organ Plays. Quietly Rests the Sleepy
Tiger Under the Vine tree at the Water's side and X marks
the spot 'neath the Yellow moon where the Zulu king and
I did hide.


--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google
Groups BBEdit Talk group.
To post to this group, send email to bbedit@googlegroups.com
To unsubscribe from this group, send email to
bbedit+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/bbedit?hl=en
If you have a specific feature request or would like to report a suspected (or 
confirmed) problem with the software, please email to supp...@barebones.com 
rather than posting to the group.
-~--~~~~--~~--~--~---

Re: Grep help?

[le...@gmail]

On 26-Mar-2009, at 15:04, Jonathan Lundell wrote:
 On Mar 26, 2009, at 1:48 PM, le...@gmail wrote:
 Yes.  Results of Find all

 http://home.kreme.com/grepresult.png

 If I split it all up into mcultiple lines, then the match works.  All
 one line (like if the source had been saved in 'compact' mode) and it
 fails.

 Looks like your reformatter messed it up. I don't think you can have
 white space after the / in /li, for example. Does your file  
 validate?

This data is certainly not going to validate.  But there is no  
whitespace at all on that line.  you are seeing BBEdits softwrap  
(check the line numbers on the left)

-- 
No one ever thinks of themselves as one of Them. We're always one
of Us. It's Them that do the bad things.


--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google
Groups BBEdit Talk group.
To post to this group, send email to bbedit@googlegroups.com
To unsubscribe from this group, send email to
bbedit+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/bbedit?hl=en
If you have a specific feature request or would like to report a suspected (or 
confirmed) problem with the software, please email to supp...@barebones.com 
rather than posting to the group.
-~--~~~~--~~--~--~---

Re: Grep help?

[Patrick James]

Hi

Assuming each list element is on a new line as per your example I  
think that:

ol.+\r(li.+\r){10,}/ol

should select what is required.

There's no need for negative lookahead.

Above can be modified to include lists of more than one type, such a s  
ol or ul for example and if there are empty lines between list  
elements.

I hope this is of some assistance :)


Patrick

http://www.patrickjames.co.uk

On 25 Mar 2009, at 20:44, le...@gmail wrote:


 I know I can do this with a negative look-ahead something or other,
 but despite years and years of regexs, I do not grok that particular
 mechanism.

 I want to search for lists that contain at least 10 list items.

 ol id=foo
 li class=bar...
 li...
 li class=boo...
 li...
 li...
 li...
 li...
 li...
 li...
 li...
 li...
 /ol

 I got started on something, but it blew up when there where multiple
 lists.

 li(?!(/li)+){10,}... things fall apart quickly for me.

--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google
Groups BBEdit Talk group.
To post to this group, send email to bbedit@googlegroups.com
To unsubscribe from this group, send email to
bbedit+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/bbedit?hl=en
If you have a specific feature request or would like to report a suspected (or 
confirmed) problem with the software, please email to supp...@barebones.com 
rather than posting to the group.
-~--~~~~--~~--~--~---