Discussion Board for collaboration related to QlikView App Development.
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.
My Out put is Number columns is I want to see without symbols.
Thanks & Regards,
You can also use keepchar(Number,'0123456789')
View solution in original post
Add as many characters as you need as second criteria
You can use this function as well in the script:
Purgechar(....) as Number
How To /Missing Manual(18+ articles)
Use Purgechar() function,
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')).