Forum Engagement Daily Reports

[system]

Daily Forum Report | 22 September 2021

Top 3 Topics with Most Views

How to make [ ] as optional in regex made by @Kavya_Mamidishetti2 with 37 views.

Scraping data from body of E-mail made by @Radha_Ganesan with 34 views.

Update MainDT using filtered rows made by @Omkar_Deshmukh with 32 views.

Top 3 Topics with Most Replies

Display List of strings as Input option in Input dialog Box, using config file made by @Dimple_Mandal with 19 replies.

Update MainDT using filtered rows made by @Omkar_Deshmukh with 16 replies.

Scraping data from body of E-mail made by @Radha_Ganesan with 15 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 46 posts!

@ppr made 21 posts!

@Yoichi made 20 posts!

Top 3 Most Liked Posts

This post made by @erghe received 4 likes!

Unlock Linux automation with 21.8 Robot!

We are proud to announce that the following UiPath IT Automation activity packages are now available for the Robot on Linux: Amazon Web Services (AWS) AWS Workspaces Azure Azure Virtual Desktop Azure Active Directory Google Cloud (GCP) Citrix Hypervisor The cross-platform UiPath IT Automation activities enable you to build automations for Cloud resources provisioning and management, ITSM and User Management, Desktop and App Virtualization, Server Virtualization. Stay tuned for updated exampl…

This post made by @g.ward received 2 likes!

Date Picker always displays wrong date (1 day before selection)

Hi, I’d like to report the same bug, where the app appears to be subtracting an hour and putting the date back one!

This post made by @Palaniyappan received 2 likes!

Regex to get any 4 Digit or Character or Both, Inside a Double Qoute

Hi Hope this expression helps you resolve this Use Matches activity and mention this expression (?<=CODE\W\W\s\W).*(?=\W,) This will get all the values of CODE of any type Be it character or number Cheers @Shinjid

Top 3 Most Liked Solutions

This solution provided by @Palaniyappan received 2 likes!

Regex to get any 4 Digit or Character or Both, Inside a Double Qoute

Hi Hope this expression helps you resolve this Use Matches activity and mention this expression (?<=CODE\W\W\s\W).*(?=\W,) This will get all the values of CODE of any type Be it character or number Cheers @Shinjid

This solution provided by @Palaniyappan received 2 likes!

Separating string in an excel column

Hi Hope these steps would help you resolve this —use a excel application scope and pass the file path as input and get the output as dt with read range activity —now use a BUILD DATATABLE ACTIVITY with two columns we want and get the output as dt_final —use a CLEAR datatable activity and pass the above dt_final as input —then use a FOR EACH ROW activity and pass dt as input —inside the loop use a assign activity like this Intcount = Split(row(0).ToString,” “).Count Where intcount is a va…

This solution provided by @Palaniyappan received 2 likes!

Excel questions

Hi Mention in cell range as “A11” and enable add headers This will read all the records from A11 inspite of dynamic number of rows after that Cheers @Matthew2

---

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.