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

Announcements
Join us in Bucharest on Sept 18th 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