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
I want to split a given string which could possibly contain a numeric
value, using regexp_matches.
The numeric value may contain an optional positive or negative sign, an
optional decimal place.
The result should *also* report the non-matching parts before and after the
identified numeric values
