First value in expression

[venkatg6759]

Hi All,

I have an expression like ,,7    in which i need result in another expression like 7

IF expression has something like   ,Top3,1,        Result should be   3

All the values in the expression are separated by commas, I need first sorted value among those.

,,7  this value is coming from an expression which is combination of fields separated by comma.

Help me how to achieve this logic .

Thanks,

Venkata

[MK_QSL]

Can you provide some more information.

It is very difficult to understand from you question.

It's looks confusing...

[venkatg6759]

I have an expression

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 ()])

which is giving   results such as ,,,7       

                                              Top 3,,2

I Need another expression in which result should be  7

                                                                             3

[MK_QSL]

Don't understand at all.

Can you share sample file or apps?

[venkatg6759]

@

[MK_QSL]

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)

[venkatg6759]

Thank you Manish .This is helpful if suppose there is something like Tier2,,, 

Result should be named as 5 .

Only for this scenerio

[MK_QSL]

IF(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 ()]),'Tier2'),5)='Tier2',5,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))

[venkatg6759]

Hi Manish,

If there is TOP10, it is displaying 1 instead of 10 .Any suggestion.

[venkatg6759]

Can Anyone help me how can i get the first number from the expression .

I tried the expression below.

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)

But if i have numbers like TOP 10, it is displaying 1 instead of 10 .

Thanks in Advance,

Venkata