topic How to split in QlikView

How to split

Wed, 21 Mar 2012 06:09:51 GMT

Hello friends,

Can Any one help me to split

'5 Y, 10 M'

I want only Split

this data '5 Y'

Please help me .

Regards

Ravi Gupta

9555965950

SunilChauhan — Wed, 21 Mar 2012 06:16:05 GMT

subfield('5Y,10M',','1)

left('5Y,10M',2)

hope this helps

Wed, 21 Mar 2012 06:30:36 GMT

Hi Sunil,

Thanks for reply.

But I want to Split only '5 Y'.

Please provide solution.

Regards

CELAMBARASAN — Wed, 21 Mar 2012 06:36:06 GMT

Hi,

Did you tried with subField('5 Y, 10 M',',',1)?

or you need to split again '5 Y' as 5,Y?

Celambarasan

SunilChauhan — Wed, 21 Mar 2012 06:41:25 GMT

LEFT('5 Y, 10 M',1) &','& mID('5 Y, 10 M',2,1)

HOPE THIS HELPS

sivarajs — Wed, 21 Mar 2012 09:30:49 GMT

Hi,

I guess following will work

subfield(subfield('5 Y,10 M',',',1),' ',1) ) gives 5

subfield(subfield('5 Y,10 M',',',1),' ',2) ) gives Y

Regards,

Sivaraj S