Replacing PIPE (|) symbol in hive
<p>Hello i have a text containing pipe (|) symbol and i want to replace it with space. This is the text in the column description</p>

<blockquote>
  <p>|TrueCricketLover|M€$$!|
  PTI|Capricorn|No DM|#TeamIK|@shaneRWatson33 ❤
  Boom Boom❤
  Striving to be a better human!</p>
</blockquote>

<p>I have tried the regexp_replace function like this</p>

<pre><code>regexp_replace(description,'|',' ')
</code></pre>

<p>This command returns this value</p>

<blockquote>
  <p>| T r u e C r i c k e t L o v e r | M € $ $ ! | 
   P T I | C a p r i c o r n | N o   D M | # T e a m I K | @ s h a n e R W a t s o n 3 3   ❤ 
   B o o m   B o o m ❤ 
   S t r i v i n g   t o   b e   a   b e t t e r   h u m a n ! 
   L o v e   h i m   w h o   l e a s t   D e s e r v e s   I t , T h a t ' s   i t ❤ </p>
</blockquote>

<p>It is not replacing the pipe (|) symbol. Kindly help.</p>