Forum Engagement Daily Reports

[system]

Daily Forum Report | 13 April 2022

Top 3 Topics with Most Views

Leading 0s get eliminated while opening the CSV file in excel after writing to CSV made by @geetishree.rao with 45 views.

Read first sheet of Excel made by @mateo.drouillard with 44 views.

How to verify a documents based on Excel data? made by @raju_alakuntla with 35 views.

Top 3 Topics with Most Replies

Leading 0s get eliminated while opening the CSV file in excel after writing to CSV made by @geetishree.rao with 15 replies.

Multiple values in single column to queue made by @Sathish_Kumar_S with 13 replies.

Data scrape in data scraping on the website made by @Ozlem_Yigit with 12 replies.

Top 3 Users Who Posted The Most

@supermanPunch made 40 posts!

@ushu made 28 posts!

@Palaniyappan made 23 posts!

Top 3 Most Liked Posts

This post made by @diana.gray received 4 likes!

COMING SOON - You’re invited to join the “Studio Web and UiPath IT Automation” event

In this event, you’ll learn about the web version of Studio, “Studio Web,” the newest member of the Studio family, along with UiPath IT Automation activities, which are now available in Studio Web. Find out about the Activity packs that can be included in your projects, which you may be familiar with from Studio Desktop, so everything you know about using them still applies. Even more, you can download any Studio web project built with these activities and open it in…

This post made by @athira.somasekharan received 2 likes!

Unattendedで実行するとAssistantが画面上に立ち上がるのを阻止したい。

Hello @Amimn , Please check this solution: Thanks! Athira

This post made by @athira.somasekharan received 2 likes!

Get file path from an excel sheet and use that in Send SMTP Mail Message activity to send attachments

Hello @Vijay_Manimaran , You can give the path like this in AttachmentsCollection property: {“C:\Documents\abc.pdf”} If more than one attachment is present, give path as comma-seperated values. Thanks! Athira

Top 3 Most Liked Solutions

This solution provided by @athira.somasekharan received 2 likes!

Unattendedで実行するとAssistantが画面上に立ち上がるのを阻止したい。

Hello @Amimn , Please check this solution: Thanks! Athira

This solution provided by @geetishree.rao received 2 likes!

Leading 0s get eliminated while opening the CSV file in excel after writing to CSV

Hi All… Thanks … I found a way to resolve this and thought of sharing ,it may help others. If we add a TAB +convert(VARCHAR(10),Char(9)) at the end of the column value then it will not eliminate leading zeroes when csv is opened in excel and will not add qoutes as well when opened in notepad. I did this from the sql side. Thanks and Regards, Geetishree Rao

This solution provided by @Yoichi received 1 likes!

I have problem to convert text into datatable from specific condition

Hi, Another approach using Matches method : [img20220413-2] mc = System.Text.RegularExpressions.Regex.Matches(strData,"CodeNumber : (?<CodeNumber>\d+) NumberPage : (?<PageNumber>\d+)\r?\n\r?\n(?<TABLE>[\s\S]+?)(?=\r?\n\r?\n|\s*$)") Sample20220413-3.zip (3.0 KB) 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.