15,030
edits
Simple data anonymization: Difference between revisions
Jump to navigation
Jump to search
→case1: 王小明 --> 王OO
No edit summary |
|||
| Line 5: | Line 5: | ||
== case1: 王小明 --> 王OO == | == case1: 王小明 --> 王OO == | ||
ex: | ex: | ||
* 楊過 -> 楊OO | |||
* 王小明 --> 王OO | * 王小明 --> 王OO | ||
* | * 孤獨求敗 --> 孤OO | ||
methods | |||
* Excel: | * Excel: | ||
** {{kbd | key=<nowiki>=REPLACE(A2, 2, LEN(A2)-1, "OO")</nowiki>}} also applied for 3 or 4 words | ** {{kbd | key=<nowiki>=REPLACE(A2, 2, LEN(A2)-1, "OO")</nowiki>}} also applied for 3 or 4 words | ||
** {{kbd | key=<nowiki>=REPLACE(A2, 2, 2, "O")</nowiki>}} {{exclaim}} only applied for 3 words, NOT for 4 words | ** {{kbd | key=<nowiki>=REPLACE(A2, 2, 2, "O")</nowiki>}} {{exclaim}} only applied for 3 words, NOT for 4 words | ||
* MySQL: {{kbd | key=<nowiki>SELECT CONCAT(LEFT("王小明", 1), 'OO')</nowiki>}} | * MySQL: {{kbd | key=<nowiki>SELECT CONCAT(LEFT("王小明", 1), 'OO')</nowiki>}} | ||
== case2: 王小明 --> 王O明 == | == case2: 王小明 --> 王O明 == | ||