15,030
edits
Simple data anonymization: Difference between revisions
Jump to navigation
Jump to search
→case2: 王小明 --> 王OO; 孤獨求敗 --> 孤OO敗
No edit summary |
|||
| Line 31: | Line 31: | ||
methods: | methods: | ||
* Excel | * Excel | ||
** {{kbd | key=<nowiki>=REPLACE(A1, 2, 2, "OO")</nowiki>}} | ** {{kbd | key=<nowiki>=REPLACE(A1, 2, 2, "OO")</nowiki>}} | ||
| Line 44: | Line 44: | ||
$replacement = '$1OO$3'; | $replacement = '$1OO$3'; | ||
echo preg_replace($pattern, $replacement, $string); | echo preg_replace($pattern, $replacement, $string); | ||
</pre> | |||
* MySQL | |||
<pre> | |||
-- SET @name := "楊過"; | |||
SET @name := "王小明"; | |||
-- SET @name := "孤獨求敗"; | |||
-- SET @name := "Guo da-xia"; | |||
SELECT CASE | |||
WHEN CHAR_LENGTH(@name) =2 THEN CONCAT(LEFT(@name, 1), 'OO') | |||
ELSE CONCAT(LEFT(@name, 1), 'OO', RIGHT(@name, CHAR_LENGTH(@name)-3)) | |||
END; | |||
</pre> | </pre> | ||