Hi All, I have a string variable , with multiple lines (each value within a separate line). I got this variable value by appending multiple values within a for loop. In the screenshot below you can see that certain values are repeated eg. “Director Data Quality”. What method can I use to keep only t…

[image] lakshman: yourString.Split(Environment.NewLine.TocharArray).Distinct().Toarray() @lakshman Thanks a lot worked perfectly, could you also suggest on how I can now write this value to a particular cell within a data table ?

@Ashish_Mehra You want to write single value or whole Array into String.

So I wrote the whole array with distinct values into a string by using Strin.join(vbLF,arrayvariable) , now I have all the values I needed separated by line breaks, now I want to write this particular variable value into a cell in a data table I have built

@Ashish_Mehra If you want to write into particular cell then use Write Cell Activity and pass that String to write into Excel file.

How to remove duplicate values within a string variable

Help

lakshman (Ganta lakshman) November 18, 2019, 6:31pm 2

@Ashish_Mehra

Try this.

           yourString.Split(Environment.NewLine.TocharArray).Distinct().Toarray()

1 Like

How to count duplicate strings in an array

Topic		Replies	Views
Duplicate column value Activities excel	11	422	August 5, 2023
Distinct values from a string Activities uiautomation , studio , question	6	167	May 12, 2024
How to store value of string variable into array (In a for each row) Help	10	5958	April 27, 2019
How can I remove duplicates in one string? Studio studio , question , activities_panel	4	1413	August 29, 2022
How to keep unique values in list Activities excel , activities , question	5	105	October 17, 2024

How to remove duplicate values within a string variable

Related topics