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: 
Not applicable

String help

Hi,

I have scenario pls help

how to remove special characters in below string.

1234@5678#9$10

I tried with subfield function.but didn't work 

Any suggestions?

2 Replies
MK_QSL
MVP
MVP

KeepChar(YourString,'0123456789') as YourString

or

=KeepChar('1234@5678#9$10','0123456789')

Kushal_Chawda

or

Purgechar(Field,'!~@#$%^&*') as NewField

Note: Include all special characters which you want to remove