Re: Control PhoneNumber Via SQL

[tango ward <tangoward15@xxxxxxxxx>]

Sorry for bumping this email.

I would just like to clarify regarding regexp_replace:

WHEN mobilenumber ~'^9[0-9]' AND LENGTH(mobilenumber) = 10
THEN regexp_replace(mobilenumber, '', '+63')

If the pattern is empty '', does this mean that the replacement_string param will be added to the value of source? It does what I want it to do but I am not sure if that's always the case if pattern param is empty.

On Wed, May 16, 2018 at 9:04 AM, tango ward <tangoward15@xxxxxxxxx> wrote:

Okay, I figured it out.

cur_t.execute("""
                SELECT
                CASE
                  WHEN mobilenumber ~'^0[1-9]'
                  THEN regexp_replace(mobilenumber, '0', '+63')
                  ELSE mobilenumber
                END
                FROM studeprofile
                ORDER BY lastname
                """)

In my previous SELECT statement, I picked the mobilenumber before running a CASE statement to it instead of jumping directly to CASE statement after SELECT.

On Wed, May 16, 2018 at 8:59 AM, tango ward <tangoward15@xxxxxxxxx> wrote:

Did the CASE Statement produce the other columns Sir?

On Wed, May 16, 2018 at 8:53 AM, David G. Johnston <david.g.johnston@xxxxxxxxx> wrote:

On Tuesday, May 15, 2018, tango ward <tangoward15@xxxxxxxxx> wrote:

I can access the index 1 of the output list to get the +639078638001. I think this has been explained already by Sir Adrian in my previous question about the about being shown as list. I'll review that.

Last time you had multiple rows...this time you have multiple columns...

David J.