Forum Engagement Daily Reports

[system]

Daily Forum Report | 15 December 2023

Top 3 Topics with Most Views

DataTable変数dtの0-11列を一括削除したいが、構文を至急教えてください。 made by @gorby with 37 views.

We are facing an issue with send mail activity made by @Shaik_Ghouse_Basha1 with 36 views.

Email automation with studio exercise made by @Ikem_Samuel with 36 views.

Top 3 Topics with Most Replies

DataTable変数dtの0-11列を一括削除したいが、構文を至急教えてください。 made by @gorby with 18 replies.

OpenAi Chat Completion output not formatted correctly when used as body for the "Reply To Outlook Mail Message" Activity made by @Lloyd_B with 14 replies.

Error in Concating Columns made by @yash.choursia with 10 replies.

Top 3 Users Who Posted The Most

@ppr made 23 posts!

@Yoichi made 15 posts!

@mkankatala made 13 posts!

Top 3 Most Liked Posts

This post made by @vrdabberu received 2 likes!

PDF Text to Table Column

Hi @yee68 After extracting the data please give the input to matches activity and then use the below mentioned regex in the matches activity and then use the for each activity and pass the output of the matches activity to the for each activity and later use the below mentioned regex’s to extract the data you required. System.Text.RegularExpressions.Regex.Match(InputString,"(\d{9,}\s+[A-Z]*\s*[A-Z]*\d*\/\d+\/\d+[\s\S]*?SINGAPORE[\s\S]*?SINGAPORE[\s\S]*?(\d+\.\d+))").Value [image] System.Tex…

This post made by @pikorpa received 1 likes!

How to set a default value for a dropdown in a form?

you can set default value if you will add the custom default value: [image] [image] here you can find code: dropList.zip (3.4 KB)

This post made by @pikorpa received 1 likes!

How to set a default value for a dropdown in a form?

Hey, here you might find something: Activities - Dynamic Dropdowns (uipath.com)

Top 3 Most Liked Solutions

This solution provided by @vrdabberu received 2 likes!

PDF Text to Table Column

Hi @yee68 After extracting the data please give the input to matches activity and then use the below mentioned regex in the matches activity and then use the for each activity and pass the output of the matches activity to the for each activity and later use the below mentioned regex’s to extract the data you required. System.Text.RegularExpressions.Regex.Match(InputString,"(\d{9,}\s+[A-Z]*\s*[A-Z]*\d*\/\d+\/\d+[\s\S]*?SINGAPORE[\s\S]*?SINGAPORE[\s\S]*?(\d+\.\d+))").Value [image] System.Tex…

This solution provided by @Shiva_Nikhil received 1 likes!

Help with Null Ref error when reading Excel col to String Array

@Yomi_Oluwadara readExcelColEntriesToArray (1).zip (13.2 KB)

This solution provided by @Yoichi received 1 likes!

Image Clicks

Hi, Basically, compatibility of SimulateClick or SendWindowMessage is not 100%, as the following document. So, it may not work in these input methods. Regards,

---

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.