Solved

Remove i​:0#.f|membership| from beginning of created by value?

  • 31 March 2015
  • 1 reply
  • 22 views

Badge +8

i am using O365 and outputing the Created By value into Yammer. What is the best way to remove i​​:0#.f|membership| from the beginning of the Created By value? I want to do it using workflow actions, as opposed to going into the O365 settings and changing it there (if that can even be done). Can I use one of the sub-string actions? If so, which one and how do I configure it?

 

Thanks

Dean

icon

Best answer by deanvirag 1 April 2015, 03:02

View original

1 reply

Badge +8

I figured out myself. Since the extra characters are of fixed length, I used the Extract Substring from Start of string action and saved the value to a variable called ExcessText. I then used the Replace Substring in String action, using the ExcessText variable as the value in the Search String Field. The @ as the value in the Replace String, and the CurrentItem:CreatedBy value in the String field.

That will replace the 18 characters at the beginning of the Created By value with @.

Reply