Hi,
I have a SP2010 list with an Infopath form. On this form I have a people picker field which allows the user to enter multiple selections. I'd like to extract the username for each user from this field removing any of the domain information etc. So instead of Contoso\JoeBloggs I'd just have Joe Bloggs, but this needs to be done for each entry in the box, so
Contoso\JoeBloggs; Contoso\AnnOther; Contoso\WilliamGates
becomes
JoeBloggs; AnnOther; WilliamGates
Any idea how to make this work with formulas?
Thanks