Re: Need Grep Pattern

2024-02-15 Thread 'eu...@gmx.de' via BBEdit Talk
Hi Kim,

Maybe this search pattern will help:

([\d\/]{8})( )([^\,]+)(\, TX )([\d\.]{1,5})

with replace pattern:

\1\t\3\t\5

By the way: Try the pattern first wich the Pattern Playground (the 6th entry in 
BBEdits search menu). There’s also an extensive help on grep included.

Cheers, Ulrich


> Am 14.02.2024 um 23:44 schrieb Kim Mosley :
> 
> I want to add tabs (or something else that might be better) so that I can 
> have three columns… date, vendor with city, and price.
> 
> Can someone help?
> 
> Thanks!
> 
> 01/03/23 CENTRAL MARKET 61 AUSTIN, TX 45.00
> 01/04/23 H-E-B 425 AUSTIN, TX 74.62
> 01/09/23 CENTRAL MARKET 61 AUSTIN, TX 43.70
> 01/10/23 WHOLEFDS LMR 10145 AUSTIN, TX 62.25
> 01/13/23 SQ *ASAHI IMPORTS Austin, TX 24.46
> 01/14/23 CENTRAL MARKET 61 AUSTIN, TX 29.22
> 01/17/23 CENTRAL MARKET 61 AUSTIN, TX 28.25
> 01/18/23 CENTRAL MARKET 61 AUSTIN, TX 19.34
> 01/21/23 CENTRAL MARKET 61 AUSTIN, TX 1.83
> 01/21/23 CENTRAL MARKET 61 AUSTIN, TX 18.34
> 01/23/23 CENTRAL MARKET 61 AUSTIN, TX 19.85
> 
> -- 
> 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/235af5bb-10d7-4dad-9df0-fe2db21e94bdn%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/E5102CE7-07BA-4051-A600-AFA2F59FB2C9%40gmx.de.


Re: Need a little GREP help

2022-10-04 Thread eu...@gmx.de
Search Pattern:  ^.*$

Replace Pattern: \0

Will do the job!



> Am 04.10.2022 um 06:18 schrieb Michael Heth :
> 
> Say Folks,
> 
> Have been trying to get my head around GREP for many years and never quite 
> get it.
> 
> I've asked for help before and folks were able to give me the cryptic code to 
> get my little task in the done column.
> 
> So, I have a list with over 450 lines like these
> 
> 1995 DUCATI M600 Monster
> 1995 DUCATI M900 Monster
> 1995 DUCATI Superbike 748 Biposto / SP
> 1995 DUCATI Superbike 916 Biposto / Senna
> 
> and I need them to end up like this
> 
> 1995 DUCATI M600 Monster
> 1995 DUCATI M900 Monster
> 1995 DUCATI Superbike 
> 748 Biposto / SP
> 1995 DUCATI 
> Superbike 916 Biposto / Senna
> 
> Any tips.help is much appreciated.
> 
> Thanks,
> 
> 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 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/2d19291b-ac2f-41f4-9517-ee5cad8d2505n%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/1D04EF61-BE8A-4356-A509-479BC8F8591C%40gmx.de.


Re: Any Regex Gurus -

2022-07-12 Thread eu...@gmx.de
Try this:
Search pattern:  "\b(.*)(")(.*)\b“
Replace pattern:  "\1\3“

This changes  "good for me",yo“ to  "good for me,yo“

And then:
Search pattern:  (\w),(\w)
Replace pattern:  „\1, \2“

To change "good for me,yo“ to "good for me, yo“

Hope I understood your need.

Ulrich

