Forum Engagement Daily Reports

[system]

Daily Forum Report | 10 November 2024

Top 3 Topics with Most Views

Regex to extract only top data from email body made by @Binod_Kumar_Biswal with 20 views.

Regex Command to get value after non specific symbol location made by @Abang_Jamuri_Abang_Shoker with 14 views.

Regex Flexible configuration how? made by @Abang_Jamuri_Abang_Shoker with 14 views.

Top 3 Topics with Most Replies

Getting a Person or Group type object to Update Sharepoint List made by @kengweechan with 8 replies.

Regex to extract only top data from email body made by @Binod_Kumar_Biswal with 7 replies.

メール本文にあるURLを開き(完了)、開いた先の情報を取得する方法 made by @once10201029 with 7 replies.

Top 3 Users Who Posted The Most

@Anil_G made 12 posts!

@ashokkarale made 6 posts!

@kengweechan made 4 posts!

Top 3 Most Liked Posts

This post made by @Manisha_Ravindra received 2 likes!

Computer vision in Studio

@Nisha_K21 , Additionally you can refer this YouTube video as well ` https://www.youtube.com/watch?v=64ggPaQPEy4 `

This post made by @Yoichi received 1 likes!

Filtering by quarters of years in Excel

Hi, How about the following sample? [image] dictQuarter = New Dictionary(Of Int32,String)From{{1,"Q1"},{2,"Q1"},{3,"Q1"},{4,"Q2"},{5,"Q2"},{6,"Q2"},{7,"Q3"},{8,"Q3"},{9,"Q3"},{10,"Q4"},{11,"Q4"},{12,"Q4"}} dict = dt.AsEnumerable.GroupBy(Function(r) Tuple.Create(CDate(r("Date")).Year,dictQuarter( CDate(r("Date")).Month))).ToDictionary(Function(g) g.Key,Function(g) g.ToArray) Sample Sample20241110-1.zip (7.4 KB) note: please check result.xlsx Regards,

This post made by @Akash_Javalekar1 received 1 likes!

OOB ML Packages are missing. No option to select

I am Also facing the same issue no ml package available under out of box model. @ashokkarale thanks for sharing let me know if anyone has any resolution for this Thanks

Top 3 Most Liked Solutions

This solution provided by @Manisha_Ravindra received 2 likes!

Computer vision in Studio

@Nisha_K21 , Additionally you can refer this YouTube video as well ` https://www.youtube.com/watch?v=64ggPaQPEy4 `

This solution provided by @Yoichi received 1 likes!

Filtering by quarters of years in Excel

Hi, How about the following sample? [image] dictQuarter = New Dictionary(Of Int32,String)From{{1,"Q1"},{2,"Q1"},{3,"Q1"},{4,"Q2"},{5,"Q2"},{6,"Q2"},{7,"Q3"},{8,"Q3"},{9,"Q3"},{10,"Q4"},{11,"Q4"},{12,"Q4"}} dict = dt.AsEnumerable.GroupBy(Function(r) Tuple.Create(CDate(r("Date")).Year,dictQuarter( CDate(r("Date")).Month))).ToDictionary(Function(g) g.Key,Function(g) g.ToArray) Sample Sample20241110-1.zip (7.4 KB) note: please check result.xlsx Regards,

This solution provided by @lrtetala received 1 likes!

Regex Flexible configuration how?

Hi @Abang_Jamuri_Abang_Shoker Can you try the below (?<=(N|n)ame\s*:\s*)(.*) [The image shows a regex test platform where the regex pattern "/(?<=(Nn)ame*:*)(.*)/g" is matched against seven lines of text containing variations of the word "Name" followed by different values. (Captioned by AI)] Regards,

---

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.