|
|
马上注册,结交更多好友,享用更多功能,让你轻松玩转社区。如果您注册时有任何问题请联系客服QQ: 83569622 。
您需要 登录 才可以下载或查看,没有帐号?注册
x
Below is a good SQR tip for stripping out special characters from those nasty Phone Number formats stored in HRMS.
begin-procedure main
.
.
do parse_phone($phone_number, $phone_number)
.
.
end-procedure main
begin-procedure parse_phone($iphone, rphone)
let #phonelen = length($iphone)
move 0 to #loops
while 1
let #loops = #loops + 1
let $value = substr($iphone, #loops, 1)
let #checkvalue = ascii($value)
if #checkvalue >= 48 and #checkvalue <= 57
let $rphone = $rphone//$value
end-if
if #phonelen = #loops
break
end-if
end-while
end-procedure parse_phone |
|