select * from
(select
regexp_replace('aa18140221015a18140221015aa','[^\\d][1][3|4|5|7|8]\\d{9}[^\\d]',':1519805') as phone from dim.dim_province
)t
(select
regexp_replace('aa18140221015a18140221015aa','[^\\d][1][3|4|5|7|8]\\d{9}[^\\d]',':1519805') as phone from dim.dim_province
)t