15,030
edits
Simple data anonymization: Difference between revisions
Jump to navigation
Jump to search
→case2: 王小明 --> 王O明
| Line 26: | Line 26: | ||
== case2: 王小明 --> 王O明 == | == case2: 王小明 --> 王O明 == | ||
ex: 王小明 --> 王O明 | ex: | ||
* 楊過 --> 楊O | |||
* 王小明 --> 王O明 | |||
* 孤獨求敗 --> 孤OO敗 | |||
* Guo da-xia --> GOOOOOOOOa | |||
methods: | |||
* Excel: | * Excel: | ||
** {{kbd | key=<nowiki>= | ** {{kbd | key=<nowiki>=IF(LEN(A1)=2, LEFT(A1, 1)&"O", LEFT(A1, 1)&REPT("O", LEN(A1)-2)&RIGHT(A1, 1))</nowiki>}} | ||
** {{kbd | key=<nowiki>=REPLACE( | ** {{kbd | key=<nowiki>=REPLACE(A1, 2, 1, "O")</nowiki>}}<ref>[http://blog.xuite.net/yh96301/blog/80724141-Excel+2010%E5%A7%93%E5%90%8D%E7%9A%84%E7%AC%AC%E4%BA%8C%E5%80%8B%E5%AD%97%E5%8F%96%E4%BB%A3%E7%82%BAO Excel 2010姓名的第二個字取代為O @ 軟體使用教學 :: 隨意窩 Xuite日誌]</ref> {{exclaim}} only applied for 3 words, NOT for 4 words | ||
* PHP: using regular_replace | * PHP: using regular_replace | ||
<pre> | <pre> | ||
$string = | if(mb_strlen($string, "UTF-8") == 2){ | ||
$pattern = '/^(\X)(\X)(\X | echo mb_substr($string, 0, 1, "UTF-8") . "O"; | ||
$ | |||
echo | }else{ | ||
$pattern = '/^(\X)(\X+)(\X)/u'; | |||
preg_match($pattern, $string, $matches); | |||
echo $matches[1]. str_repeat("O", mb_strlen($string, "UTF-8") - 2) . $matches[3]; | |||
} | |||
</pre> | </pre> | ||
* MySQL: | * MySQL: | ||
<pre> | <pre> | ||
SELECT CONCAT( | SET @name := "楊過"; | ||
-- SET @name := "王小明"; | |||
-- SET @name := "孤獨求敗"; | |||
-- SET @name := "Guo da-xia"; | |||
SELECT CASE | |||
WHEN CHAR_LENGTH(@name) =2 THEN CONCAT(LEFT(@name, 1), 'O') | |||
ELSE CONCAT(LEFT(@name, 1), REPEAT('O', CHAR_LENGTH(@name)-2), RIGHT(@name, 1)) | |||
END; | |||
</pre> | </pre> | ||