Forum Engagement Daily Reports

[system]

Daily Forum Report | 08 October 2023

Top 3 Topics with Most Views

UiPath Assistant - System.Threading.Tasks.TaskCanceledException: “The request was canceled due to the configured HttpClient.Timeout of 30 seconds elapsing.” made by @mukarramahsen with 48 views.

Find and replace 0 with 1 in an excel file, the activity replaces all the occurrences of 0 made by @sharad.bodke with 35 views.

Excel automation query( need linq code as the data is huge ) made by @Suthari_RohithReddy with 34 views.

Top 3 Topics with Most Replies

Use Case __01 made by @Gokul_Murali with 20 replies.

UiPath Assistant - System.Threading.Tasks.TaskCanceledException: “The request was canceled due to the configured HttpClient.Timeout of 30 seconds elapsing.” made by @mukarramahsen with 15 replies.

Get data against row value in excel using Linq made by @c3f1e68294fdcf4a1f0a817ca with 14 replies.

Top 3 Users Who Posted The Most

@Anil_G made 15 posts!

@supriya117 made 14 posts!

@c3f1e68294fdcf4a1f0a817ca made 13 posts!

Top 3 Most Liked Posts

This post made by @rishiathawale received 1 likes!

Get details from text

Hi All, I want to convert the below text to table or wanted to extract data thru regex. MAA Distri Cal Distribution DST # Account # Ticker CUT # Fund Paid Outstanding Rate/Share 9307 745336 MJAWE 83681P531 Callcal Term Miti Prop 2,485,126.08 74,193,631.799 0.03349514 1st row is heading 2nd is header 3rd is values This text is extrated from pdf.

This post made by @Gokul_Murali received 1 likes!

Use Case __01

Hello guys i have a use case. [MicrosoftTeams-image (18)] step 1: I want to check first row in section column if its 910216 it should take corresponding “SI Lc” amount in the same row. Step 2 : it should check the 2 nd row whether same 910216 repeating and the Risk ID is “2” if the Risk ID is 2 and the value 910216 Repeats It should take the Corresponding "SI Lc " Amount. Note : Here there will be around 50 Rows, Some time the value “910216” will in the 50th Row of Section column. Que…

This post made by @lrtetala received 1 likes!

Find and replace 0 with 1 in an excel file, the activity replaces all the occurrences of 0

Hi @sharad.bodke You can try like this [image] Note: Check the Match entire cell contents property I/P: [image] O/P: [image] Hope this helps!!

Top 3 Most Liked Solutions

This solution provided by @lrtetala received 1 likes!

Find and replace 0 with 1 in an excel file, the activity replaces all the occurrences of 0

Hi @sharad.bodke You can try like this [image] Note: Check the Match entire cell contents property I/P: [image] O/P: [image] Hope this helps!!

---

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.