Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

How to remove symbols.

Hi All,

In my database one columns contains unwanted symbols those i want to remove,So how can I remove could you please help on this.

My data like below way.
 

NumberNames
@1234Sirisha
@#1235swetha
#@$1236metha
@%$1237neha
&^@1238akshu
@#1239akira
#%1240ujala
?@#1241gopala
!?|1242vasthava
&*#@1243krishna

My Out put is Number columns is I want to see without symbols.

Thanks & Regards,

Minna

Thanks,
Srinivas
1 Solution

Accepted Solutions
Highlighted

Hi,

You can also use keepchar(Number,'0123456789')

Regards

Great dreamer's dreams never fulfilled, they are always transcended.

View solution in original post

4 Replies
Highlighted

Use PurgeChar:

=PurgeChar('#@$1236','@&$~#^@')

Add as many characters as you need as second criteria

10-Jul-15 7-56-16 AM.jpg

You can use this function as well in the script:

Purgechar(....) as Number

Feeling Qlikngry?

How To /Missing Manual(18+ articles)

Highlighted
MVP
MVP

Use Purgechar() function,

Purgechar(Number ,'@!#$%^&*()_+-=:"{}|?/')

Highlighted

Hi,

You can also use keepchar(Number,'0123456789')

Regards

Great dreamer's dreams never fulfilled, they are always transcended.

View solution in original post

Highlighted
Not applicable

As dreamer4‌ mentioned, If you need only numbers from the column and populate that as a number in QlikView, then use Num(keepchar(Number,'0123456789')).

Regards,

KKR