Help needed with keepchar()

[venkatg6759]

Hello Everyone,

I have the following expression

left(keepchar(if([Research - US Shares ()]&','&[Overall - US Shares ()]&','&[Research - All Products ()]&','&[Overall - All Products ()]<>',,,',[Research - US Shares ()]&','&[Overall - US Shares ()]&','&[Research - All Products ()]&','&[Overall - All Products ()]),'0123456789'),1).

Which gives me results like as shown

I need the highlighted cell to show result as 11

[venkatg6759]

if it is 1 or 2 it should be displayed as 1 ,if tier 2 it should be 2 . if top 10 it should be 10.

[preminqlik]

Hi there please find attachement

=if(len(subfield(trim(keepchar(rtrim(ltrim(replace([EMEA & Asia logic],',',' '))),' 0123456789')),' ',1))>0,subfield(trim(keepchar(rtrim(ltrim(replace([EMEA & Asia logic],',',' '))),' 0123456789')),' ',1),

trim(keepchar(rtrim(ltrim(replace([EMEA & Asia logic],',',' '))),' 0123456789')))