Forum Engagement Daily Reports

[system]

Daily Forum Report | 08 May 2023

Top 3 Topics with Most Views

LINQ to update columns in data table made by @besakkiappan46 with 66 views.

How to split any string with text as keyword made by @Swarit_Goyal1 with 58 views.

Data Base query to excel File made by @Jay_Chaudhary with 58 views.

Top 3 Topics with Most Replies

How to split any string with text as keyword made by @Swarit_Goyal1 with 23 replies.

Regular expression not working made by @neha.verma with 23 replies.

Data Base query to excel File made by @Jay_Chaudhary with 18 replies.

Top 3 Users Who Posted The Most

@Anil_G made 34 posts!

@supermanPunch made 30 posts!

@Shubham_Kinge made 23 posts!

Top 3 Most Liked Posts

This post made by @Gokul001 received 5 likes!

Monthly Forum rewards - April 2023

Congratulations to all the winners

This post made by @Anil_G received 3 likes!

Monthly Forum rewards - April 2023

Congratulations … Keep up the good work

This post made by @vishal.kp received 2 likes!

Monthly Forum rewards - April 2023

Congrats team

Top 3 Most Liked Solutions

This solution provided by @Nitya1 received 2 likes!

If activity with OR expression

Hi @rathi.sham Try this LINQ function to filter the array and return only the items that do not match those two values. Use an Assign activity to create a new filtered array:- filteredArray = myarray.Where(Function(fruit) Not fruit.Equals(“Kiwi”) AndAlso Not fruit.Equals(“Plum”)).ToArray() Use an If activity to check if the original array contains “Kiwi” or “Plum”: myarray.Intersect({“Kiwi”, “Plum”}).Any() This expression returns True if the original array contains any of the values …

This solution provided by @arjunshenoy received 2 likes!

LINQ to update columns in data table

Hi @besakkiappan46, welcome to the Community. Please use the following query in the Invoke Code activity: C#: { yourDt.AsEnumerable.ToList.ForEach(row => { row("TIN") = System.Text.RegularExpressions.Regex.Match(row("TIN").ToString().Trim(), @"(\d{3})(\d{2})(\d{3})").Groups[1].ToString() + "-" + System.Text.RegularExpressions.Regex.Match(row("TIN").ToString().Trim(), @"(\d{3})(\d{2})(\d{3})").Groups[2].ToString() + "-" + System.Text.RegularExpressions.Regex.Match(row("TIN").To…

This solution provided by @Shubham_Kinge received 1 likes!

Help with activity Save as Excel fil

Hello @Ricchch Here you can do, dont provide hardcoded path. provide folder to store the file. then use for each file in folder which contains *.csv,*xls different condition. and then provide that file path to use file activity using currentfile. Hope this helps.

---

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.