Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
subfield('5Y,10M',','1)
or
left('5Y,10M',2)
hope this helps
Hi Sunil,
Thanks for reply.
But I want to Split only '5 Y'.
Please provide solution.
Regards
Hi,
Did you tried with subField('5 Y, 10 M',',',1)?
or you need to split again '5 Y' as 5,Y?
Celambarasan
LEFT('5 Y, 10 M',1) &','& mID('5 Y, 10 M',2,1)
HOPE THIS HELPS
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