How to split

[#1]

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]

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

or

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

hope this helps

[#3]

Hi Sunil,

Thanks for reply.

But I want to Split only '5 Y'.

Please provide solution.

Regards

[CELAMBARASAN]

Hi,

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

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

Celambarasan

[SunilChauhan]

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

HOPE THIS HELPS

[sivarajs]

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