How to display GetFieldSelections only upto the previous selection ?

[umartareen]

Hi,

I have a scenario where I need to get the field selections only up to the previous selection.

Example: As seen in the image below, upon selecting the employee names, Ben, Hill, John and Lou, my expression has to display only Ben, Hill and John and not Lou.

Similarly, If we select Ben, Hill, John, Lou and Maria, my output has to be this : Ben, Hill, John, Lou

How can this be achieved ? Any help will be much appreciated.

PFA of the Test Application.

Thanks,

Umar

[Anonymous]

Replace(GetFieldselections(FieldName,', '), ', '& SubField(GetFieldSelections(FieldName,', '),', ',-1),'')

[umartareen]

Hi I am having an issue with this again. No matter what I try, the values are appearing from the opposite side, ie the opposite sort order.

Example, Instead of bring Stu, Maria, Lou, I am getting Lou Maria and Stu

Please help !

Thanks

Umar

[umartareen]

Or Rather,

The values are are being displayed ascending order wise in my text object !

The requirement is to have them in original sort order !

Regards,

Umar