Forum Engagement Daily Reports

[system]

Daily Forum Report | 04 June 2024

Top 3 Topics with Most Views

How to get Ranges from Highlighted text using regular expression made by @shaik.muktharvalli1 with 59 views.

【質問】データテーブル同士の結合 made by @ando0403.primal with 59 views.

データテーブルの複数カラムの合算 made by @ando0403.primal with 52 views.

Top 3 Topics with Most Replies

How to get Ranges from Highlighted text using regular expression made by @shaik.muktharvalli1 with 15 replies.

Replace regex made by @Sira with 15 replies.

【質問】データテーブル同士の結合 made by @ando0403.primal with 12 replies.

Top 3 Users Who Posted The Most

@ashokkarale made 39 posts!

@Yoichi made 37 posts!

@postwick made 18 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 1 likes!

How to Handle Multiple Scenarios? Using Switch Activity?

Hi, If my understanding is correct, How about the following? [image] dt_forBU2and4.AsEnumerable.Sum(Function(r) CInt(r("ColumnName"))) Note: The above is assumed that there are 2, 1 or 0 rows in the datatable and the row uniquely has value “2” or “4”. Regards,

This post made by @vrdabberu received 1 likes!

【質問】データテーブル同士の結合

Hi @ando0403.primal FYI, Another Approach resultTable = (From row1 In dt1.AsEnumerable() Join row2 In dt2.AsEnumerable() On row1.Field(Of String)("担当者名") Equals row2.Field(Of String)("担当者名") Select resultTable.Rows.Add(row1.Field(Of String)("担当者名"), row1.Field(Of String)("担当Gr"), Convert.ToDouble(row2.Field(Of Object)("金額")))).CopyToDataTable() Check the below workflow for better understanding Sample Process 7.zip (36.2 KB) Regards

This post made by @Yoichi received 1 likes!

How to get Ranges from Highlighted text using regular expression

Hi, How about the following sample? [image] Sample Sample20240604-2.zip (10.9 KB) Please check Sheet1 and Sheet2 in result.xlsx because there seems 2 table in the text. Regards,

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

How to get Ranges from Highlighted text using regular expression

Hi, How about the following sample? [image] Sample Sample20240604-2.zip (10.9 KB) Please check Sheet1 and Sheet2 in result.xlsx because there seems 2 table in the text. Regards,

This solution provided by @Anil_G received 1 likes!

How to use the foreachlistitemconnections?

@Aniesah_Malong this is how you can get and use [image] here Col1, Col2 , Col3 are the column names cheer

This solution provided by @vrdabberu received 1 likes!

Substring and regex

Hi @Arvind1 Check the below xaml for refernce: Sequence10.xaml (8.3 KB) Regex: (\d+\.\d+)(?=\s*\d+\.\d+\s*\d+\.\d+$) 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.