Forum Engagement Daily Reports

[system]

Daily Forum Report | 15 March 2022

Top 3 Topics with Most Views

Assign: The source contains no DataRows? made by @fairymemay with 45 views.

Rowcount after filtering made by @Sirisha_Siri with 43 views.

How to Fetch files from a folder based on the timestamp in filename? made by @Sirimalla_Karthik_Chandra with 42 views.

Top 3 Topics with Most Replies

How to Fetch files from a folder based on the timestamp in filename? made by @Sirimalla_Karthik_Chandra with 15 replies.

How to make filters with regex from array or from variables with conditionals? made by @Lynx with 13 replies.

Extract Firstname and Last name from the string after specific text format made by @benjamin.9052 with 13 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 51 posts!

@Palaniyappan made 29 posts!

@ushu made 22 posts!

Top 3 Most Liked Posts

This post made by @ppr received 2 likes!

Group String in Array and Json

after deserialization will look like this: [grafik] you will lose some values. We can achieve it by grouping the values, but need the detail input string. Maybe you can share it as txt file with us? Thanks

This post made by @supermanPunch received 2 likes!

Group String in Array and Json

Hi @Pablo_Sanchez , Try Replacing the Regular expression Pattern in Matches Activity with the below : \[(\d+)\](.*?)\/\/ Let us know if it doesn’t work

This post made by @ppr received 2 likes!

Group String in Array and Json

@Pablo_Sanchez With the help of Regex we can split the string [grafik] refering to the groups (we will trim later) [grafik] For regex learning have a look here: With following flow we can achieve the result: [grafik] [grafik] [grafik] The main idea is about: use regex to as mentioned above Regex.Matches(strText, strPattern, RegexOptions.IgnoreCase) group the matches and create JProperties, return all as an array (From m In myMatches.Cast(Of Match).toList Group m By k=m.Gro…

Top 3 Most Liked Solutions

This solution provided by @MirceaGolban received 2 likes!

Pre-defined ML Packages

Hi @Vicky_Fegan1 We know about the download issue and a fix is in the works. In the meantime, please use the attached schemas. schemas.zip (16.2 KB) Thank you

This solution provided by @Soudios received 1 likes!

I would like the bot to write to the last empty line in Excel

i tried an other solution that’s you count the number of row on the excel and you add +1

This solution provided by @supermanPunch received 1 likes!

Group String in Array and Json

Hi @Pablo_Sanchez , I was able to Get the Data into the Json as Needed. Although there might be a better method than this. First we have to identify the group of values in the input String. We could use the below Regex for that : \[(\d+)\](\w+) [image] We can then use the Matches Activity with the above pattern to get the resultant matched values. Here onwards, the data I have converted to a Datatable for ease in grouping the values. [image] Next, Group the data based on Number and iter…

---

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.