Forum Engagement Daily Reports

[system]

Daily Forum Report | 11 May 2024

Top 3 Topics with Most Views

Unable to create robot in orchestrator (status Disabled) made by @Siva_prasad_meda with 43 views.

How to Remove duplicates from the string made by @Deeksha with 37 views.

I'm attempting to retrieve values from a website made by @Burak_Baris_Gologlu with 37 views.

Top 3 Topics with Most Replies

Multiple Values To A column made by @dutta.marina with 14 replies.

Unable to create robot in orchestrator (status Disabled) made by @Siva_prasad_meda with 8 replies.

I'm attempting to retrieve values from a website made by @Burak_Baris_Gologlu with 7 replies.

Top 3 Users Who Posted The Most

@mukesh.singh made 27 posts!

@shetyetejas557 made 7 posts!

@dutta.marina made 6 posts!

Top 3 Most Liked Posts

This post made by @lrtetala received 2 likes!

How to Remove duplicates from the string

Hi @Deeksha Try this inputString = "225336675992" outputString = New String(inputString.Distinct().ToArray()) Cheers!!

This post made by @nanmishra received 1 likes!

Converting to Date format from string with no delimitors

I have a string with value "“20240509051859” which yyyyMMddhhmmss. I would want to convert it to “MM/dd/yyyy hh:mm:ss”. I tried using Datetime.Parse but it is not working. Please help.

This post made by @mukesh.singh received 1 likes!

I'm attempting to retrieve values from a website

you jsut extract the all data as text then use the regex get all the value “sk182244: Check Point response to CVE-2024-24912” value Regex: “\s\s\d{6}: [A-Za-z0-9]” (you need to modify as per your need) MatchCollection matches = Regex.Matches(websiteText, pattern); foreach (Match match in matches) { extractedValues.Add(match.Groups["value"].Value); } This code work for you. you are not able to extract the data using the Extract table because the page is not in table structure format

Top 3 Most Liked Solutions

This solution provided by @lrtetala received 2 likes!

How to Remove duplicates from the string

Hi @Deeksha Try this inputString = "225336675992" outputString = New String(inputString.Distinct().ToArray()) Cheers!!

This solution provided by @Ajith_Pandi_T received 1 likes!

Excel Automation - Calculate and sum the transaction amount

Hi you can try with this approach. From row In dataTable.AsEnumerable() Group row By CustomerName = row.Field(Of String)(“CustomerName”) Into Group Select New With { .CustomerName = CustomerName, .TotalSales = Group.Sum(Function(row) row.Field(Of Double)(“SalesAmount”)) } dataTable - Read Range Output Steps use Read Range and create the OP Use assign ( var type- DataTable )Activity & pass the query Use write range activity & write the output

---

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.