Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to split

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

5 Replies
SunilChauhan
Champion II
Champion II

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

or

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

hope this helps

Sunil Chauhan
Not applicable
Author

Hi Sunil,

Thanks for reply.

But I want to Split only '5 Y'.

Please provide solution.

Regards

CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

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

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

Celambarasan

SunilChauhan
Champion II
Champion II

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

HOPE THIS HELPS

Sunil Chauhan
sivarajs
Specialist II
Specialist II

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