Forum Engagement Daily Reports

[system]

Daily Forum Report | 02 August 2021

Top 3 Topics with Most Views

If activity string variable condition made by @JeffNZ1 with 38 views.

How to delete duplicate and keep only the last row in duplicate entries? made by @Alvin_Apostol1 with 36 views.

Athamas Technologies Pvt Ltd - UiPath Developer - Bangalore - India - Full Time made by @vidyananda.v with 33 views.

Top 3 Topics with Most Replies

Stop the process after catch activity made by @Soudios with 17 replies.

How to find count of a value? made by @taruna.mehra with 12 replies.

How to delete duplicate and keep only the last row in duplicate entries? made by @Alvin_Apostol1 with 11 replies.

Top 3 Users Who Posted The Most

@ppr made 27 posts!

@Yoichi made 24 posts!

@ermanoj3101 made 19 posts!

Top 3 Most Liked Posts

This post made by @jeevith received 2 likes!

Can run multiple lines of query in uipath 'excute query activity'?

Hi @S_Sim, If you decide to use the 2nd method suggested by @RPAForEveryone, then you can refer to solutions in this thread SQL Stored procedure Passing Parameters To fetch particular records to execute your Stored-Procedure via UiPath and get the DataTable from th Database.

This post made by @Moreshwar_Gosavi received 2 likes!

Brilliant platform

Course feedback- I am really very impressed with the overall UiPath platform, the easy access to the academy to learn. Easy to understand language that even a semi-technical/ non-technical person like me also understands the concept. Keep it up!

This post made by @Yoichi received 2 likes!

Help with Regex Expression- To fetch Alpha numeric and numeric values only

Hi, How about the following pattern? [A-Za-z0-9]{4}\d|[A-Za-z0-9]\d[A-Za-z0-9]{3}|[A-Za-z0-9]{2}\d[A-Za-z0-9]{2}|[A-Za-z0-9]{3}\d[A-Za-z0-9]|\d[A-Za-z0-9]{4} Regards,

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

Help with Regex Expression- To fetch Alpha numeric and numeric values only

Hi, How about the following pattern? [A-Za-z0-9]{4}\d|[A-Za-z0-9]\d[A-Za-z0-9]{3}|[A-Za-z0-9]{2}\d[A-Za-z0-9]{2}|[A-Za-z0-9]{3}\d[A-Za-z0-9]|\d[A-Za-z0-9]{4} Regards,

This solution provided by @postwick received 2 likes!

If activity string variable condition

You should be using Get Workbook Sheets to get the sheets (and their names).

This solution provided by @fostercarly received 1 likes!

UiPath Forms - convert json output result of Date to another format

JSON does not know anything about dates. What .NET does is a non-standard hack/extension. The problem with dates in JSON and really JavaScript in general – is that there’s no equivalent literal representation for dates. In JavaScript following Date constructor straight away converts the milliseconds since 1970 to Date as follows: var jsonDate = new Date(1297246301973); Then let’s convert it to js format: var date = new Date(parseInt(jsonDate.substr(6))); The substr() function takes out the /…

---

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.