How to merge team member name as one in List Box

[#1]

Hi,

I have Team member with same name as Micheal Sunie and Micheal Sunie MFR in List box. My user wnats to have only Micheal Sunie MFR in List box.

Could anyone help me is there any way to merge theses two and have only Micheal Sunie MFR.

Thanks.

[vikasmahajan]

Please upload sample application to help you in better way

[#3]

Hi,

If this is an issue with single name, you can use simple if condition in script as,

If( Team member = 'Micheal Sunie' , 'Micheal Sunie MFR' ,  Team member) as  Team member

U can use this in list box expression too.

If( Team member = 'Micheal Sunie' , 'Micheal Sunie MFR' ,  Team member)

Hope this helps.

[rustyfishbones · Accepted solution]

try using REPLACE() in the script

REPLACE(Team Member,'Michael Sunie','Michael Sunie MRF') as Team Member

[bruno_m_santos]

Build an expression, like this

=mid (field, 1, len(field)-3)

or put in script another field

Bruno

[#6]

Thanks and this is working.

[kiranmanoharrode]

Dear Amelia,

               Just create Expression in list box (last Dimension in list of Dimension).

=If(Wildmatch([Team Member],'Michael Sunie MRF')),[Team Member]

Regards

Kiran Rode

+8976977897