From: TJMcK <tim...@gm...> - 2014-06-11 00:34:46
|
I know that to use gramps to its fullest potential I need to use filters. And part of this feature is using "regular expressions". I've been reading about regular expressions, and have experimented with them in the sidebar filters. (BTW, I could not find anything in the gramps wiki about using regexp in the sidebar filters.) Some of my created regexps have worked -- most have not. At this point I'm feeling a bit frustrated... as if I should get a degree in programming to fully understand how to use the "regular expressions" in gramps. But, I can see that "regular expressions" could be very useful... For instance, here's one that I regularly use: In the "People View" -> in the Name field: name1|name2|name3 I also like, "People View" -> in the Name field: Ja(c|k)ob Theoretically there must be hundreds of other good examples... like: Find the families that have at least 3 children, with three of them named Peter, Paul and Mary? One that should be easy, but I haven't figured out is: find people with birthdates in the year 1840 and 1740 (I thought you should be able to use the Birth Date field in the People View to do this) /I would really appreciate it if others would share some of their most used "regular expressions", that they use in the sidebar filter.../ -- View this message in context: http://gramps.1791082.n4.nabble.com/list-of-regular-expressions-that-you-use-in-the-sidebar-filter-tp4666165.html Sent from the GRAMPS - User mailing list archive at Nabble.com. |
From: lynches155 <lyn...@ho...> - 2014-06-11 09:47:52
|
On 11/06/2014 01:34, TJMcK wrote: > /I would really appreciate it if others would share some of their most used > "regular expressions", that they use in the sidebar filter.../ > I use ^abc to find names starting with the given string, and xyz$ to find names ending with the given string. Mary |
From: TJMcK <tim...@gm...> - 2014-06-11 20:51:36
|
lynches155 wrote > I use ^abc to find names starting with the given string, and xyz$ to > find names ending with the given string. So, if I'm correct, a regex like: (^sus)|(anna) would pick up names such as: Anna, Susanna, Susannah, Susan, Susie Very useful. Thanks Mary. -- View this message in context: http://gramps.1791082.n4.nabble.com/list-of-regular-expressions-that-you-use-in-the-sidebar-filter-tp4666165p4666181.html Sent from the GRAMPS - User mailing list archive at Nabble.com. |
From: NdK <ndk...@gm...> - 2014-06-12 04:38:20
|
Il 11/06/2014 22:50, TJMcK ha scritto: > So, if I'm correct, a regex like: > (^sus)|(anna) > would pick up names such as: Anna, Susanna, Susannah, Susan, Susie That would also pick Marianna and Cannabis ( :) ), that might not be what you want... > Very useful. Thanks Mary. Writing regular expressions is nearly an art :) |
From: Gerhard K. <ge...@ki...> - 2014-06-12 13:26:42
|
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Am 12.06.2014 06:38, schrieb NdK: > Il 11/06/2014 22:50, TJMcK ha scritto: > >> So, if I'm correct, a regex like: (^sus)|(anna) would pick up >> names such as: Anna, Susanna, Susannah, Susan, Susie > That would also pick Marianna and Cannabis ( :) ), that might not > be what you want... > While we are at the subject: How do I match for all people named "Georg Mayr" where "Georg" is the given name and "Mayr" the family name? Cheers, Gerhard -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 Comment: Using GnuPG with Icedove - http://www.enigmail.net/ iEYEARECAAYFAlOZqogACgkQfg6TFvELooSjgACgloctnLtZFuv/qEDMdUoHtvKk dyYAn1YWIMqizpYeR+mDdZQc+5rh1Kd5 =5qL/ -----END PGP SIGNATURE----- |
From: TJMcK <tim...@gm...> - 2014-06-14 19:46:27
|
Douglas Bainbridge wrote > On 12/06/14 14:26, Gerhard Killesreiter wrote: > >> While we are at the subject: How do I match for all people named >> "Georg Mayr" where "Georg" is the given name and "Mayr" the family name? > > In Person Filter Editor, People with the > <name> > Given name: > = Georg; Family name:= Mayr Make note, this is a filter for the "filter editor" not the "sidebar filter" (although you use the sidebar filter to run the saved filter that you create in the filter editor). I don't think the above filter can be created in the sidebar filter alone. -- View this message in context: http://gramps.1791082.n4.nabble.com/list-of-regular-expressions-that-you-use-in-the-sidebar-filter-tp4666165p4666206.html Sent from the GRAMPS - User mailing list archive at Nabble.com. |
From: Gerhard K. <ge...@ki...> - 2014-06-14 20:48:18
|
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Am 14.06.2014 21:45, schrieb TJMcK: > Douglas Bainbridge wrote >> On 12/06/14 14:26, Gerhard Killesreiter wrote: >> >>> While we are at the subject: How do I match for all people >>> named "Georg Mayr" where "Georg" is the given name and "Mayr" >>> the family name? >> >> In Person Filter Editor, People with the <name> Given name: = >> Georg; Family name:= Mayr Thanks, Douglas! > Make note, this is a filter for the "filter editor" not the > "sidebar filter" (although you use the sidebar filter to run the > saved filter that you create in the filter editor). I don't think > the above filter can be created in the sidebar filter alone. Yes, this is somewhat unfortunate. Just creating an extra filter for such a task is not very userfriendly. Cheers, Gerhard -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 Comment: Using GnuPG with Icedove - http://www.enigmail.net/ iEYEARECAAYFAlOctQcACgkQfg6TFvELooSm8ACffkJ6tgAPTtdPl1nwv1OGZlif 3SkAn2fkxKlVfLSsa7a6C6d36XWMVCH+ =l3O0 -----END PGP SIGNATURE----- |
From: Douglas B. <dou...@ca...> - 2014-06-11 13:11:21
|
On 11/06/14 01:34, TJMcK wrote: > I know that to use gramps to its fullest potential I need to use filters. > And part of this feature is using "regular expressions". I've been reading > about regular expressions, and have experimented with them in the sidebar > filters. (BTW, I could not find anything in the gramps wiki about using > regexp in the sidebar filters.) Some of my created regexps have worked -- > most have not. At this point I'm feeling a bit frustrated... as if I should > get a degree in programming to fully understand how to use the "regular > expressions" in gramps. > > But, I can see that "regular expressions" could be very useful... For > instance, here's one that I regularly use: > > In the "People View" -> in the Name field: name1|name2|name3 > I also like, "People View" -> in the Name field: Ja(c|k)ob > > Theoretically there must be hundreds of other good examples... like: > Find the families that have at least 3 children, with three of them named > Peter, Paul and Mary? > One that should be easy, but I haven't figured out is: find people with > birthdates in the year 1840 and 1740 (I thought you should be able to use > the Birth Date field in the People View to do this) > > /I would really appreciate it if others would share some of their most used > "regular expressions", that they use in the sidebar filter.../ > As a general comment, dates are a bit of a nuisance, filterwise. They're formatted and don't allow regular expressions, with the marked disadvantage that you can't search for missing date fields, for example. However in relation to your problem, is it that you want to find people with the exact birthdate 1843, say? If so, Edit=>Preferences=>Dates and set the 'Date about range:' to 0 (temporarily). Then setting the Birth Date field in People View sidebar Filter to 1843 should show only people with '1843' and 'about 1843' entries for their birthdates. (Change the Date about range back afterwards). Doug |
From: paul w. <pw...@pa...> - 2014-06-11 14:56:26
|
TJMcK wrote: > I know that to use gramps to its fullest potential I need to use filters. > And part of this feature is using "regular expressions". I've been reading > about regular expressions, and have experimented with them in the sidebar > filters. (BTW, I could not find anything in the gramps wiki about using > regexp in the sidebar filters.) Some of my created regexps have worked -- > most have not. At this point I'm feeling a bit frustrated... as if I should > get a degree in programming to fully understand how to use the "regular > expressions" in gramps. I was "just" going to post one of the many good tutorials on RE from the web. But there really aren't that many that I'd dare show to a non programmer. This is the best I've found, and it's not as good as I'd hoped. http://www.aivosto.com/vbtips/regex.html BugBear |
From: TJMcK <tim...@gm...> - 2014-06-11 21:12:09
|
paul womack wrote > I was "just" going to post one of the many > good tutorials on RE from the web. But there really > aren't that many that I'd dare show to a non programmer. > > This is the best I've found, and it's not as good as I'd hoped. > > http://www.aivosto.com/vbtips/regex.html -------------------------- That is a good one... I looked at dozens of sites and all are a little overwhelming. Many of the tips on this site would be useful if they were on the gramps wiki page. (hint, hint -- to whoever does these wiki changes). Or even the link would be useful. While I talk about using filters for "non-programmers" like me... I have a question. /Have the gramps developers ever considered developing a "wizard" for creating and testing regexp? / I've seen a few apps, like Kodos and Visual Exp (for linux), but they were mostly too complex. Among Windows software, I found "RegexBuddy" (didn't test it). From what I read, it has many great features, a few of which seem to be more to my programming abilities. I'm just thinking that there must me more users (or potential users) that would find a wizard very appealing... making gramps more accessible to the general public... but for now, I'm glad that some of you readers have contributed your most used regular expressions. More please! -- View this message in context: http://gramps.1791082.n4.nabble.com/list-of-regular-expressions-that-you-use-in-the-sidebar-filter-tp4666165p4666183.html Sent from the GRAMPS - User mailing list archive at Nabble.com. |
From: TJMcK <tim...@gm...> - 2014-06-14 19:59:03
|
paul womack wrote > ...there really aren't that many that I'd dare show to a non programmer. > > This is the best I've found, and it's not as good as I'd hoped. > > http://www.aivosto.com/vbtips/regex.html I tried a number of ideas that I got from the above website. It appears that you can't use regexp in any of the sidebar date fields, which is disappointing. I would think that codes like the following would be useful: 184(6|8|9) OR 1829|1849 OR \d\d\d\d OR others that would extract all dates with about, before, after, between, etc... BTW, there's a very small bug... when you run a "not-allowed" regexp (at least in the date fields of the sidebar), the field area turns red, but it stays red (even after resetting) and will only go back to normal color when gramps is restarted. -- View this message in context: http://gramps.1791082.n4.nabble.com/list-of-regular-expressions-that-you-use-in-the-sidebar-filter-tp4666165p4666207.html Sent from the GRAMPS - User mailing list archive at Nabble.com. |
From: Gerhard K. <ge...@ki...> - 2014-06-14 20:50:59
|
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Am 14.06.2014 21:58, schrieb TJMcK: > paul womack wrote >> ...there really aren't that many that I'd dare show to a non >> programmer. >> >> This is the best I've found, and it's not as good as I'd hoped. >> >> http://www.aivosto.com/vbtips/regex.html > > I tried a number of ideas that I got from the above website. > > It appears that you can't use regexp in any of the sidebar date > fields, which is disappointing. I would think that codes like the > following would be useful: 184(6|8|9) OR 1829|1849 OR \d\d\d\d > OR others that would extract all dates with about, before, after, > between, etc... > For this, you can use the "range" setting in the date field. Cheers, Gerhard -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 Comment: Using GnuPG with Icedove - http://www.enigmail.net/ iEYEARECAAYFAlOctagACgkQfg6TFvELooTTggCfTJuCN5MWJvSBtTijomUQYU6a vKsAoK7TnRbpDHZduGxNGP3PTwQ1urtF =wfIy -----END PGP SIGNATURE----- |
From: Martin S. <mar...@ma...> - 2014-06-16 17:11:39
|
On Sat, Jun 14, 2014 at 12:58:26PM -0700, TJMcK wrote: >184(6|8|9) OR >1829|1849 OR >\d\d\d\d OR Shorter forms: 184[689] 18[24]9 \d{4} If you're on a unix-like os, the man page for grep provides a succinct overview of regular expressions, as does the regex man page (for me 'man 7 regex'). M. |
From: Douglas B. <dou...@ca...> - 2014-06-16 20:14:31
|
On 16/06/14 17:59, Martin Steer wrote: > On Sat, Jun 14, 2014 at 12:58:26PM -0700, TJMcK wrote: > >> 184(6|8|9) OR >> 1829|1849 OR >> \d\d\d\d OR > Shorter forms: > > 184[689] > 18[24]9 > \d{4} > > If you're on a unix-like os, the man page for grep provides a succinct > overview of regular expressions, as does the regex man page (for me 'man > 7 regex'). > > M. Interesting examples, but note: of no practical use because, alas, regex don't work with dates! Doug |
From: TJMcK <tim...@gm...> - 2014-06-19 21:24:02
|
Martin Steer-2 wrote > If you're on a unix-like os, the man page for grep provides a succinct > overview of regular expressions, as does the regex man page (for me 'man > 7 regex'). Succint? Unfortunately there's way too much info for me... and how much of the man page is applicable to gramps sidebar filters (or the filter editor, for that matter) -- maybe 10%? Let me know if I'm wrong... give me a complex regexp that I can apply in the filter sidebar that uses many of the options in the grep man page. Again... I would really like to see concrete examples (in the gramps wiki help) of how to use regular expressions in the sidebar. So far, the few examples that have been given in this thread could be put in a pop-up help when hovering the "regular expression" box... At this point my conclusion of this feature is: that it's a very simplistic and limited version of all that's possible with regular expressions. With that said, the few regexp options that I've discovered have been very useful... -- View this message in context: http://gramps.1791082.n4.nabble.com/list-of-regular-expressions-that-you-use-in-the-sidebar-filter-tp4666165p4666315.html Sent from the GRAMPS - User mailing list archive at Nabble.com. |
From: Douglas B. <dou...@ca...> - 2014-06-19 21:52:44
|
On 19/06/14 22:23, TJMcK wrote: > Martin Steer-2 wrote >> If you're on a unix-like os, the man page for grep provides a succinct >> overview of regular expressions, as does the regex man page (for me 'man >> 7 regex'). > Succint? Unfortunately there's way too much info for me... and how much of > the man page is applicable to gramps sidebar filters (or the filter editor, > for that matter) -- maybe 10%? Let me know if I'm wrong... give me a > complex regexp that I can apply in the filter sidebar that uses many of the > options in the grep man page. > > Again... I would really like to see concrete examples (in the gramps wiki > help) of how to use regular expressions in the sidebar. So far, the few > examples that have been given in this thread could be put in a pop-up help > when hovering the "regular expression" box... At this point my conclusion > of this feature is: that it's a very simplistic and limited version of all > that's possible with regular expressions. > > With that said, the few regexp options that I've discovered have been very > useful... Have you looked at the gramps 3.4 Wiki Manual - Filters: section 2: Regular expressions? Although not comprehensive, there's enough there to get you well on your way. The concrete examples given there include some quite complex regexes taken from expressions used by the filter editor or sidebar in actual gramps databases. (However don't expect every regex feature to work in gramps; some don't). Doug |
From: TJMcK <tim...@gm...> - 2014-06-25 19:21:06
|
Douglas Bainbridge wrote > Have you looked at the gramps 3.4 Wiki Manual - Filters: > section 2: Regular expressions? > Although not comprehensive, there's enough there to get you > well on your way. > The concrete examples given there include some quite complex > regexes taken from expressions used by the filter editor or > sidebar in actual gramps databases. > (However don't expect every regex feature to work in gramps; > some don't). I did look up the filters section by clicking on the help in gramps menu. When the browser page appeared I typed in "regular expressions". I selected the result that I thought best matched what I had read in Doug's message... and when I read the page there was only a short sentence about regular expressions. I thought I'd try a different result from my search... same thing... nothing about regular expressions except a vague reference. I was about to respond to you with a request for where you found this information... but when I reread your email I saw the "3.4" and thought I'd better double check what I had found in the wiki. Sure enough, all the search results I had looked at were in the top 10 (visible part of my screen), BUT they all were results for older versions of gramps! To find the topic that you actually referred to in your email I had to scroll nearly 3 screens down!! Can something be adjusted or changed to improve the search results? As a "normal" gramps user I've been doing the same thing in the past (ie with searches about regex), because I had spent some time looking for info about regexp in the gramps wiki, and found nothing relevant. Obviously, the info was there but I didn't find it. To improve the search results I'd like there to be check boxes below the search box, to select which versions to search (the first and default option would be to search all versions). Some of the info on the gramps wiki is getting very outdated, and in my experience, can be deceiving -- and ultimately it's very frustrating not to find some concise useful information when searching for it. Any chance of this happening? -- View this message in context: http://gramps.1791082.n4.nabble.com/list-of-regular-expressions-that-you-use-in-the-sidebar-filter-tp4666165p4666399.html Sent from the GRAMPS - User mailing list archive at Nabble.com. |
From: Douglas B. <dou...@ca...> - 2014-06-25 21:48:35
|
On 25/06/14 20:20, TJMcK wrote: > Douglas Bainbridge wrote >> Have you looked at the gramps 3.4 Wiki Manual - Filters: >> section 2: Regular expressions? >> Although not comprehensive, there's enough there to get you >> well on your way. >> The concrete examples given there include some quite complex >> regexes taken from expressions used by the filter editor or >> sidebar in actual gramps databases. >> (However don't expect every regex feature to work in gramps; >> some don't). > I did look up the filters section by clicking on the help in gramps menu. > When the browser page appeared I typed in "regular expressions". I selected > the result that I thought best matched what I had read in Doug's message... > and when I read the page there was only a short sentence about regular > expressions. I thought I'd try a different result from my search... same > thing... nothing about regular expressions except a vague reference. I was > about to respond to you with a request for where you found this > information... but when I reread your email I saw the "3.4" and thought I'd > better double check what I had found in the wiki. Sure enough, all the > search results I had looked at were in the top 10 (visible part of my > screen), BUT they all were results for older versions of gramps! To find > the topic that you actually referred to in your email I had to scroll nearly > 3 screens down!! > > Can something be adjusted or changed to improve the search results? As a > "normal" gramps user I've been doing the same thing in the past (ie with > searches about regex), because I had spent some time looking for info about > regexp in the gramps wiki, and found nothing relevant. Obviously, the info > was there but I didn't find it. > > To improve the search results I'd like there to be check boxes below the > search box, to select which versions to search (the first and default option > would be to search all versions). Some of the info on the gramps wiki is > getting very outdated, and in my experience, can be deceiving -- and > ultimately it's very frustrating not to find some concise useful information > when searching for it. Any chance of this happening? > Not a bad idea! I've found it frustrating sometimes tracking down correct Add-on versions. But apologies on my part, I should have provided you with the proper link instead of just a text reference. Doug |
From: Douglas B. <dou...@ca...> - 2014-06-12 18:42:55
|
On 12/06/14 14:26, Gerhard Killesreiter wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Am 12.06.2014 06:38, schrieb NdK: >> Il 11/06/2014 22:50, TJMcK ha scritto: >> >>> So, if I'm correct, a regex like: (^sus)|(anna) would pick up >>> names such as: Anna, Susanna, Susannah, Susan, Susie >> That would also pick Marianna and Cannabis ( :) ), that might not >> be what you want... >> > While we are at the subject: How do I match for all people named > "Georg Mayr" where "Georg" is the given name and "Mayr" the family name? > Cheers, > Gerhard > > > In Person Filter Editor, People with the <name> Given name: = Georg; Family name:= Mayr Doug |
From: Nick H. <ni...@gr...> - 2014-06-19 22:18:30
|
On 19/06/14 22:52, Douglas Bainbridge wrote: > (However don't expect every regex feature to work in gramps; > some don't). Internally Gramps uses the python re module. So you could look at the python documentation: https://docs.python.org/2/howto/regex.html https://docs.python.org/2/library/re.html Regular expressions are compiled using the IGNORE, UNICODE and LOCALE flags. Patterns are matched using the search method. We only allow regular expression matching on text fields. Date objects use their own matching algorithms. Nick. |
From: Brad R. <br...@fi...> - 2014-06-20 06:51:00
Attachments:
signature.asc
|
On Thu, 19 Jun 2014 23:18:22 +0100 Nick Hall <ni...@gr...> wrote: Hello Nick, >We only allow regular expression matching on text fields. Date objects >use their own matching algorithms. Speaking of which; Is it possible to date match on date & month only? For example, if I want to search for events that occurred on 4th July, irrespective of year. -- Regards _ / ) "The blindingly obvious is / _)rad never immediately apparent" It belongs to them, let's give it back Beds Are Burning - Midnight Oil |
From: Doug B. <dou...@gm...> - 2014-06-20 11:21:33
|
On Fri, Jun 20, 2014 at 1:37 AM, Brad Rogers <br...@fi...> wrote: > On Thu, 19 Jun 2014 23:18:22 +0100 > Nick Hall <ni...@gr...> wrote: > > Hello Nick, > > >We only allow regular expression matching on text fields. Date objects > >use their own matching algorithms. > > Speaking of which; Is it possible to date match on date & month only? > For example, if I want to search for events that occurred on 4th July, > irrespective of year. > No, there isn't currently a way to do that through the filter gramplets. But, you can bring up a Calendar Gramplet and double-click July 4th of any year, and see all of the events on that day. Hope that helps, -Doug > > -- > Regards _ > / ) "The blindingly obvious is > / _)rad never immediately apparent" > It belongs to them, let's give it back > Beds Are Burning - Midnight Oil > > > ------------------------------------------------------------------------------ > HPCC Systems Open Source Big Data Platform from LexisNexis Risk Solutions > Find What Matters Most in Your Big Data with HPCC Systems > Open Source. Fast. Scalable. Simple. Ideal for Dirty Data. > Leverages Graph Analysis for Fast Processing & Easy Data Exploration > http://p.sf.net/sfu/hpccsystems > _______________________________________________ > Gramps-users mailing list > Gra...@li... > https://lists.sourceforge.net/lists/listinfo/gramps-users > > |
From: Brad R. <br...@fi...> - 2014-06-20 12:30:20
Attachments:
signature.asc
|
On Fri, 20 Jun 2014 07:21:25 -0400 Doug Blank <dou...@gm...> wrote: Hello Doug, >No, there isn't currently a way to do that through the filter gramplets. >But, you can bring up a Calendar Gramplet and double-click July 4th of >any year, and see all of the events on that day. >Hope that helps, It does indeed. Thanks, Doug. -- Regards _ / ) "The blindingly obvious is / _)rad never immediately apparent" What will you do when the gas taps turn? The Gasman Cometh - Crass |