Forum Engagement Daily Reports

[system]

Daily Forum Report | 09 October 2023

Top 3 Topics with Most Views

How to select multiple item from drop down made by @suraj_gaikwad with 47 views.

How to set properties inside Write Cell (Workbook activity) made by @D_Okthree with 43 views.

Get the exact large number from the excel file made by @Temuulen_Buyangerel with 42 views.

Top 3 Topics with Most Replies

How to compare the current date with the excel file column made by @lakshmi.mp with 34 replies.

Facing problem in extracting aadhar card using Document understanding made by @Jai_Pande with 24 replies.

How to select multiple item from drop down made by @suraj_gaikwad with 22 replies.

Top 3 Users Who Posted The Most

@lrtetala made 54 posts!

@Palaniyappan made 50 posts!

@Gokul001 made 39 posts!

Top 3 Most Liked Posts

This post made by @Melanie_Dunbeck received 2 likes!

Kelly - Automation Technical Resource Lead - Remote - United States - Full Time

Job title: Automation Technical Resource Lead Job role: RPA Lead Country: United States City: Remote Company name: Kelly Employment Type: Full Time Seniority level: Senior more than 5 years Job Description: We are seeking an experienced Automation Technical Resource Lead to join our team. As a member of Kelly’s Automation Enablement Center (AEC) team, the Automation Technical Resource Lead will be responsible for Technical Solution Design and managing a team of onshore and offshore autom…

This post made by @Palaniyappan received 2 likes!

Get the exact large number from the excel file

Hi There are two ways Either change the type of that column to Text in excel file itself and then try to update the data to it so that it doesn’t convert to this format Or if the file is getting generated dynamically and can’t be set as a template then you have again two options you can use single quote before to the value like this “ ‘ “+ yourvalue.ToString something like this for your reference [image] or you can use Balareva activity - a custom component from UiPath marketpla…

This post made by @supermanPunch received 2 likes!

Filter Excel on multiple criteria blank rows and keep rows containing specific values

@1a2bc346dgjk7544ebjkkbvf , Maybe we could generalise with a Regex Expression for all the conditions mentioned : OutputDT = DT.AsEnumerable.Where(Function(x)System.Text.RegularExpressions.Regex.IsMatch(x(0).ToString,"\b[A-Za-z]{1}\b|[A-Za-z]+[0-9]+|\d{2,}")).CopyToDatatable Here, DT is the Input datatable and OutputDT is the Output datatable. Could you try the above expression and let us know if it is working or not. Do try with different data and test it.

Top 3 Most Liked Solutions

This solution provided by @supermanPunch received 2 likes!

Filter Excel on multiple criteria blank rows and keep rows containing specific values

@1a2bc346dgjk7544ebjkkbvf , Maybe we could generalise with a Regex Expression for all the conditions mentioned : OutputDT = DT.AsEnumerable.Where(Function(x)System.Text.RegularExpressions.Regex.IsMatch(x(0).ToString,"\b[A-Za-z]{1}\b|[A-Za-z]+[0-9]+|\d{2,}")).CopyToDatatable Here, DT is the Input datatable and OutputDT is the Output datatable. Could you try the above expression and let us know if it is working or not. Do try with different data and test it.

This solution provided by @Gokul001 received 2 likes!

How to to kill remote desktop connection after completion of workflow

Hi @Suraj_Gaikwad_Nuvama_Grou Check out this thread Regards Gokul

This solution provided by @Yoichi received 1 likes!

Get the exact large number from the excel file

Hi, The following topic helps you. Regards,

---

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.