How to Remove Emojis From Text — Why It Matters for Data and Code

Emojis are four-byte Unicode characters that cause problems in systems not designed to handle them — MySQL databases using the standard utf8 character set, legacy text fields, CSV exports, API payloads expecting plain text, and string processing code that does not account for multi-byte characters. Knowing how to strip emojis quickly is a practical data cleaning skill.

Remove all emojis from any text instantly with our free Emojis Remover tool. For other text cleanup, our Duplicate Lines Remover removes repeated lines and our Case Converter normalises capitalisation. For checking byte size after cleaning, use our Text Size Calculator.

MySQL and MariaDB databases using the utf8 character set — despite the name — only support 3-byte UTF-8 characters. Emojis are 4-byte characters, requiring the utf8mb4 encoding. Attempting to insert an emoji into a utf8 column produces the error: Incorrect string value. Solutions: convert the column to utf8mb4, or strip emojis before insertion. For legacy databases where changing the character set is risky, stripping emojis is the safer approach.

JavaScript counts string length in UTF-16 code units. Most emoji use two UTF-16 code units, so the string length of a single emoji is 2 in JavaScript despite being one visible character. This causes bugs in text truncation, character limit validation, and storage sizing. Use Array.from(str).length in JavaScript to get the correct Unicode character count for strings containing emoji.

Some Excel versions and CSV parsers handle emoji inconsistently, stripping them or corrupting surrounding text. Some APIs and webhook endpoints have character set restrictions or unexpected behaviour with emoji embedded in otherwise standard text. Form submissions and customer data often contain emoji from copy-pasted social media content that propagates into backend systems not built for it.

The cleanest approach: pip install emoji, then use emoji.replace_emoji(text, replace=""). Alternatively, using a regex targeting supplementary Unicode planes removes most emoji: import re, then re.sub with the pattern matching Unicode range U+10000 to U+10FFFF with the UNICODE flag. The emoji library is more accurate as it is regularly updated when new emoji are added.

A regex targeting common emoji Unicode ranges with the unicode flag and global flag removes most emoji from a string. The get-emoji and emoji-regex npm packages provide maintained, comprehensive patterns. The basic approach targets the major emoji blocks: emoticons, miscellaneous symbols, transport symbols, and the supplementary multilingual plane characters.