15,026
edits
Simple data anonymization: Difference between revisions
Jump to navigation
Jump to search
no edit summary
(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 | ||