15,039
edits
Data cleaning: Difference between revisions
Jump to navigation
Jump to search
→Data handling: + Remove control character
mNo edit summary |
(→Data handling: + Remove control character) |
||
| Line 513: | Line 513: | ||
SELECT LENGTH(CONCAT('12345678', UNHEX('C2A0'))) | SELECT LENGTH(CONCAT('12345678', UNHEX('C2A0'))) | ||
-- Result of above query: 10 | -- Result of above query: 10 | ||
</pre> | |||
== Remove control character == | |||
[https://en.wikipedia.org/wiki/Control_character Control character - Wikipedia] Using PHP to clean control character: | |||
<pre> | |||
$input = 'some string may contains control characters'; | |||
$replacement = ''; | |||
$result = preg_replace('/[\x00-\x1F]/', $replacement, $input); | |||
</pre> | </pre> | ||