How to hide some numbers of mobile phone number
The ID card number and mobile phone number are relatively important private data in daily data management. When doing external query and data display, you often need to make * points of privacy to better protect information.
1. REPLACE() function
Use REPLACE()Function can replace some numbers in the number with "*".
REPLACE(oldtext*, startnum*, numchars*, newtext*)
Replace some text strings with different text strings based on the specified number of characters.
old_text: required. The text whose characters you want to replace. start_num: required. The position of the character to be replaced with new_text in old_text. num_chars: required. The number of characters in old_text that you want to replace with new_text. new_text: required. The text of the character in old_text is replaced.
REPLACE (Mobile phone number,4,4,"* * * *"), the 4th digit (that is, 4,5,6,7 digits) after the 4th digit in the mobile phone number, use the word"* * * *"To replace.
The following code can be directly copied to the formula editor,Replace the mobile phone number field.
{"text":"REPLACE(手机号码,4,4,\"****\")","marks":[{"from":{"line":0,"ch":8,"sticky":null},"to":{"line":0,"ch":14,"sticky":null},"value":"textField_ksgymtly","invalid":false}],"isCmData":true}
Form and formula display
When you fill in the real number at the mobile phone number, a phone number that hides the middle four digits is automatically generated at the replacement point.
Effect display
When you need to share these data with members or external members, you can share only the hidden mobile phone number field information, and the real mobile phone number information can be stored in the background data.
2. Effect demonstration
Effect demonstration
YIDA in order to better optimize the content and quality of YIDA user manual, it takes you 3-5 minutes to fill in the document feedback questionnaire. The document feedback questionnaire is submitted anonymously, and the questionnaire information is only used for YIDA document experience feedback collection. Thank you for your support for YIDA!
-------------------- Get the latest information YIDA, welcome to follow US--------------------
