QVX_UNEXPECTED_END_OF_DATA if a string contains emojis

nikolaus — Mon, 20 Oct 2025 06:06:42 GMT

Hello,

I am reading data from an ERP system and one table contains mails with subject, sender and other fields.

Now I get a few mails where creative advertising guys send emojis as part of the subject. Like this:

Jetzt von den vielen Vorteilen von OnFarming profitieren! 🌾🐮🚜

So far I identified the senders and excluded them.When I run the same query in an SQL tool it works fine.

Is there a better way to replace or remove emojies from a query?

Thanks

Niko

Re: QVX_UNEXPECTED_END_OF_DATA if a string contains emojis

Chanty4u — Thu, 27 Nov 2025 18:27:36 GMT

Not sure but you can give a try

LOAD

PurgeChar(subject, '😀😁😂🤣😃😄😅😆😉😊…') as subject_clean,

;