Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
You can also use keepchar(Number,'0123456789')
Regards
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?
Use Purgechar() function,
Purgechar(Number ,'@!#$%^&*()_+-=:"{}|?/')
Hi,
You can also use keepchar(Number,'0123456789')
Regards
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