Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Trim string value

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

4 Replies
sushil353
Master II
Master II

use mid funtion.

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

HTH

Sushil

kaushiknsolanki
MVP & Luminary
MVP & Luminary

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

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
jagan
MVP & Luminary
MVP & Luminary

Hi,

Try this

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

Hope this helps you.

Regards,

Jagan.

niushahabib
Contributor
Contributor

thanks a lot, it was so helpful