Thanks for the tip! On Thu, Jan 3, 2019 at 12:58 PM David G. Johnston < david.g.johns...@gmail.com> wrote:
> On Thursday, January 3, 2019, Glenn Schultz <gl...@bondlab.io> wrote: > >> All, >> >> I am writing a query to select * from where ~ '[regx] an example of the >> sting that I am matching is below >> >> FHLG16725 >> >> The first two alpha characters to match are FN, FH, GN any alpha >> characters between those and the numeric don't matter as the first two >> alpha + numeric will create a unique. >> >> reading the docs I am pretty sure I need to use ~ for bracket expression >> >> I tried '^[FN-FG-GN][0-9]' but does not seem to work. I have to admit I >> am weak on regex - never quite seem to be able to get it through my coconut. >> > > Yeah...that’s not even close...not exactly sure what it would match but > it’s only two characters, one letter maybe and one number. You seem to > want capturing groups though so using the ~ operator isn’t going to work, > you need to use the function. > > >> >> Any help would be appreciated, >> Glenn >> > > ~ ‘^(FN|FH|GN)[A-Z]*[0-9]+$’ > > David J. >
