how to display selected two countries in same Listbox as concatenated string

[#1]

Hi

I am not getting how to display selected two countries in same Listbox as concatenated string.

i.e. for example..

Country listbox consisting following contry names..

India

UnitedStates

United Kingdome

Canada

France

I have been selected two countries (e.g : India , UnitedStates) in above Listbox then It will display like "IndiaUnitedStaes".

how can I get that result.

Please help me .

Thanks & regards :

seshukumar bandaru.

[rustyfishbones · Accepted solution]

this is not ideal but it works

=REPLACE(REPLACE(REPLACE(GetCurrentSelections(Country),',',''),' ',''),'Country:','')

[#3]

Thank you Alan Farrell I have solved my issue..

[rustyfishbones]

Great, but you should use Gysbert's solution

It's a much better solution

I am still learning, so I may do things the hard way, but as long as the result is correct

[Gysbert_Wassenaar]

This seems to work somewhat and isn't bothered by selections in other fields:

1. Create a variable vC as =concat(DISTINCT Country).

2. Use as expression for the listbox =if(GetSelectedCount(Country),vC,Country).

Unselecting isn't very nice though, requiring two clicks.

[#6]

great Gysbert Wassenaar & thanQ.. its working ..