Forum Engagement Daily Reports

[system]

Daily Forum Report | 24 May 2024

Top 3 Topics with Most Views

Important updates to user settings behavior in Orchestrator made by @sebastian.ungureanu with 58 views.

How to read all the outlook mail which is received today and having some attachement? made by @Kumar_Sahu_Sameer with 48 views.

Trying to iteratively click the list of job banners in Linked in made by @bird_real with 47 views.

Top 3 Topics with Most Replies

Need help with Regex expression made by @Avinesh_Ramanathan with 16 replies.

Concatenating data from extract table data activity made by @kiat.t with 16 replies.

Taxonomy Manager doesnt appear made by @uzumuzum558 with 15 replies.

Top 3 Users Who Posted The Most

@ashokkarale made 21 posts!

@postwick made 21 posts!

@ppr made 19 posts!

Top 3 Most Liked Posts

This post made by @Avinesh_Ramanathan received 1 likes!

Need help for Regex pattern

My input file : My DOB : 01/05/89 at Chennai I am an IT professional working in Southern India. My DOJ : 20/04/24 at Bengaluru My recruitment happened through campus hire program. I will be working on UiPath and Dot net related projects. Can you please me on how to extract date in dd/mm/yy format and location as Bengaluru. Can you help me with single regex statement → Start keyword as IT and End keyword as recruitment

This post made by @lrtetala received 1 likes!

Need help for Regex pattern

@Avinesh_Ramanathan (?<=IT[\s\S]*?\d+\/\d+\/\d+\s+\w+\s+)[A-Za-z]+(?=[\s\S]*?recruitment) [image] Regards,

This post made by @yashashwini2322 received 1 likes!

Inserting Screenshots to Excel Sheet using VBA

Hi all, the requirement is to add all the Screenshot present in a folder one by one to Excel sheet one after the other. I am looping the folder and getting Screenshots and using Invoke code placing all into Excel sheet. But the problem is the code I’m using is opening excel and pasting and closing excel for every image.I want the excel to be opened once and then insert all the image one after the other.I’m not good in vb code,can anyone please modify or guide me to do so. Have attached the …

Top 3 Most Liked Solutions

This solution provided by @ppr received 1 likes!

Need help with Regex expression

ensure always in regex101: [grafik] do in UiPath your Rnd /Prototypings within the immediate panel Understanding the 6 Debugging Panels of UiPath in the easiest way possible! - News / Tutorials - UiPath Community Forum and use it also for skill check [CheatSheet] - System.Text.RegularExpressions | RegEx - News / Tutorials - UiPath Community Forum

This solution provided by @ashokkarale received 1 likes!

Share Point MetaData not created

@nanmishra, No direct way but you can following approach. Upload file with your existing code. Get File/Folder to get file uploaded in step 1 to check metadata If metadata as per requirement, do nothing else, delete the file. Hope this workaround will work. Thanks, Ashok

This solution provided by @ashwin.ashok received 1 likes!

Reading random Values in excel

Hi @devasaiprasad_K , Asssuming that you are expecting three columns in the output, modify the logic and give this a try: (From row In dt_data.AsEnumerable() Let ra = row.ItemArray.Where(Function(w) Not(IsNothing(w) OrElse String.IsNullOrEmpty(w.ToString))).ToArray() Select dt_res.Rows.Add(ra)).CopyToDataTable() This works if there are only three items with values in a given row i.e., if there are 6 columns with 3 empty cells and 3 cells populated with data, this logic works. CompressLastCol…

---

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.