14,958
edits
Data cleaning: Difference between revisions
Jump to navigation
Jump to search
→Remove other string look like whitespace
| Line 468: | Line 468: | ||
# ASCII Backspace {{kbd | key=<nowiki>\b</nowiki>}} | # ASCII Backspace {{kbd | key=<nowiki>\b</nowiki>}} | ||
# [https://en.wikipedia.org/wiki/Non-breaking_space Non-breaking space] ({{kbd | key=<nowiki>nbsp;</nowiki>}}) Replace Non-breaking space with one whitespace using 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> | # [https://en.wikipedia.org/wiki/Non-breaking_space Non-breaking space] ({{kbd | key=<nowiki>nbsp;</nowiki>}}) Replace Non-breaking space with one whitespace using 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> | ||
How to display the Non-breaking space? In MySQL | |||
<pre> | |||
SELECT '12345678 '; | |||
SELECT HEX('12345678 '), LENGTH('12345678 '); | |||
-- Result of above query: 12345678C2A0 | |||
</pre> | |||
== Further reading == | == Further reading == | ||