QVX_UNEXPECTED_END_OF_DATA if a string contains emojis

[nikolaus]

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

[Chanty4u]

Not sure but you can give a try 

LOAD

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

    *

;