how we can exclude emoji’s in people’s verbatim? | XM Community
Skip to main content
Question

how we can exclude emoji’s in people’s verbatim?

  • April 3, 2019
  • 3 replies
  • 56 views

how we can exclude emoji’s in people’s verbatim?

3 replies

YASH1T
QPN Level 2 ●●
Forum|alt.badge.img+6
  • QPN Level 2 ●●
  • April 22, 2019
@ankit, you can write a regular expression in a custom validation to restrics emojis. you can refer link below to get desired regular expression. https://www.regextester.com/106421

ThomasW_IronMountain
Level 5 ●●●●●
Forum|alt.badge.img+26

@ankit , Were you satisfied with the answer that was provided you on this? It’s been a few years, so you may have found a workaround already. If so, you can mark the answer as accepted, and close the question. If not, and you need more information, let me know. 


ArunDubey
QPN Level 8 ●●●●●●●●
Forum|alt.badge.img+41
  • QPN Level 8 ●●●●●●●●
  • May 24, 2023

If you want to restrict users to use emojis then please use regex. Refer this

https://stackoverflow.com/questions/50929396/regex-for-entering-letters-without-emojis

 

Or

 

if your data is already collected and you want to remove it from excel, then you will need to write macro you can refer below link .

https://superuser.com/questions/1259236/how-to-remove-all-emojis-from-excel