topic Re: Restricting the subfield output in QlikView

Restricting the subfield output

Wed, 21 Aug 2013 03:50:32 GMT

Hi,

I have the following piece of data

Statement : I love singapore

Statement : An Apple.

Now I am using subfiled to split the string subfield(Statement,' ').

The output i am looking for is

love

Singapore

Apple

i.e., i want remove all the substrings whose length is less than 4.

Please provide your thoughts on how to implement this.

Regards,

Amar

khadeer — Wed, 21 Aug 2013 04:10:45 GMT

Hi,

if(len(subfield(Satatement,' ')>=4,subfield(Statement,' '))

Hope it helps you.

Regards,

Khadeer

Wed, 21 Aug 2013 05:26:59 GMT

Hi,

See the attachment.

tresB — Wed, 21 Aug 2013 05:48:53 GMT

try this:

Load

if(len(subfield(trim(Satement),' '))>=4,subfield(trim(Statement),' ')) as NewStatement

Thu, 22 Aug 2013 14:03:31 GMT

Hi Venugopal,

I am using a personal edition. Kindly post the script here

Fri, 23 Aug 2013 08:22:23 GMT

Hi,

TestData:
Load * Inline [
Statement
I love India
I love World
Community is Best
];

FieldList:
Load * where Len(vSubField) >= 4;

Load
SubField(Statement, ' ') as vSubField
Resident TestData;