Simple data anonymization: Difference between revisions

Simple data anonymization (edit)

16 bytes added , 28 July 2016

no edit summary

15,030

edits

@@ Line 2: / Line 2: @@
 Simple data anonymization 使用 Excel 或 MySQL 資料庫查詢方式，做簡易個資去識別化
-== case1: 王小明 --> 王O明 ==
+== case1: 王小明 --> 王OO ==
+ex:
+* 王小明 --> 王OO
+* 複姓小英 --> 複OO
+作法
+* 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, 2, "O")</nowiki>}} {{exclaim}} only applied for 3 words, NOT for 4 words
+* MySQL: {{kbd | key=<nowiki>SELECT CONCAT(LEFT("王小明", 1), 'OO')</nowiki>}}
+== case2: 王小明 --> 王O明 ==
 ex: 王小明 --> 王O明
 * Excel:
@@ Line 21: / Line 35: @@
 </pre>
-== case2: 王小明 --> 王OO ==
-ex: 王小明 --> 王OO
-* Excel:
-** {{kbd | key=<nowiki>=REPLACE(A2, 2, LEN(A2)-1, "OO")</nowiki>}} also applied for 3 or 4 words ex: 王王小明	-> 王OO
-** {{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>}}
 reference