Sanjaya Vithanagama svithanag...@gmail.com 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+)))(.*)')
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 kgri...@ymail.com wrote:
Sanjaya Vithanagama svithanag...@gmail.com wrote:
I can match the numeric value and the rest of the string after
the numeric value using the
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