Thank you Kevin! I missed the start of string and end of string matching.
On Tue, Jul 28, 2015 at 1:06 AM, Kevin Grittner wrote:
> Sanjaya Vithanagama wrote:
>
> > I can match the numeric value and the rest of the string after
> > the numeric value using the following:
> >
> > select regexp_mat
Sanjaya Vithanagama wrote:
> I can match the numeric value and the rest of the string after
> the numeric value using the following:
>
> select regexp_matches('hello+123123.453the-123re',
>
> '([\+|-]?(?:\d*(?:(?:\.)?\d+)))(.*)')
> outputs array {+12312
