Forum Engagement Daily Reports

[system]

Daily Forum Report | 19 July 2023

Top 3 Topics with Most Views

Anyone knows why I am experiencing this? made by @attkren1 with 61 views.

LINQ query error made by @yash.choursia with 53 views.

Find largest prime number in a given set of numbers . Can anyone help me please how to do made by @sandhyareddy with 46 views.

Top 3 Topics with Most Replies

How to solve this error issue? made by @attkren1 with 28 replies.

Loop through all excel workbook sheets and write data in to each subfolders sheet by sheet made by @POOJA_MARUTI_BALIGIDE with 25 replies.

I am getting this error, please help me , how to made by @munichandra_kuppani with 23 replies.

Top 3 Users Who Posted The Most

@supriya117 made 76 posts!

@mkankatala made 63 posts!

@lrtetala made 55 posts!

Top 3 Most Liked Posts

This post made by @Quenton_Wayne_Rebello received 3 likes!

Excel Filter Question!

To get the data in the format mentioned you can use the linq, (From row In dtInput.AsEnumerable() Group row By ModelPrefix = If(row(“Model”).ToString().Length >= 4, row(“Model”).ToString().Substring(0, 4), row(“Model”).ToString()) Into Group Let GroupedYıl = String.Join(“,”, Group.Select(Function(r) r(“Yıl”).ToString())) Let GroupedKM = String.Join(“,”, Group.Select(Function(r) r(“KM”).ToString())) Let GroupedFiyat = String.Join(“,”, Group.Select(Function(r) r(“Fiyat”).ToString())) Select …

This post made by @supermanPunch received 2 likes!

Regex everything between 9 digit numbers

Hi @JenJen , Could you check with the below Regex Expression : (?<=\d{9})[\s\S]+?(?=\d{9}|Page) [image] Here, An assumption is also made that the Page keyword will always be present after the last address data. Let us know if it is not the case, we can identify a separate limiter.

This post made by @supriya117 received 2 likes!

Copy the data from body of the browser outlook & save it in a variable

@Somanath_Somu Use the “Send Hotkey” activity to simulate pressing Ctrl+A (select all) Use the “Send Hotkey” activity again to simulate pressing Ctrl+C (copy) Use the “Get from Clipboard” activity to retrieve the copied text from the clipboard and store it in a variable.

Top 3 Most Liked Solutions

This solution provided by @Quenton_Wayne_Rebello received 3 likes!

Excel Filter Question!

To get the data in the format mentioned you can use the linq, (From row In dtInput.AsEnumerable() Group row By ModelPrefix = If(row(“Model”).ToString().Length >= 4, row(“Model”).ToString().Substring(0, 4), row(“Model”).ToString()) Into Group Let GroupedYıl = String.Join(“,”, Group.Select(Function(r) r(“Yıl”).ToString())) Let GroupedKM = String.Join(“,”, Group.Select(Function(r) r(“KM”).ToString())) Let GroupedFiyat = String.Join(“,”, Group.Select(Function(r) r(“Fiyat”).ToString())) Select …

This solution provided by @supermanPunch received 2 likes!

Regex everything between 9 digit numbers

Hi @JenJen , Could you check with the below Regex Expression : (?<=\d{9})[\s\S]+?(?=\d{9}|Page) [image] Here, An assumption is also made that the Page keyword will always be present after the last address data. Let us know if it is not the case, we can identify a separate limiter.

This solution provided by @supriya117 received 2 likes!

Copy the data from body of the browser outlook & save it in a variable

@Somanath_Somu Use the “Send Hotkey” activity to simulate pressing Ctrl+A (select all) Use the “Send Hotkey” activity again to simulate pressing Ctrl+C (copy) Use the “Get from Clipboard” activity to retrieve the copied text from the clipboard and store it in a variable.

---

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.