Simple data anonymization: Difference between revisions
Jump to navigation
Jump to search
m
Text replacement - "== references ==" to "== References =="
No edit summary |
m (Text replacement - "== references ==" to "== References ==") |
||
| (One intermediate revision by one other user not shown) | |||
| 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 === | ||
| Line 120: | Line 122: | ||
** {{kbd | key=<nowiki>=LEFT(A2, 5)&REPT("X", 5)&RIGHT(A2, 1)</nowiki>}} | ** {{kbd | key=<nowiki>=LEFT(A2, 5)&REPT("X", 5)&RIGHT(A2, 1)</nowiki>}} | ||
== | == References == | ||
<references /> | <references /> | ||