Forum Engagement Daily Reports

[system]

Daily Forum Report | 12 April 2021

Top 3 Topics with Most Views

Add header in DT made by @Jesmine with 35 views.

Is studio have a robot? made by @halis with 32 views.

How to view specific folders in a directory made by @Serik_Tashenov with 30 views.

Top 3 Topics with Most Replies

How to view specific folders in a directory made by @Serik_Tashenov with 22 replies.

Is there any idea to append column in excel? made by @Ganesh_S1 with 19 replies.

Add header in DT made by @Jesmine with 13 replies.

Top 3 Users Who Posted The Most

@NIVED_NAMBIAR made 26 posts!

@prasath_S made 24 posts!

@Hiba_B made 20 posts!

Top 3 Most Liked Posts

This post made by @andres.perez received 3 likes!

Milestone 1 - Working with Decisions, Iterations and Scenarios

Hey! It seems the link to download the zip which contains the material for this practice is wrong. [image] You can copy them from the solution though! Have a nice week!

This post made by @kumar.varun2 received 2 likes!

Announcing the 2021 UiPath MVPs!

Congratulations to all.

This post made by @Zoul_BZ received 2 likes!

Milestone 1 - Working with Decisions, Iterations and Scenarios

Hi! Echoing andres, the zip file is the same as Week 1 practice.

Top 3 Most Liked Solutions

This solution provided by @anotherulrich received 2 likes!

Connection with UiPath Excel-Add-In keeps failing

I followed this: Excel Plugin Not Getting Installed - #3 by AndrewHall and this solved the issue. Nothing to do with Admin rights… Regards, Ulrich

This solution provided by @NIVED_NAMBIAR received 1 likes!

Remove particular Data columns by using Wildcards

Hi @he.cao u can try this way Read the excel file and store in dt1 now use below assign activity to get only column name starting with Column- data_array = (From dc In dt.Columns.Cast(Of DataColumn) Where dc.ColumnName.StartsWith(“Column-”) Select dc.ColumnName).ToArray() Now use for each loop to loop through each element in data_array [ datatype of data_array is String ] Iniside the loop use Remove Data Column Activity to remove the column from the datacolumn by specifying the name of c…

This solution provided by @Yoichi received 1 likes!

How to read string regardless of Uppercase, Lowercase or mixed using Regex

Hi, Can you try System.Text.RegularExpressions.RegexOptions.IgnoreCase option as the following? System.Text.RegularExpressions.Regex.Match(strVar,"(?<=(Person Address)).*",System.Text.RegularExpressions.RegexOptions.IgnoreCase).Value 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.