Forum Engagement Daily Reports

[system]

Daily Forum Report | 13 July 2023

Top 3 Topics with Most Views

Authentication failed because the remote party sent a TLS alert: ‘DecodeError’ made by @shreyash_shirbhate with 48 views.

Finding Index of Duplicate Entries using linq query made by @yash.choursia with 47 views.

Get the total count of files and paste that in excel made by @Priyesh_Shetty1 with 47 views.

Top 3 Topics with Most Replies

How can i run studio's scripts using Studio X made by @rania.mohamed1 with 37 replies.

Illegal Path Error made by @marina.dutta with 30 replies.

Get the total count of files and paste that in excel made by @Priyesh_Shetty1 with 27 replies.

Top 3 Users Who Posted The Most

@supriya117 made 57 posts!

@raja.arslankhan made 52 posts!

@Anil_G made 51 posts!

Top 3 Most Liked Posts

This post made by @supriya117 received 2 likes!

How to check whether the string in datatable is completely included?

Hi @Bosch If you want to check whether the person name present in the datatable or not then you can use this linq query. nameExists = dataTable.AsEnumerable().Any(Function(row) row.Field(Of String)("Name") = personName) Here personName is a string variable contains the person name.

This post made by @pravallikapaluri received 1 likes!

Line break

Hi @DimitriLYR Use Trim function In the Place of Fruits give Columnname CurrentRow(“Fruits”).ToString.Trim [image] Hope it helps!!

This post made by @postwick received 1 likes!

Comparison between String and Dictionary's Key Value

This needs to be CDbl(dictVar(“No1”).ToString) And they don’t want to compare No1 to No2. They want to see if the value 5 is in the dictionary.

Top 3 Most Liked Solutions

This solution provided by @raja.arslankhan received 1 likes!

How to pass Multiple Values to Attributes of Element Exists Activity

@Bhavesh_Batra Documentation: https://docs.uipath.com/studio/standalone/2023.4/user-guide/regex-search With one element exist approach is not reliable in case of two different selectors. I prefer solve it through regex selector and use one element exist.

This solution provided by @drbuddepu received 1 likes!

Cannot indicate the Extract Table Data Activity

@170290064 Extend the target in properties and copy the whole strict selectors. Open the fuzzy selectors and clear the selectors and paste the strict selectors and hit on save. In targeting method uncheck the strict selector and check the fuzzy selectors and save the program. [MicrosoftTeams-image] Hope it helps!!

This solution provided by @supermanPunch received 1 likes!

How to check whether the string in datatable is completely included?

Hi @Bosch , From the data available and results mentioned, we can understand that if all the words in the name are present in the Datatable column values, then it is an acceptable case. Hence, we can first split the Name with Space, so we get the array of words. Then we check if all the words are present in the column cell and then mark the result accordingly. Splitting of the word to an Array : wordsInNameArray = Split(Name).ToArray Here, wordsInNameArray is a variable of type Array of S…

---

That’s it for now, see you tomorrow for a new report!

Don’t forget to share ideas for other fun stuff we should add to the reports here.