Forum Engagement Daily Reports

[system]

Daily Forum Report | 01 July 2021

Top 3 Topics with Most Views

How to compare 2 columns, if the 2 columns have same data then entire row has to removed made by @Manisree_Parasa with 55 views.

Grouping and eliminating excel columns made by @Meyammai with 45 views.

Extracting JSON string from dynamic text made by @Sonalk with 44 views.

Top 3 Topics with Most Replies

This is the datatable from which I want to retrieve Sales Order number with FAIL status? if anyone can help? made by @anjasing with 16 replies.

How to compare 2 columns, if the 2 columns have same data then entire row has to removed made by @Manisree_Parasa with 10 replies.

Adding values with loop to a data table - data table is not getting updated made by @Lior_Ben_Naim with 10 replies.

Top 3 Users Who Posted The Most

@Srini84 made 24 posts!

@ppr made 13 posts!

@anjasing made 11 posts!

Top 3 Most Liked Posts

This post made by @prasath17 received 2 likes!

Use regex in notepad?

@fairymemay - Read the data.txt using “Read text file” activity and save the output Say StrInput Then using the Matches activity as shown below… [image] Regex Pattern: (?<=Save\s+:\s+)\d+(?=\s+Total Record) [image] Hope this helps…

This post made by @ppr received 2 likes!

Grouping and eliminating excel columns

Variables: [grafik] Flow: [grafik] [grafik] Statements taken from above Find starter help here: GroupBy_2Col_GRPCustomSort_TakeFirst.xaml (8.5 KB)

This post made by @lakshman received 1 likes!

Options strict on disallows implicit conversions from string to double

@Mehak Data scraping will give you output as DataTable. So you need to create one variable of type System.DataTable and pass it to Data scraping activity.

Top 3 Most Liked Solutions

This solution provided by @prasath17 received 2 likes!

Use regex in notepad?

@fairymemay - Read the data.txt using “Read text file” activity and save the output Say StrInput Then using the Matches activity as shown below… [image] Regex Pattern: (?<=Save\s+:\s+)\d+(?=\s+Total Record) [image] Hope this helps…

This solution provided by @ppr received 2 likes!

Grouping and eliminating excel columns

Variables: [grafik] Flow: [grafik] [grafik] Statements taken from above Find starter help here: GroupBy_2Col_GRPCustomSort_TakeFirst.xaml (8.5 KB)

This solution provided by @WangJidong received 1 likes!

Read filename (number only)?

@fairymemay Please check this Xaml file, hope it can help you Regards. [image] Main.xaml (11.6 KB)

---

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.