topic Re: Trim string value in QlikView

Trim string value

Thu, 21 Mar 2013 11:07:43 GMT

Hi all,

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.?

Thanks

sushil353 — Thu, 21 Mar 2013 11:11:35 GMT

use mid funtion.

mid( Date,3,2 ) where Date = 970714 returns 07.

HTH

Sushil

kaushiknsolanki — Thu, 21 Mar 2013 11:14:17 GMT

Hi,

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.

Regards,

Kaushik Solanki

jagan — Thu, 21 Mar 2013 11:37:29 GMT

Hi,

Try this

=Trim(KeepChar(DimensionName, 'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz '))

Hope this helps you.

Regards,

Jagan.

Anonymous — Thu, 30 Jun 2016 10:43:35 GMT

thanks a lot, it was so helpful