> Am 11.07.2022 um 21:28 schrieb David G Wagner  >:
> 
> good[^"]*"[^"]* Will give you:
> 
> good for me",yo"
> On Jul 11, 2022, 10:13 -0700, Prashant Maheshwari  >, wrote:
>> I can extract all text between good and quotes by search good.*"
>> 
>> 
>> How to modify to extract between two quotes starting from good
>> good for me",yo
>> 
>> 
>> 
>> 
>> 
>> hello how are we doing my brother "good for me",yo","what you say?"
>> 
>> 
>> 
>> 
>> --
>> 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/51853ddb-e1ad-4959-8b3a-0406dd7934cen%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/5aa37792-41cf-413f-a35d-ba5cfc9d7981%40Spark
>  
> .

-- 
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/8C47809B-C6E8-4ABD-AADA-F70960FBFE63%40gmx.de.


Re: TextEdit acts like default text editor at times

2021-11-29 Thread eu...@gmx.de
Hi Brian

Did you try to „First Aid“ from the Disk Utility App on your startup volume?
This helped for me some years ago.

You may also try to assign .text and .txt files to another application like 
Atom  (Don’t forget to use „Change All…“!) and then set it 
back to BBEdit again.

Otherwise you may want to delete the TextEdit App, because it’s mostly useless 
anyway…
I could tell you how to do this. But without any warranty!

Cheers!
Ulrich



> Am 29.11.2021 um 16:22 schrieb Brian Gollands :
> 
> rMBP 2012 / OS10.15 / BBEdit 14
> 
> Anybody else have a problem with TextEdit being invoked when double-clicking 
> on a .txt file that is set to be opened with BBEdit? This has been an 
> annoyance over several versions of the OS.
> 
> All .txt files are set to BB and their file icons reflect this. But 
> double-clicking them or choosing Open opens them in TextEdit. Choosing my 
> contextual command Open in BBEdit works OK. The latest straw was in using 
> Hook's command to Make a New Note in BBEdit. It, too, makes the file in 
> TextEdit.
> 
> Have tried making a zip of TE and deleting the original (so I didn't lose it 
> completely), but can't seem to do this even in Terminal due to some magical 
> protection conveyed by its living in /System/Applications/ I guess.
> 
> I have a lot of apps installed, but don't recall any other setting I've 
> changed that would cause this. Is there a default text editor config I'm 
> missing?
> 
> Thanks for any help,
> Brian
> 
> 
> 
> -- 
> 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/6efc1994-b969-46b8-94b2-dffe73aa4909n%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/B2D8362B-8C5A-4287-AF92-6370E35EE029%40gmx.de.


Re: Newbie problem - Tech support sent me here

2021-06-27 Thread eu...@gmx.de
Hi Neill,

Did you check whether the script file /VCTTools/bat/hdbgsub.sh does exist?

Ulrich

> Am 27.06.2021 um 01:10 schrieb Neill Smith :
> 
> I recently upgraded  my macOS from High Sierra to Big Sur. A script file that 
> has run for years under BBEdit (and TextWrangler before) has quit working. 
> The script is invoked from within a file [fname].GEO by picking the script 
> from my scripts list in the BBEdit top bar. The script runs a program that 
> reads the [fname].GEO file.
> 
> Now the script doesn't run. I get the message
> 
> A scripting error has occurred:
> 
> sh: /VCTTools/bat/hdbgsub.sh: No such file or directory
> 
> This directory does exist. I uninstalled BBEdit and did a clean reinstall. I 
> had to contact BBEdit tech support in order to install the Command Line Tools 
> because old versions of the tools had to be removed manually.
> 
> I didn't write the original script. It was created by a colleague years ago. 
> BBEdit tech support recommended that I contact this group.
> 
> Thanks,
> 
> Neill Smith
> 
> -- 
> 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/a8fc6e58-41f0-4ea1-9180-efea41378b86n%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/9F4A8A25-D79A-4A47-B170-25C13667F529%40gmx.de.


Re: GREP pattern for financial summary output

2021-05-21 Thread eu...@gmx.de
Only few people use the grep search+replace functions in BBEdit that often to 
use it blindly.

And the PCRE syntax isn’t very intuitive.
I developed a CMS software in the early 2k years (20 years ago ;-) using PHP 
and implemented extended input text filtering by using the PCRE compatible 
functions in PHP.
I really struggled with it, I can tell you!

Since BBEdit 13,0 I think, there is a nice support option to edit and try regex 
patterns in BBEdit, called "Pattern Playground“, there you get all the help you 
need for all the rarely used features of the grep-search. You can find it in 
the menu „Search“ on the 6th position from top.

Ulrich

> Am 21.05.2021 um 03:34 schrieb Russell B :
> 
> That's perfect Ulrich. Here's me thinking I could do it with a simple string. 
> I always forget the curly bracket option as I don't think it was an option in 
> BBE way back when I first started, so not front of mind. I only dabble in 
> this stuff every now and then. Here is what I did - created an extra column 
> to push all the other columns back then inserted the debits into that column. 
> BTW - if I wanted to create a string that said "find all strings that are not 
> negative values, loosely (!-)", what does BBE use for 'not' or inversion I 
> think its called? Just for future reference.
> 
> Update top of file
> 
> from
> DateAmountDescription
> 
> to
> DateCreditDebtDescription
> 
> First pass - add column to right credits
> \t([0-9]{1,20}\.{0,1}[0-9]{0,2})\t
> \t\1\t\t
> 
> Second pass - push debits into new column
> \t-([0-9]{1,20}\.{0,1}[0-9]{0,2})\t
> \t\t\1\t
> 
> On Friday, May 21, 2021 at 1:44:04 AM UTC+10 Ulrich Kapp wrote:
> Hi Russell,
> 
> I’m not sure what you exactly want to do, but if you just want to put the 
> negative lines into a second column in the CSV (comma separated values) file 
> and you have just one column in the origin file, you can use the following 
> pattern:
> 
> Search pattern:   "^(\-{1})([0-9]{1,20}\.{0,1}[0-9]{0,2})“
> Replacement pattern: ",\1\2“
> (without quotation marks)
> (If you want to have tabs instead of commas to separate the columns use "\t“ 
> instead of “,“)
> 
> All the negative values will be placed now in a second column, but always in 
> a separate line.
> 
> The output will look like this:
> 
> ,-2559.82
> 1168.41
> ,-12
> ,-7.21
> 23
> 
> 
> Hope it helps.
> 
> Ulrich
> 
> 
> 
> 
>> Am 20.05.2021 um 11:47 schrieb Russell B > >:
>> 
> 
>> 
>> My bank accounts have a save to CSV option in a single Amount column, such 
>> as the following:
>> 
>> -2559.82
>> 1168.41
>> -12
>> -7.21
>> 23
>> 
>> I want to divide this into separate Credit & Debit columns, tab separated, 
>> such as
>> 
>> Credit | Debit
>> 
>> 1168.41 | 2559.82
>> 
>> I can't create a robust GREP pattern to handle the existence or not of the 
>> decimal values. Can someone provide a suitable pattern? 
>> Thanks
>> 
> 
>> -- 
>> 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: > >
>> --- 
>> 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/783875e5-c1a0-438c-8071-678d598b71a1n%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/4c9d20ec-f4f4-4857-9865-9e2a9baba42dn%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 

Re: GREP pattern for financial summary output

2021-05-20 Thread eu...@gmx.de
Hi Russell,

I’m not sure what you exactly want to do, but if you just want to put the 
negative lines into a second column in the CSV (comma separated values) file 
and you have just one column in the origin file, you can use the following 
pattern:

Search pattern:   "^(\-{1})([0-9]{1,20}\.{0,1}[0-9]{0,2})“
Replacement pattern: ",\1\2“
(without quotation marks)
(If you want to have tabs instead of commas to separate the columns use "\t“ 
instead of “,“)

All the negative values will be placed now in a second column, but always in a 
separate line.

The output will look like this:

,-2559.82
1168.41
,-12
,-7.21
23


Hope it helps.

Ulrich



> Am 20.05.2021 um 11:47 schrieb Russell B :
> 
> 
> My bank accounts have a save to CSV option in a single Amount column, such as 
> the following:
> 
> -2559.82
> 1168.41
> -12
> -7.21
> 23
> 
> I want to divide this into separate Credit & Debit columns, tab separated, 
> such as
> 
> Credit | Debit
> 
> 1168.41 | 2559.82
> 
> I can't create a robust GREP pattern to handle the existence or not of the 
> decimal values. Can someone provide a suitable pattern? 
> Thanks
> 
> -- 
> 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/783875e5-c1a0-438c-8071-678d598b71a1n%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/83E4CF01-DF2D-4986-AC8C-179817EC820E%40gmx.de.


Re: Can't open many files using "Open..." dialog

2021-02-16 Thread eu...@gmx.de
Hi Rich,

I can’t reproduce the issue Ken L reported.
In my environment (MacBook Pro Mid 2010, Patched macOS Mojave, BBEdit 13.5.5) 
everything works fine, even when I assign the .pl files are to another editor 
than BBEdit in the Finder.

Maybe there’s something weird in his special environment?

Ulrich

> Am 16.02.2021 um 17:03 schrieb Rich Siegel :
> 
> On 16 Feb 2021, at 10:55, Ken L wrote:
> 
>> Summary of issue is that when I try to use the "Open..." dialog, most of my
>> text source files (I'm a Perl programmer usually) show up in the window as
>> greyed out.
> 
> They may show that way; but you can still click on them or double-click to 
> open. The Open panel in macOS is weird and sometimes slow to catch up. 
> There's nothing particularly wrong; that's just how it is.
> 
> R.
> 
> -- 
> Rich Siegel Bare Bones Software, Inc.
>   
> 
> Someday I'll look back on all this and laugh... until they sedate me.
> 
> -- 
> 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/A2CEA9EA-238D-489C-9885-90364D1A3D90%40barebones.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/8054A041-8AF5-4673-9A73-CAE05C4177CA%40gmx.de.