15,028
edits
Simple data anonymization: Difference between revisions
Jump to navigation
Jump to search
m
→case2: 王小明 --> 王OO
mNo edit summary |
|||
| Line 24: | Line 24: | ||
ex: 王小明 --> 王OO | ex: 王小明 --> 王OO | ||
* Excel: | * Excel: | ||
** {{kbd | key=<nowiki>=REPLACE(A2, 2, LEN(A2)-1, | ** {{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 | ** {{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>}} | ||