Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
sss1684971169
Contributor
Contributor

How to remove an emoji from a string?

My dataset has a column which has a name from a airbnb and that name has emojis and special characters. I want to remove them and let there only the letters. 

Labels (4)
1 Reply
Anonymous
Not applicable

Hi

Take a look at this article that shows different ways to remove emojis from a Java String. Using emoji library, regular expressions and Unicode ranges. For example, use regular expression on a tJavaRow:

output_row.text=input_row.replaceAll(context.regex, "");

 

//define a context variable which contains the regex expression: [^\\p{L}\\p{N}\\p{P}\\p{Z}]

 

 

Regards

Shong