Forum Engagement Daily Reports

[system]

Daily Forum Report | 28 February 2022

Top 3 Topics with Most Views

Dynamic download path settings made by @sanjay_gowda with 70 views.

Passing argument to start a job made by @Vicky_Fegan1 with 63 views.

I need to split pdf into multiple pdfs. i had no page numbers in it.Based on the text i need to split into multiple pdfs.can any one help?I had extracted pdf data and tyring to split by regex made by @MitheshBolla with 55 views.

Top 3 Topics with Most Replies

I need to split pdf into multiple pdfs. i had no page numbers in it.Based on the text i need to split into multiple pdfs.can any one help?I had extracted pdf data and tyring to split by regex made by @MitheshBolla with 24 replies.

Uipath in Search speed in automated Web search automation made by @A_Zyzz_Man with 21 replies.

Filter outlook mail made by @TUSHAR_DIWASE with 19 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 32 posts!

@Nithinkrishna made 29 posts!

@nikhil.girish made 20 posts!

Top 3 Most Liked Posts

This post made by @AndyMenon received 3 likes!

UiPath Community MVP 2022 announcement!

I’m no memer, but I’m going to take the meme idea presented by @PD2 and give it a shot here “at home” These pics are from the beautiful desert sands of Hatta, UAE . I managed to jog up and down a few sand dunes pretty far off into the horizon and away from where our safari vehicle stopped. The wife although was mad at me for scooting off agreed to shoot some pictures of me as i made my way back to the base camp. Feels a lot like how some (or many of us) started with our UiPath RPA journ…

This post made by @Yoichi received 3 likes!

How to get Saturday's and Sunday's of whole year

Hi, FYI, another solution: arrayDateTime = Enumerable.Range(0,365-CInt(DateTime.IsLeapYear(Today.Year))).Select(Function(i) New DateTime(Today.Year,1,1).AddDays(i)).Where(Function(d) d.DayOfWeek=DayOfWeek.Sunday OrElse d.DayOfWeek=DayOfWeek.Saturday).ToArray() Regards,

This post made by @RPAForEveryone received 3 likes!

Todays date is given in 3 column want complete date in 4th column which activity I can use for it

Hi @satish.rathi59 Welcome to the UiPath Community! You can use DateTime.ParseExact method to achieve this. Assign DateString = A1 + "/" + B1 + "/" + C1 (append the first three columns together) Assign MyDate = DateTime.ParseExact(DateString, "dd/MM/yyyy", CultureInfo.InvariantCulture) You may choose not to add the / character, I added it for clarity/aesthetics. Whichever date format you prefer, make sure to use that in the second argument of ParseExact. For example, if you pass DateStrin…

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 3 likes!

How to get Saturday's and Sunday's of whole year

Hi, FYI, another solution: arrayDateTime = Enumerable.Range(0,365-CInt(DateTime.IsLeapYear(Today.Year))).Select(Function(i) New DateTime(Today.Year,1,1).AddDays(i)).Where(Function(d) d.DayOfWeek=DayOfWeek.Sunday OrElse d.DayOfWeek=DayOfWeek.Saturday).ToArray() Regards,

This solution provided by @Gokul001 received 3 likes!

How to get the last row count of specified column?

HI @Alvin_Apostol2 You can try as @lakshman suggested and also you can try this methods Method 1 Use Read Range and store in a variable For each row in datatable and loop through the column Inside keep if activity and give condition as Row(“Status”).Equals(“”) Then you can process your task Else keep empty it will go to next row Method 2 Use Read Range and store in a variable Use Lookup Datatable and give lookup value as “” in column status and get the row index from there. Do you…

This solution provided by @Yoichi received 2 likes!

I want to remove columns with blanks and certain characters in my data table

Hi, Your code seems remove rows… Anyway, can you try the following expression? BBBB = AAAAA.AsEnumerable.Where(Function(x) Not (String.IsNullOrEmpty(x("Jan").ToString) OrElse x("Jan").ToString.Contains("KEYWORD"))).CopyToDataTable() Regards,

[Previous Month] Top 3 Users with the most likes on their solutions

@Gokul001 received 95 likes for their solutions!

@Yoichi received 59 likes for their solutions!

@Nithinkrishna received 34 likes for their solutions!

---

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.