Forum Engagement Daily Reports

[system]

Daily Forum Report | 14 March 2024

Top 3 Topics with Most Views

How to split string using regex made by @Lalitha_Selvaraj with 49 views.

Get Queue Items > Fault made by @Mesut_Can with 48 views.

Anchor Based is not working to extract information for the variable made by @rahul.kumar3 with 45 views.

Top 3 Topics with Most Replies

Get Queue Items > Fault made by @Mesut_Can with 18 replies.

Filter Email - Outlook made by @abivanth.r with 16 replies.

Processing multiple files one by one made by @pabaleloh with 15 replies.

Top 3 Users Who Posted The Most

@mkankatala made 47 posts!

@ppr made 27 posts!

@Jayesh_678 made 26 posts!

Top 3 Most Liked Posts

This post made by @abivanth.r received 2 likes!

Filter Email - Outlook

yes it is. Thanks for the help bro. In save attachment there is a filter option and i provider the string “.pdf” It worked. Thanks for your time

This post made by @mkankatala received 2 likes!

LinQ to Add Array in Another Array

Hi @Fabio_Villamil Try the below linQ expression, - Assign -> inputArray = {"1,2,3,4","5,6,7,8"} - Assign -> outputArray = inputArray.Select(Function(str) str.Split({","c}).ToArray()).ToArray() Check the below workflow for better understanding, [image] Hope it helps!!

This post made by @ppr received 2 likes!

How to write data from sheet 1 to sheet 2

there are several options to do it. We can use sheet1 data and create for us a lookup data dictionary: [grafik] then we can use for sheet2 a dtData2.NewRow for getting an empty row within the Sheet2 Schema which we can populate with the help of the lookup data dictionary

Top 3 Most Liked Solutions

This solution provided by @mkankatala received 2 likes!

LinQ to Add Array in Another Array

Hi @Fabio_Villamil Try the below linQ expression, - Assign -> inputArray = {"1,2,3,4","5,6,7,8"} - Assign -> outputArray = inputArray.Select(Function(str) str.Split({","c}).ToArray()).ToArray() Check the below workflow for better understanding, [image] Hope it helps!!

This solution provided by @Yoichi received 2 likes!

Check with data 2 file

I modified workflow like without If inside if. Can you check the following sample? actual file report have data 1000 record if take time to run. I don’t think it takes so long time in run mode if there are around 1000 records in Excel. However it may be better to use DataTable instaed of ForEachExcelRow to improve throughput. Sample Sample20240314-2 (2).zip (721.7 KB) Regards,

This solution provided by @ptrobot received 1 likes!

Linq to .trim all values in datatable’s all rows & all columns?

With two Assign statements: trimmedDataTable = originalDataTable.Clone trimmedDataTable = originalDataTable.AsEnumerable.Select(Function(row) row.ItemArray.Select(Function(cell) cell.ToString().Trim()).ToArray()).Select(Function(cells) trimmedDataTable.Rows.Add(cells)).CopyToDataTable

---

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.