From: | Kevin Grittner <kgrittn(at)ymail(dot)com> |
---|---|
To: | Sanjaya Vithanagama <svithanagama(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Splitting a string containing a numeric value in to three parts |
Date: | 2015-07-27 15:06:54 |
Message-ID: | 450394410.3030345.1438009614365.JavaMail.yahoo@mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Sanjaya Vithanagama <svithanagama(at)gmail(dot)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+)))(.*)')
> outputs array {+123123.453,the-123re}.
>
> Where I am having trouble is with matching the first part of the
> string. In other words what needs to be 'RE' in the following
> expression for it to report the all three elements of the array.
>
> select regexp_matches('hello+123123.453the-123re',
> '((RE)[\+|-]?(?:\d*(?:(?:\.)?\d+)))(.*)')
> should return array {hello,+123123.453,the-123re}.
select regexp_matches('hello+123123.453the-123re',
'^(.*?)([\+|-]?(?:\d*(?:(?:\.)?\d+)))(.*)$')
--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
From | Date | Subject | |
---|---|---|---|
Next Message | Herouth Maoz | 2015-07-27 15:07:40 | Re: Connections closing due to "terminating connection due to administrator command" |
Previous Message | Adrian Klaver | 2015-07-27 15:01:34 | Re: Connections closing due to "terminating connection due to administrator command" |