removing emoji from an xml file

alepage — Wed, 03 Jul 2024 18:56:37 GMT

Hello, I have an xml file which contains emoji and I looking for a Unix or a SAS solution the remove those from the original xml file before making any treatment on it.

Does someone already works on that topic.

Regards

Re: removing emoji from an xml file

Tom — Thu, 04 Jul 2024 00:02:31 GMT

@alepage wrote:

Hello, I have an xml file which contains emoji and I looking for a Unix or a SAS solution the remove those from the original xml file before making any treatment on it.

Does someone already works on that topic.

Regards

Exactly what character is it? What is the hexcode?

For example is it a smiley face?

data test;
  emoji = 'F09F988A'x ;
run;

proc print;
run;

Once you know what character you are looking for try reading through the file and changing it to something else.

data _null_;
  infile 'bad.xml';
  file 'good.xml';
  input;
  _infile_ = tranwrd('F09F988A'x,':)');
  put _infile_;
run;

Note if any of the lines in the XML are longer than 32K bytes then the code to find and replace the "emoji" character(s) will need to be more complicated.

topic removing emoji from an xml file in SAS Enterprise Guide

removing emoji from an xml file

Re: removing emoji from an xml file