业务实践中,直接用SQL从数据库中提出的手机号码大部分情况下存在乱号,如何剔除乱号?以下程序供参考:
(COMPRESS(mob_phe_txt,'0123456789','K') BETWEEN '13300000000' AND '13999999999'
or substr(COMPRESS(mob_phe_txt,'0123456789','K'),1,3)='159'
or substr(COMPRESS(mob_phe_txt,'0123456789','K'),1,3)='153')
AND LENGTH(COMPRESS(mob_phe_txt,'0123456789','K'))=11
)
or
(
(COMPRESS(mob_phe_txt,'0123456789','K') BETWEEN '013300000000' AND '013999999999'
or substr(COMPRESS(mob_phe_txt,'0123456789','K'),1,3)='159'
or substr(COMPRESS(mob_phe_txt,'0123456789','K'),1,3)='153')
AND LENGTH(COMPRESS(mob_phe_txt,'0123456789','K'))=12
)
注意:此段小程序只提取移动和联通号。