topic How to remove smileys/emojis from a string? in Talend Studio

How to remove smileys/emojis from a string?

Anonymous — Sat, 16 Nov 2024 06:38:42 GMT

Hi All,

I have problem loading data from salesforce to mysql database. My data looks like below:

Data: Hey, Please can this one be updated our side? 😊

I have created a simple one-to-one mapping. Tsalesforce input and tdboutput.

I want to replace the smiley/emoji present in the string with a blank space. I am currently using tjavarow but it is not working. Any help on this will be really appreciated.

Re: How to remove smileys/emojis from a string?

Anonymous — Fri, 08 Feb 2019 09:45:26 GMT

Hi,

Please try below method.

You need to use the below value for context variable.

"[^\\p{L}\\p{M}\\p{N}\\p{P}\\p{Z}\\p{Cf}\\p{Cs}\\s]"

The function used in tMap is as below.

row1.input.replaceAll(context.characterfilter,"")

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: How to remove smileys/emojis from a string?

Anonymous — Mon, 11 Feb 2019 06:51:47 GMT

Hi @ikan

Could you please mark the topic as resolved since I have answered your query?

Marking a query promptly will help others in Talend community when they are looking solutions for similar queries.

It is also a way of telling thank you to the contributor for spending their time for your query in between their routine work.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: How to remove smileys/emojis from a string?

Anonymous — Tue, 12 Feb 2019 01:59:09 GMT

Hi Nikhil,

Thanks for your help.
But I still get error while loading data. All the smileys are not replaced.
Could you check my previous message and help please.

Re: How to remove smileys/emojis from a string?

Anonymous — Tue, 12 Feb 2019 02:05:37 GMT

Hi,

Could you please try below value to the context variable?

"[\\ud83c\\udc00-\\ud83c\\udfff]|[\\ud83d\\udc00-\\ud83d\\udfff]|[\\u2600-\\u27ff]"

Please refer the details in below link. You may have to add additional regular expressions based on your emoji if this is also not clearing the emoji.

https://stackoverflow.com/questions/44620294/removing-special-character-from-java-string

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