none
displayName from Workflow with IIF RRS feed

  • Question

  • Target Value:   [//Target/DisplayName]

    Conflict Filter:  /Person[DisplayName='[//Value]' and not (ObjectID='[//Target/ObjectID]')]

    ProperCase(RegexReplace([//Target/FirstName],"[^A-Za-z0-9]",""))+" "+ProperCase(RegexReplace([//Target/LastName],"[^A-Za-Z0-9]",""))+" CTR"

    Now before just a tie breaker can a Middle Initial be entered via an IIF so a null will be if there is no MI ?

    Friday, July 25, 2014 9:25 PM

Answers

  • Some things are simple ... just have to let those happen

    Added another IIF to get a space after the MI only if present

    IIF(IsPresent([//Target/MiddleName]," ","")

    So if present add a space if not null

    Now all Display Names are unique and look correct to humans eyes not just machines.

    This thread is done.  Thanks to our expert pool who participated in e-mail exchanges.

    • Marked as answer by swaindn72 Tuesday, July 29, 2014 7:10 PM
    Tuesday, July 29, 2014 7:10 PM

All replies

  • This works to get an IFF with MI from MiddleName

    IIF(IsPresent([//Target/MiddleName]),upperCase(Left(Trim([//Target/Middlename]),1),"")

    Next requirement is to add a space after the MI before the last name but only if required.

    Do not want a double space between FN and LN if no MI is present as this will seem unique but only due to the extra space character.

    Tuesday, July 29, 2014 4:55 PM
  • Some things are simple ... just have to let those happen

    Added another IIF to get a space after the MI only if present

    IIF(IsPresent([//Target/MiddleName]," ","")

    So if present add a space if not null

    Now all Display Names are unique and look correct to humans eyes not just machines.

    This thread is done.  Thanks to our expert pool who participated in e-mail exchanges.

    • Marked as answer by swaindn72 Tuesday, July 29, 2014 7:10 PM
    Tuesday, July 29, 2014 7:10 PM