Forum Engagement Daily Reports

[system]

Daily Forum Report | 31 March 2023

Top 3 Topics with Most Views

【UiPathアカデミー】新規コースのお知らせ（3/31 追加分） made by @yuko.tanaka with 59 views.

How could I copy data from a cell in an excel file and paste it into a web form? made by @ximenasalas872 with 42 views.

Data Service error - when Update or query records made by @Arvind_Kumar1 with 41 views.

Top 3 Topics with Most Replies

Converting the string to the integer made by @shailaja_reddy with 17 replies.

Hi, I am trying to get a email message from my yahoo mailbox but i got timeout.Can anyone help me to check why ic ouldnt get the message ? Is it something wrong with my properties? made by @royang28 with 13 replies.

Find Dynamic Excel Read & Write into sheet made by @anh.nguyen with 11 replies.

Top 3 Users Who Posted The Most

@Anil_G made 26 posts!

@Yoichi made 25 posts!

@arjunshenoy made 19 posts!

Top 3 Most Liked Posts

This post made by @sumits received 3 likes!

Announcing the Winners of AI Awards 2023

Thank you so much @Vibhor.Shrivastava and @loredana_ifrim

This post made by @Chirag_Shetty_Divakar received 3 likes!

While loop with continue activity

@BHUVAN Just an example inside invoke to increase count you can use this Select Case Weekday(startDate,VBMonday) Case 1 If row(“Pattern”).ToString.Contains(“1”) Then in_Count=in_Count+1 End If Case 2 If row(“Pattern”).ToString.Contains(“2”) Then in_Count=in_Count+1 End If Case 3 If row(“Pattern”).ToString.Contains(“6”) Then in_Count=in_Count+1 End If Case 4 If row(“Pattern”).ToString.Contains(“7”) Then in_Count=in_Count+1 End If End Select Hope it helps, Cheers

This post made by @Gokul_Jayakumar received 2 likes!

Having Doubt on string conversion

Hello @Mr.Bug_Maker Try this System.Globalization.CultureInfo.CurrentCulture.TextInfo.ToTitleCase(“Your String”) [image]

Top 3 Most Liked Solutions

This solution provided by @Chirag_Shetty_Divakar received 3 likes!

While loop with continue activity

@BHUVAN Just an example inside invoke to increase count you can use this Select Case Weekday(startDate,VBMonday) Case 1 If row(“Pattern”).ToString.Contains(“1”) Then in_Count=in_Count+1 End If Case 2 If row(“Pattern”).ToString.Contains(“2”) Then in_Count=in_Count+1 End If Case 3 If row(“Pattern”).ToString.Contains(“6”) Then in_Count=in_Count+1 End If Case 4 If row(“Pattern”).ToString.Contains(“7”) Then in_Count=in_Count+1 End If End Select Hope it helps, Cheers

This solution provided by @Gokul_Jayakumar received 2 likes!

Having Doubt on string conversion

Hello @Mr.Bug_Maker Try this System.Globalization.CultureInfo.CurrentCulture.TextInfo.ToTitleCase(“Your String”) [image]

This solution provided by @arjunshenoy received 2 likes!

Compare String1 to String2 (String1=String2)

Hi @swinter1 UiPath is adding the @ symbol before String1 because it is interpreting it as a verbatim string literal. A verbatim string literal starts with the @ symbol and it allows you to include special characters, such as new lines or tabs, in a string without having to escape them. To avoid this, you can use: String1 = String1.TrimStart("@"c) Hope this helps, Best Regards.

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

@Manish540 received 126 likes for their solutions!

@Anil_G received 119 likes for their solutions!

@Chirag_Shetty_Divakar received 81 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.