topic Re: Reduce size in QlikView

Reduce size

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

hi How to reduce the size of the content

I jave a field by name Description Which has the below conetent

I want to show only one word

How do i write at the script ?

DIPHTHEROIDS-CORYNEBACTERIUM SPECIES

MORGANELLA MORGANII subsp. MORGANII

.and son

Re: Reduce size

Digvijay_Singh — Thu, 17 Mar 2016 13:12:55 GMT

May be Purgechar(String,'Characters to be removed should be here') can help

Re: Reduce size

avinashelite — Thu, 17 Mar 2016 13:15:45 GMT

can you have some more sample ??

if it always have the - has the separator ...then

subfield(fieldname,'-',1)

left(fieldname,10)

Re: Reduce size

kkkumar82 — Thu, 17 Mar 2016 13:16:42 GMT

May be

Subfield(Fieldname, '-')

Which will remove the text after the first '-'.

In your case it will return

DIPHTHEROIDS

Thanks

Kiran kumar

Re: Reduce size

smilingjohn — Thu, 17 Mar 2016 13:17:52 GMT

Hi digvijay

Ther are many charecter ,

How can i write all the things ?

I have around 10000 rows

Re: Reduce size

Digvijay_Singh — Thu, 17 Mar 2016 13:23:00 GMT

I think I misunderstood, If you want the first word like DIPHTHEROIDS having '-' always after that then use subfield as others rightly suggested.

Purgechar is used when you want to remove special characters or the characters you know you don't need. For example PurgeChar('ABCD123$#%$','123$#%$') will remove all non alphabetic chars.

Re: Reduce size

smilingjohn — Thu, 17 Mar 2016 13:24:34 GMT

Hi Kumar

I want to keep only first field and remove everything afte first word

Re: Reduce size

Clever_Anjos — Thu, 17 Mar 2016 13:32:21 GMT

Subfield(replace(yourfield,'-',' '),' ',1) would return first word splitted by ' ' or '-'

Re: Reduce size

awhitfield — Thu, 17 Mar 2016 13:32:23 GMT

Hi John,

something along these lines:

Data:
Load * Inline
[
Description
DIPHTHEROIDS-CORYNEBACTERIUM SPECIES MORGANELLA MORGANII subsp. MORGANII
];

Data01:
NoConcatenate
Load SubField(Description, ' ', 1) as Description
Resident Data;

Drop table Data;

HTH

Andy

Re: Reduce size

kkkumar82 — Thu, 17 Mar 2016 13:34:53 GMT

Hi,

You can use subfield here and if you still find '-' as part of the string, you can use trim, purgechar or replace to remove that character.

Thanks

Kiran Kumar