topic Re: How to remove symbols. in QlikView

How to remove symbols.

Srinivas — Fri, 10 Jul 2015 06:53:29 GMT

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

Re: How to remove symbols.

robert_mika — Fri, 10 Jul 2015 06:56:04 GMT

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)

Re: How to remove symbols.

Kushal_Chawda — Fri, 10 Jul 2015 07:15:06 GMT

Use Purgechar() function,

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

Re: How to remove symbols.

PrashantSangle — Fri, 10 Jul 2015 07:20:49 GMT

Hi,

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

Regards

Re: How to remove symbols.

Fri, 10 Jul 2015 10:20:03 GMT

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