locked
Use Trim within a workflow RRS feed

  • Question

  • In my Dev MIM setup I have an HR feed that supplies email but not mailnickname. I cant use First and last to build the mailnickname because it will not match the email coming from HR, plus the first and last have their own issues. So I want to use email in the workflow trim of the "@companyname" and use the result to populate mailnickname.

    Trim([//Target/Email], "@company.com")

    [//Target/MailNickname]+[//UniquenessKey]

    Will that work? Not working for me. Any help would be great!!

    Mike

    Wednesday, February 8, 2017 7:25 PM

Answers

  • Trim (or even TrimEnd) will not be predictable as it will not just trim @company.com, but any additional  leading and trailing chars. e.g. penny@company.com will be just "e" with Trim and "pe" with TrimEnd.

    You can use First on SplitString function with "@" as the separator to get the mail suffix.

    Wednesday, February 8, 2017 9:24 PM