15,030
edits
Simple data anonymization: Difference between revisions
Jump to navigation
Jump to search
no edit summary
mNo edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
Simple data anonymization 使用 Excel 或 MySQL 資料庫查詢方式，做簡易個資去識別化 | Simple data anonymization 使用 Excel 或 MySQL 資料庫查詢方式，做簡易個資去識別化 | ||
== case1: 王小明 --> 王OO; 孤獨求敗 --> 孤OO == | == case1: 王小明 --> 王OO; 孤獨求敗 --> 孤OO == | ||
| Line 25: | Line 24: | ||
</pre> | </pre> | ||
== case2: 王小明 --> 王O明; 孤獨求敗 --> 孤OO敗 == | == case2: 王小明 --> 王OO; 孤獨求敗 --> 孤OO敗 == | ||
* 楊過 --> 楊OO | |||
* 王小明 --> 王OO | |||
* 孤獨求敗 --> 孤OO敗 | |||
* Guo da-xia --> GOO da-xia | |||
methods: | |||
* Excel: | |||
** {{kbd | key=<nowiki>=REPLACE(A1, 2, 2, "OO")</nowiki>}} | |||
* PHP | |||
<pre> | |||
//$string = '楊過'; | |||
$string = '王小明'; | |||
//$string = '孤獨求敗'; | |||
//$string = 'Guo da-xia'; | |||
$pattern = '/^(\X)(\X\X?)(\X?)/u'; | |||
$replacement = '$1OO$3'; | |||
echo preg_replace($pattern, $replacement, $string); | |||
</pre> | |||
== case3: 王小明 --> 王O明; 孤獨求敗 --> 孤OO敗 == | |||
ex: | ex: | ||
* 楊過 --> 楊O | * 楊過 --> 楊O | ||