Forum Engagement Daily Reports

[system]

Daily Forum Report | 10 February 2024

Top 3 Topics with Most Views

How to replace the blanks in a particular range made by @anjani_priya with 34 views.

Help Needed: SQL Query Against Excel with Special Characters in Column Names made by @TonyO with 33 views.

Javascript - select tag with specific criteria made by @bs113256 with 26 views.

Top 3 Topics with Most Replies

How to replace the blanks in a particular range made by @anjani_priya with 21 replies.

How to replace some values with other in multiple sheets at a time made by @anjani_priya with 8 replies.

Connecting uipath to Google Bigquery made by @3175472466 with 5 replies.

Top 3 Users Who Posted The Most

@Anil_G made 28 posts!

@anjani_priya made 16 posts!

@mkankatala made 10 posts!

Top 3 Most Liked Posts

This post made by @mikemanand received 1 likes!

Python Scope activity requires you to install the .NET Desktop Runtime 5.0.17

Hi @loginerror When we should expect this? Isn’t it possible to upgrade to .NET 8? I think that is the current latest version.

This post made by @AndyMenon received 1 likes!

Forms Designer - Columns Component: Styling renders items nearly invisible for Dark themes

Excellent! Thank You, Man from the Future!

This post made by @Hector1 received 1 likes!

Table extraction wizard doesn't fit with the Tables Pattern I need to scrap

It was usefull. It helped me to solve my asssign. Thank You!

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 1 likes!

Read cell with numeric value in Excel

@E.T.S you can use preserve format …ideally it reads the backend value…may be your excel cell is formatted to display as currency as said change variable to genericvalue and use preserve format cheers

This solution provided by @mkankatala received 1 likes!

How can i get and seperate this text in 3 different variables from a website?

Hi @170290064 First, use the Get text activity to extract the data and store in a Variable called Input_Str. - Assign -> ClientID [String Datatype] = System.Text.RegularExpressions.regex.Match(Input_Str.toString,"(?<=Client ID:\s+).*").Value - Assign -> ClientName [String Datatype] = System.Text.RegularExpressions.regex.Match(Input_Str.toString,"(?<=Client Name:\s+).*").Value - Assign -> ClientCountry [String Datatype] = System.Text.RegularExpressions.regex.Match(Input_Str.toString,"(?<=Clie…

This solution provided by @Anil_G received 1 likes!

Doubt in pdf automation selectors

@anjani_priya Should get ocr text activity with try cacth…by placing it in try block…and in catch block add a exception…so that when ever there is a empty string the exception is caught and we can move to next file Cheers

---

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.