Skip to main content
Nintex Community Menu Bar
Answer

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

  • March 31, 2015
  • 1 reply
  • 72 views

Forum|alt.badge.img+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

Best answer by deanvirag

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 @.

1 reply

Forum|alt.badge.img+8
  • Author
  • Answer
  • April 1, 2015

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 @.