Simple data anonymization: Difference between revisions
Jump to navigation
Jump to search
(Created page with " Simple data anonymization ex: 王小明 --> 王O明 * Excel: {{kbd | key=<nowiki>=REPLACE(A2, 2, 1, O)</nowiki>}} source: [http://blog.xuite.net/yh96301/blog/80724141-Excel...") |
No edit summary |
||
| Line 3: | Line 3: | ||
ex: 王小明 --> 王O明 | ex: 王小明 --> 王O明 | ||
* Excel: {{kbd | key=<nowiki>=REPLACE(A2, 2, 1, O)</nowiki>}} | * Excel: {{kbd | key=<nowiki>=REPLACE(A2, 2, 1, O)</nowiki>}}<ref>[http://blog.xuite.net/yh96301/blog/80724141-Excel+2010%E5%A7%93%E5%90%8D%E7%9A%84%E7%AC%AC%E4%BA%8C%E5%80%8B%E5%AD%97%E5%8F%96%E4%BB%A3%E7%82%BAO Excel 2010姓名的第二個字取代為O @ 軟體使用教學 :: 隨意窩 Xuite日誌]</ref> | ||
* PHP: using regular_replace | * PHP: using regular_replace | ||
<pre> | <pre> | ||
| Line 21: | Line 21: | ||
* MySQL: {{kbd | key=<nowiki>SELECT CONCAT(LEFT("王小明", 1), 'OO')</nowiki>}} | * MySQL: {{kbd | key=<nowiki>SELECT CONCAT(LEFT("王小明", 1), 'OO')</nowiki>}} | ||
reference | |||
<references /> | |||
further reading | further reading | ||
Revision as of 09:58, 8 September 2015
Simple data anonymization
ex: 王小明 --> 王O明
- Excel: =REPLACE(A2, 2, 1, O)[1]
- PHP: using regular_replace
$string = '王小明'; $pattern = '/^(\X)(\X)(\X+)/u'; $replacement = '$1O$3'; echo preg_replace($pattern, $replacement, $string);
- MySQL: using SUBSTRING
SELECT CONCAT(SUBSTRING_INDEX('王小明', SUBSTRING('王小明', 2, 1), 1),
SUBSTRING('王小明', 2, 1),
SUBSTRING_INDEX('王小明', SUBSTRING('王小明', 2, 1), -1));
ex: 王小明 --> 王OO
- MySQL: SELECT CONCAT(LEFT("王小明", 1), 'OO')
reference
further reading