14,959
edits
Data cleaning: Difference between revisions
Jump to navigation
Jump to search
→other text look like whitespace
| Line 456: | Line 456: | ||
==== other text look like whitespace ==== | ==== other text look like whitespace ==== | ||
[https://en.wikipedia.org/wiki/Whitespace_character Whitespace character] | [https://en.wikipedia.org/wiki/Whitespace_character Whitespace character] | ||
# [http://www.fileformat.info/info/unicode/char/3000/index.htm IDEOGRAPHIC SPACE] ( | # [http://www.fileformat.info/info/unicode/char/3000/index.htm IDEOGRAPHIC SPACE] (全形空白、全型空白, U+3000)<ref>[https://www.ptt.cc/bbs/PHP/M.1473522044.A.4FC.html Re: 請益 mysql空百=？ - 看板 PHP - 批踢踢實業坊]</ref>: | ||
#* diaplay: <pre><nowiki><?php $string = "111" . json_decode('"\u3000"') . "222"; echo $string;?></nowiki></pre> | #* diaplay: <pre><nowiki><?php $string = "111" . json_decode('"\u3000"') . "222"; echo $string;?></nowiki></pre> | ||
#* replace with space: <pre><nowiki><?php echo str_replace(json_decode('"\u3000"'), " ", $string);?></nowiki></pre> | #* replace with space: <pre><nowiki><?php echo str_replace(json_decode('"\u3000"'), " ", $string);?></nowiki></pre> | ||