Forum Engagement Daily Reports

[system]

Daily Forum Report | 22 June 2022

Top 3 Topics with Most Views

How to replace particular row items from same excel? made by @Muralikrishna_Surve with 36 views.

Write range into excel don't write all the data made by @nora_ziani with 33 views.

The Process cannot access the file because its being used by another process "pdf" file made by @Sairam_RPA with 33 views.

Top 3 Topics with Most Replies

How do I make sure that the convert to pdf don't have a. Docx made by @charlotte_charlotte with 17 replies.

For each row create file made by @mateo.drouillard with 16 replies.

Scraping PDF footer Page Number made by @anand.t with 13 replies.

Top 3 Users Who Posted The Most

@Rahul_Unnikrishnan made 33 posts!

@THIRU_NANI made 26 posts!

@Nithinkrishna made 23 posts!

Top 3 Most Liked Posts

This post made by @Maneesha_de_silva received 7 likes!

Happy Anniversary UiPath Learner, Virtual Party!

:smiling_face_with_three_hearts:Happy Anniversary celebrate **5 years of UiPath Academy! Instead of 5 years I have very happy and proud to be with 4 years continually with UiPath academy. I was started with Zero and when i look back my achievement its almost the academy that help me to become on this position. UiPath Academy helps you to become form ZERO to HERO THE PERSON WHO HAVE THIRST WITH KNOWLEDGE AND LERNING , I recommended that this is the heaven for …

This post made by @AndyMenon received 3 likes!

Happy Anniversary UiPath Learner, Virtual Party!

FUN-FIVE-YEAR-TASTIC! Congratulations to one and all! The creators, the organizers, the moderators, the visitors, the MVPs, the Company, and countless more visible and invisible that have made this community so successful and vibrant! The Academy drove us to learn and be RPA Practitioners, post questions, solutions, bugs, suggestions and feedbacks. As with everyone here, brings back…

This post made by @ushu received 2 likes!

Index Was Outside of the bounds of the string Array

@Nandhini_Vishnu 10 represents the count which defines maximum number of sub strings to return. That means when it is returning the value it is trying to store these 10 sub strings in different array index (Ex: Arr[0] = FirstSubString, Arr[1] = Second Substring etc). But you were trying to assign all these in an array of index 0. That could cause the issue. try the below one and share the results Remove intLoop then exp should be strArrayName=Split(strName, " ")(10) See if it giving the same …

Top 3 Most Liked Solutions

This solution provided by @ushu received 2 likes!

Index Was Outside of the bounds of the string Array

@Nandhini_Vishnu 10 represents the count which defines maximum number of sub strings to return. That means when it is returning the value it is trying to store these 10 sub strings in different array index (Ex: Arr[0] = FirstSubString, Arr[1] = Second Substring etc). But you were trying to assign all these in an array of index 0. That could cause the issue. try the below one and share the results Remove intLoop then exp should be strArrayName=Split(strName, " ")(10) See if it giving the same …

This solution provided by @Yoichi received 2 likes!

Write condition for the multiple variables

Hi, Hope the following sample helps you. [image] This returns true if all status is either of Yes , Okay or Completed. Regards,

This solution provided by @sarathi125 received 1 likes!

Check if string date is outside time window

@b.forbes , Instead of using the Month number alone you can use the whole date value to compare it against the date to be checked. Create a variable as “dteFileDate” As DateTime DataType Create a variable as “dteCompareDate” As DateTime DataType Then use first assign activity with this dteFileDate = DateTime.Parse(“1/5/2012 8:12:14 PM”) Then use second assign activity with this dteCompareDate = System.DateTime.Now.Date.AddMonths(-3) Then use a IF activity to check whether it is smaller or …

---

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.