Forum Engagement Daily Reports

[system]

Daily Forum Report | 18 January 2024

Top 3 Topics with Most Views

C# problem made by @anamariavioleta.dinca with 46 views.

Text file to dictionary made by @Sree_Krishnan_vellinezhi with 46 views.

Having the 50,000 rows in excel file and wants to check Duplicate values in 2 columns and color it made by @Shubham_Arora1 with 44 views.

Top 3 Topics with Most Replies

How to check specific value is present in datatable or not? made by @Sanket_Shinde1 with 14 replies.

Regex Character made by @marina.dutta with 12 replies.

How to print the Mail message list value? made by @athira.aneesh with 12 replies.

Top 3 Users Who Posted The Most

@vrdabberu made 42 posts!

@ppr made 28 posts!

@Anil_G made 28 posts!

Top 3 Most Liked Posts

This post made by @pikorpa received 3 likes!

Regex Character

Please try it: System.Text.RegularExpressions.Regex.Replace(file_Name, "[^\w\-\.\[\]\(\)]", "")

This post made by @pikorpa received 2 likes!

Regex Character

Hey @marina.dutta try to use: System.Text.RegularExpressions.Regex.Replace(file_Name, "[^A-Za-z0-9 ._-]", "") [image]

This post made by @ppr received 2 likes!

Creating Folders using Folder Exists

We Would assume, that the confusion comes from: [grafik] the slashes and the concatenated folder names When e.g.is needed C:\_rpa\Input_File C:\_rpa\Image_JPEG C:\_rpa\Image_JPEG we can do: Variable: strRootFolderPath = "C:\_rpa" [grafik] item in new String(){"Input_File","Image_JPEG","QR_Codes"}

Top 3 Most Liked Solutions

This solution provided by @pikorpa received 2 likes!

Regex Character

Hey @marina.dutta try to use: System.Text.RegularExpressions.Regex.Replace(file_Name, "[^A-Za-z0-9 ._-]", "") [image]

This solution provided by @ppr received 2 likes!

Creating Folders using Folder Exists

We Would assume, that the confusion comes from: [grafik] the slashes and the concatenated folder names When e.g.is needed C:\_rpa\Input_File C:\_rpa\Image_JPEG C:\_rpa\Image_JPEG we can do: Variable: strRootFolderPath = "C:\_rpa" [grafik] item in new String(){"Input_File","Image_JPEG","QR_Codes"}

This solution provided by @Nawazish_Ahmad received 1 likes!

How to print the Mail message list value?

Hi @athira.aneesh You can use Loop for get all the details like Subject, From address, Body etc. [image] For check all in Immediate Panel according to your Question. Use below expression in Immediate Panel or Message Box String.Join(Environment.NewLine, MailList.Select(Function(mailMessage) $“Subject: {mailMessage.Subject}, From: {mailMessage.From.Address}”)) Replace MailList with you variable i.e MailMessage Hope it will helps you 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.