How Do I Remove Emoji and Special Characters Using Vim?
<p>I have a large text document 1Gig+ and I am trying to import the data into a MYSQL database. Now I go through the process and I receive the following Error</p>

<pre><code>OperationalError: (1366, "Incorrect string value: '\\xF0\\x9F\\x91\\xBD T...' for column 'copyright' at row 24")
</code></pre>

<p>Now from what I can gather this is an emoji that is present in the values. With the file size being so big I am using VIM to actually open the document for editing, the problem is however that when I search for the above values I can't find them anywhere in the text document.</p>

<p>Am I doing something wrong or is there a better approach?</p>

<p>Thanks</p>