AnsweredAssumed Answered

Delete a certain part of a string variable and filter duplicated data

Question asked by rogelio.tan on Mar 26, 2017
Latest reply on Mar 29, 2017 by rogelio.tan

Hi everyone,

 

Question 1:

I have this problem that when I store a data in a variable there is a extra letters that I want to delete for example if I use a default string as an output it will show this:

 

i:0#.w|emrsn\rogelio.tan

 

and when I use display name as an output it will show

Tan, Rogelio [CORP/PH]

 

what I want to happen is either delete the i:0#.w|emrsn or [CORP/PH]

 

Also, I'm using a People/Group variable.

 

Question 2:

 

Those People/Group mention above will be stored in a build string action and is there a way to filter those variable because if there is a duplicate of name I don't want it to be stored in the string so every name stored in the string will be unique and no duplication occurs is there a way to do this?

 

The current result of my workflow is like this: Tan, Rogelio [CORP/PH], Tan, Rogelio [CORP/PH], Buena, Melissa [CORP/PH], DL CORP EOC.

 

My desired result is like this Tan, Rogelio [CORP/PH], Buena, Melissa [CORP/PH], DL CORP EOC.

 

The reason why there is a duplication because several items has the same Owner and I loop through all the items created that's why when I store the value in the string it will go through each item and store all the Owner of the items.

Outcomes