This article mainly introduces the Regular Expression of js verification phone number and mobile phone support + 86. For more information, see.
Regular Expression Verification
This article mainly introduces the JS verification phone number and mobile phone support +86 regular expression. Need friends can come to the reference, I hope to help you. The code is as follows: ; nbsp;
In this paper, PHP implementation of the telephone number matching regular expression of an example, have the need for friends, refer to it.Example of a regular expression with a telephone number area:
[2,3,5,6,8,9] Only provide these types of mobile phone number: 12...,13...,15...,16...,18...,19 .... Insuffi
[0-9a-z] [a-z0-9\._-] {1,}@[a-z0-9-]{1,}[a-z0-9] (\.[ A-z]{1,}) +Many of the verification mailboxes that were found on the Internet do not support the verification of mailbox of level two domain nameHow to use JSfunction checkemail (email) { if (/^[0-9a-z][a-z0-9\._-]{1,}@[a-z0-9-]{1,}[a-z0-9] (\.[ A-z]{1,}) +$/. Test (email) { returntrue; } return false ;}How to use C #classProgram {Static voidMain (string[] args) {Console.WriteLi
Source: https://blog.csdn.net/seesun2012This is an execl文件导入数据库 operation that uses JXL parsing execl to import a database process 出现了科学计数法 that does not match the data you want to import, and the following are examples and solutions:example after successful import :1, mobile phone number: 15388886666 Scientific counting method:1.54E+102, Number: 123456789000000
sometimes in order to protect personal privacy, mobile phone numbers need to be treated confidentially.
This can be solved in 2 ways, by entering any formula in the C2 and filling the formula down.
=left (b2,3) "* * *" right (b2,4)
=replace (b2,4,4, "* * *")
Copy the contents of column C to column B and paste it as a value.
The cell phone number
After using Excel to enter the ID number, the bank account and so on the longer number, why becomes has the plus sign and the letter form? The following figure
This is a general problem with digital input. The default number format in E
1, first into the account center-security settings address: Https://account.live.com/proofs/Manage?mkt=zh-CN;
2, delete the phone number you have discarded, and then click the "Add Security information" link to add your new number.
As shown in the following illustration:
The above is the rapid replacement of the WIN8 system
I created a list of contacts using Excel. But I found a problem with the display of a phone number leading zero. When you enter "090", the result becomes "90". Why?
Put
this picture away.
expand this picture
If no leading zeros are displayed, the result is not a correct phone
A friend of the police station in the investigation of a case, encountered a problem of the title, ask me to help. He was unable to provide the original data because he wanted to keep it secret, but he gave me a request. They are now using a suspect's phone record to include n new suspects from the call log, as well as a call history for each suspect. Now it's time to count the calls, the same phone
Copy Code code as follows:
Mobile phone number Verification
function Checkmobilevalidity ($mobilephone) {
$exp = "/^13[0-9]{1}[0-9]{8}$|15[012356789]{1}[0-9]{8}$|18[012356789]{1}[0-9]{8}$|14[57]{1}[0-9]$/";
if (Preg_match ($exp, $mobilephone)) {
return true;
}else{
return false;
}
}
Mobile phone number At
Copy CodeThe code is as follows:
Mobile phone number Verification
function Checkmobilevalidity ($mobilephone) {
$exp = "/^13[0-9]{1}[0-9]{8}$|15[012356789]{1}[0-9]{8}$|18[012356789]{1}[0-9]{8}$|14[57]{1}[0-9]$/";
if (Preg_match ($exp, $mobilephone)) {
return true;
}else{
return false;
}
}
Cell phone number Attribution
Added to the 158, 159 the beginning of the phone number verification.
Copy Code code as follows:
Remove string and tail space
String.prototype.Trim = function () {
var m = This.match (/^\s* (\s+ (\s+\s+) *) \s*$/);
return (M = = null)? "": m[1];
}
Verify Legal mobile phone number
String.prot
When we enter a long string of numbers in Excel that are generally not segmented, what if you want to enter a segmented cell phone number in an Excel table? The following is an action tutorial.
Example: the cell phone number in c
1, mobile phones and computers first need to install 360 mobile phone assistants, the mobile phone with a USB cable to connect the computer, and then turn on "mobile Settings"-"Developer Options"-Open the "Open developer Option" and "USB debugging" switch, and then open the computer 360 phone assistant to the upper left corner of the
Excel mode:
Sheet1:
Sheet2:
Then select the tool-Macro-VB compiler: Add module writeCode:
Sub zxl_input_phone () set SH2 = worksheets ("sheet2") 'represents the sheet2 worksheet with an object variable r2 = sh2.range ("a65536 "). end (xlup ). row 'calculates the maximum row number of the data in column A of the sheet2 worksheet. worksheets ("sheet1 "). activate 'activate sheet1 worksheet R1
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.