Forum Engagement Daily Reports

[system]

Daily Forum Report | 30 November 2023

Top 3 Topics with Most Views

How To Make Dynamic Table Row made by @marina.dutta with 57 views.

UiPath Studio Enterprise Editionインストール時の不明点 made by @gorby with 47 views.

For Each Row In DataTable (Body)is not appearing made by @mbercianop with 40 views.

Top 3 Topics with Most Replies

How To Make Dynamic Table Row made by @marina.dutta with 35 replies.

Issue in selection from dropdown on web made by @Smitesh_Aher2 with 15 replies.

How to open pdf file made by @Niranjan_k with 12 replies.

Top 3 Users Who Posted The Most

@Yoichi made 38 posts!

@Anil_G made 25 posts!

@postwick made 22 posts!

Top 3 Most Liked Posts

This post made by @Shiva_Nikhil received 2 likes!

Advent 2023 in the UiPath Forum Community

@loredana_ifrim Nice one and looking forwad to participate Thanks for the wonderful challenge

This post made by @pravallikapaluri received 2 likes!

How to cut characters according to a rule

Hi @22222222asas initially go to the imports panel and import the below System.Text.RegularExpressions Then Assign inputString=“Bussiness Corp.3000 UinateaMinamia city, KanaUSA 3000Phone:Fax:” Message box String.Join(Environment.NewLine, System.Text.RegularExpressions.Regex.Matches(inputString, ".{1,25}(\s|$)").Cast(Of Match)().Select(Function(m) m.Value.Trim())) The expected output shown below [image] Hope it helps!!

This post made by @MWB received 1 likes!

Advent 2023 in the UiPath Forum Community

looking forward to compete.

Top 3 Most Liked Solutions

This solution provided by @lrtetala received 1 likes!

Change Excel file format .xls to xlsx

Hi @Anjali_Rani How about the following? [image] Hope this helps!!

This solution provided by @Anil_G received 1 likes!

Regular Expression to capture multiple line from sample text

@Isaac_Yeh try with regex options multiline and singleline check if the newline character is coming different in UiPath when read…for that open locals panel and check the value by clicking on magnifier may be new line is coming as \r\n generally to handle both cases \r?\n can be used cheers

This solution provided by @Yoichi received 1 likes!

Unable to read CSV file

Hi, Can you try as the following? First, read csv file as string using ReadTextFile activity. Next remove the first line of the string using the following expression. strCsv = System.Text.RegularExpressions.Regex.Replace(strCsv,"^.*\n","") Finally, convert it to DataTable using GenerateDataTable activity with CSV option. [image] Regards,

[Previous Month] Top 3 Users with the most likes on their solutions

@Yoichi received 41 likes for their solutions!

@Anil_G received 31 likes for their solutions!

@rikulsilva received 25 likes for their solutions!

---

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.