How to remove symbols.

[Srinivas]

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.
 

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

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

Thanks & Regards,

Minna

[robert_mika]

Use PurgeChar:

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

Add as many characters as you need as second criteria

You can use this function as well in the script:

Purgechar(....) as Number

Feeling Qlikngry?

How To /Missing Manual(18+ articles)

[Kushal_Chawda]

Use Purgechar() function,

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

[PrashantSangle · Accepted solution]

Hi,

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

Regards

[#5]

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