Forum management
- Threads started by me
- Threads I participate in

Developer forum

Delete part of text in NewsV2 via SQL

Hans Ravnsfjall

Posted on 28/09/2015 18:06:26

I have tried to export News from the Data Integration, but it appears that it gives an error because the column NewsText in the table News, contains smileys (i cant make the same smiley in here, as it is a smiley that comes from word)

Anyhow, can i just clean up all the news - and just delete the Smileys, without deleting anything else by firing this SQL in SQL FireHose?

Update News set NewsText=REPLACE(NewsText,'','')

regards Hans

Replies

Jonas Krarup Dam

Posted on 02/11/2015 09:09:25

Hi Hans,

Hmm, sounds strange - I'd prefer if the data integration didn't break on smilies...

I don't see any problems with your plan (unless the smileys are important, in which case, I guess it would count as data loss).

if possible, I would like to get a copy of your database, so that I can recreate the problem, and hopefully fix it.

Regards, Jonas

You must be logged in to post in the forum