Date: Thu, 7 Apr 2016 11:42:57 -0400
From: Greg Sabino Mullane <greg@endpoint.com>
To: "FBurgess@Radiantblue.com" <FBurgess@Radiantblue.com>
Cc: "pgus-general@postgresql.org" <pgus-general@postgresql.org>
Subject: Re: PostgreSQL POSIX regular expression problem
Message-ID: <20160407154255.GD4082@localhost.localdomain>
References: 
 <3BBE635F64E28D4C899377A61DAA9FE04530581C@NBSVR-MAIL01.radiantblue.local>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-ripemd160;
	protocol="application/pgp-signature"; boundary="PHCdUe6m4AxPMzOu"
Content-Disposition: inline
In-Reply-To: 
 <3BBE635F64E28D4C899377A61DAA9FE04530581C@NBSVR-MAIL01.radiantblue.local>
User-Agent: Mutt/1.5.24 (2015-08-30)
Precedence: bulk
Sender: pgus-general-owner@postgresql.org


--PHCdUe6m4AxPMzOu
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On Wed, Apr 06, 2016 at 06:31:42PM +0000, FBurgess@Radiantblue.com wrote:
>   *   Trying to build a regular expression syntax that doesn't drop the l=
ast digit (5) at the very end of the phone number.
>=20
> testdb=3D# select substring('OfficeName: abc office supply PhoneNumber: [=
commercial] 865-999-5695 ' from 'PhoneNumber: \[commercial](.*?)(,|(\d\s+))=
');

You have two parens in there - the reason you are not getting the last digi=
t is that the first parens (.*?) scoops=20
up everything - including a leading space - up to the second parens (,|(\d\=
s+)), which ensures that the final digit=20
plus whitespace combination is always excluded from the first match.

That's a very specific regex. Can you simply slurp a phone number directly,=
 like so?:

substring('OfficeName: abc office supply PhoneNumber: [commercial] 865-999-=
5695 ' from '([\d\-]+)')


--=20
Greg Sabino Mullane greg@endpoint.com
End Point Corporation
PGP Key: 0x14964AC8

--PHCdUe6m4AxPMzOu
Content-Type: application/pgp-signature; name="signature.asc"

-----BEGIN PGP SIGNATURE-----

iEYEAREDAAYFAlcGf/8ACgkQvJuQZxSWSshQgwCg3NO8MuoROVe3RponIfoTU9WZ
Kg0AoJ7I1OdzQmv5anRiyLpShCOsilMs
=+AsW
-----END PGP SIGNATURE-----

--PHCdUe6m4AxPMzOu--