Get the second value of the current selection

[#1]

Hi All,

Does anyone know how to get the second value of the current selection?

For example I have a field Customer and currently the following customer have been selected:

1. John

2. Peter.

Does anyone know how to pick the second selection.

Thanks!

[robert_mika]

Try like this:

Textbetween(GetFieldSelections(Customer),',','')

[trdandamudi]

May be as below:

=SubField(GetFieldSelections(Customer),',',2)

[Anil_Babu_Samineni]

Thirumala,

If we select 3 Items from Selectors, Then the above expression shows still 2nd Value only

Do you mean this?

=SubField(GetFieldSelections(Customer),',',-1)

[Chanty4u]

No anil. for your expression its giving last selected value. small change in your expression

=SubField(GetFieldSelections(key),',',-2)

[Anonymous]

Hi ,

use following expression :

=SubField(GetFieldSelections(Customer),',',-1)