14,958
edits
Data cleaning: Difference between revisions
Jump to navigation
Jump to search
→Data handling
| Line 459: | Line 459: | ||
</pre> | </pre> | ||
=== | === Remove other string 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] (全形空白、全型空白, U+3000)<ref>[https://www.ptt.cc/bbs/PHP/M.1473522044.A.4FC.html Re: 請益 mysql空百=？ - 看板 PHP - 批踢踢實業坊]</ref>: | # [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>: | ||
| Line 467: | Line 467: | ||
# ASCII Horizontal Tab (TAB) \t | # ASCII Horizontal Tab (TAB) \t | ||
# ASCII Backspace \b | # ASCII Backspace \b | ||
[https://en.wikipedia.org/wiki/Non-breaking_space Non-breaking space] ({{kbd | key=<nowiki>nbsp;</nowiki>}}) | |||
* PHP: {{kbd | key=<nowiki>$result = str_replace("\xc2\xa0", ' ', $original_string);</nowiki>}}<ref>[https://stackoverflow.com/questions/40724543/how-to-replace-decoded-non-breakable-space-nbsp php - How to replace decoded Non-breakable space (nbsp) - Stack Overflow]</ref> | |||
== Further reading == | == Further reading == | ||