14,962
edits
Data cleaning: Difference between revisions
Jump to navigation
Jump to search
→Remove leading and trailing spaces from text
mNo edit summary |
|||
| Line 347: | Line 347: | ||
WHERE LENGTH(TRIM( `column` )) != LENGTH( `column` ); | WHERE LENGTH(TRIM( `column` )) != LENGTH( `column` ); | ||
</pre> | </pre> | ||
==== other text look like whitespace ==== | |||
# [http://www.fileformat.info/info/unicode/char/3000/index.htm IDEOGRAPHIC SPACE] (全形空白, U+3000): | |||
#* 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> | |||
# ASCII Vertical Tab \v | |||
# ASCII Horizontal Tab (TAB) \t | |||
# ASCII Backspace \b | |||
== related pages == | == related pages == | ||