15,073
edits
Simple data anonymization: Difference between revisions
Jump to navigation
Jump to search
no edit summary
No edit summary |
No edit summary |
||
| Line 2: | Line 2: | ||
== 姓名的個資去識別化 == | == 姓名的個資去識別化 == | ||
=== case1 | === case1: 王小明 --> 王O明; 孤獨求敗 --> 孤OO敗 === | ||
Reserve the first and last characters of name, and replace other characters with the symbol 'OO'. | Reserve the first and last characters of name, and replace other characters with the symbol 'OO'. | ||
| Line 52: | Line 39: | ||
END; | END; | ||
</pre> | </pre> | ||
=== case2: 王小明 --> 王O明; 孤獨求敗 --> 孤O敗 === | |||
ex: | |||
* 楊過 -> 楊O | |||
* 王小明 --> 王O明 | |||
* 孤獨求敗 --> 孤O敗 | |||
* Guo da-xia --> GOa | |||
methods | |||
* Excel: | |||
** {{kbd | key=<nowiki>=IF(LEN(A2)=2, LEFT(A2, 1)&"O", LEFT(A2, 1)&REPT("O", 1)&RIGHT(A2, 1))</nowiki>}} also applied for 3 or 4 characters | |||
=== case3: 王小明 --> 王OO; 孤獨求敗 --> 孤OO === | === case3: 王小明 --> 王OO; 孤獨求敗 --> 孤OO === | ||