I’ve tried a few approaches including converting Array to List and Invoke Method - Remove, but I have been unable to generate the results I’m looking for.
Array data:
{Mr. Elmo Smith, Engineering Supervisor;
Ms. Lamb Chop, Production Systems
Manager;
Mrs. Big Bird, Building Manager;
Barney Rubble, HMD Global}
1 - Mr. Elmo Smith, Engineering Supervisor;
2 - Ms. Lamb Chop, Production Systems
Manager;
3 - Mrs. Big Bird, Building Manager
4 - Barney Rubble, HMD Global
Goal:
If an index contains HMD Global - remove it from list/array
Split remaining elements to First and Last Name only
Convert to Last, First to search AD
@RR2 If you do
for each and check and try to delete a record then the Indexing of the Collection is being Altered, you need to filter the list based on your condition but not to delete it, This approach is very much easier if you have it in a table.
Use The Contains Method in .Net for your list or array and filter it out.
Hi
Hope these steps would help you resolve this
—let’s say we have the array stored in a variable named arr_value
—now use a assign activity like this str_arrayvalue = String.Join(“”,arr_value).ToString
Where str_arrayvalue is a variable of type string
—now use a assign activity like this arr_final = Split(str_arrayvalue,”;”)
Where arr_final is a variable of type array of string
—now use a FOR EACH activity where pass the arr_final variable as input
— inside the loop use a IF condition like this Not item.ToString.Contains(“HMD Global”)