Forum Engagement Daily Reports

[system]

Daily Forum Report | 30 January 2024

Top 3 Topics with Most Views

Remove 1st digit made by @mironb with 60 views.

How to set the months given in the table made by @anjani_priya with 54 views.

How to extract each image from one pdf made by @a501ee789b18770c39989a6d5 with 46 views.

Top 3 Topics with Most Replies

How to stop/BE transaction based on current date and criteria made by @8b6861dc5e0c9f7008548ca66 with 18 replies.

How to extract each image from one pdf made by @a501ee789b18770c39989a6d5 with 15 replies.

Date format error please help made by @Hemant_Deshmukh with 14 replies.

Top 3 Users Who Posted The Most

@vrdabberu made 70 posts!

@mkankatala made 62 posts!

@ppr made 27 posts!

Top 3 Most Liked Posts

This post made by @Brian_Mathew_Maben received 3 likes!

Need regex for below file name extract number in starting name

Hey @Vicky_K , try using this regex: \d+(?=_) [image] You can try using this: System.Text.RegularExpressions.Regex.Matches((“String Containing file names”),“\d+(?=_)”)

This post made by @ppr received 3 likes!

Move every second row from datatable into different column

Along with the typical preparation of dtResult [grafik] dtResult= dtData.AsEnumerable.Select(Function (x) x(0)).Chunk(2).Select(Function (ra) dtResult.Rows.Add(ra)).CopyToDataTable [grafik]

This post made by @mkankatala received 2 likes!

Select Item 'DIV': Error HRESULT E_FAIL has been returned from a call to a COM component

I have done the Workflow for you, check the below one, Regex_Practice.xaml (66.9 KB) [Regex_Practice] I have modified the Input data in the Excel according to the data in the Naukari website, check the below input file, New Microsoft Excel Worksheet.xlsx (8.3 KB) Hope it helps!!

Top 3 Most Liked Solutions

This solution provided by @mkankatala received 1 likes!

Input string format

Hi @darshanb.is22 Change the code like this (From row In dtt.AsEnumerable() Order By CInt(row("Reviews").ToString().Trim()) Descending, CInt(row("Price").ToString().Trim()) Ascending Select row).CopyToDataTable() Use trim to avoid the spaces. Hope it helps!!

This solution provided by @mkankatala received 1 likes!

Excel process scope get sheets

Hi @SorenB Excel application scope is the Classic activity and Excel process scope is the Modern activity. To get the first sheet of excel file follow the below process, → Take the Excel process scope activity and insert the use excel file activity inside of it. → Pass the Path of the excel file in the Use excel file activity. → Insert the For each excel sheet activity inside the use excel file. → Inside for each insert the Assign activity and create a String datatype variable called F…

This solution provided by @Anil_G received 1 likes!

Filter datatable from csv on date >= Today

@Luke69 Welcome to the community You can use linq expression liek this in assign Dt = dt.AsEnumerable.Where(function(x) Cdate(x("Date").ToString)>Today).CopyToDatatable Now your table will have only the filtered rows Cheers

---

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.