Discussion Board for collaboration related to QlikView App Development.
I have a Customer of a similar value - 'Crazy Customer 307300 A90000', but I'd like to only show/return :
'Crazy Customer'..... So basically anything that is in my other Customer Table, with no numbers/characters following.
Any ideas on how I could achieve this.?
use mid funtion.
mid( Date,3,2 ) where Date = 970714 returns 07.
Use below script.
Load purgechar(Field_Name,'1234567890') as New_Field from xyz.
This script will remove the numbers from your field value.
If you need anything else to be purge then you can include that also into the script.
=Trim(KeepChar(DimensionName, 'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz '))
Hope this helps you.
thanks a lot, it was so helpful