Forum Engagement Daily Reports

[system]

Daily Forum Report | 30 July 2023

Top 3 Topics with Most Views

Take screenshot send mail made by @suraj_gaikwad with 41 views.

Write list of integers into excel horizontally made by @Joecom101 with 31 views.

Vba entry paramyer value for a vba code made by @Demo_User with 31 views.

Top 3 Topics with Most Replies

Reduce Fetched Data after API Input made by @Hugen_Dugen with 30 replies.

Fetching just a particular part of a json row made by @Hugen_Dugen with 26 replies.

Take screenshot send mail made by @suraj_gaikwad with 24 replies.

Top 3 Users Who Posted The Most

@lrtetala made 41 posts!

@Hugen_Dugen made 19 posts!

@Anil_G made 18 posts!

Top 3 Most Liked Posts

This post made by @ppr received 2 likes!

How to sum and average the whole column

When the localization plays a role (dot is group seperator) we can do Int32.Parse(YourString, System.Globalization.CultureInfo.CreateSpecificCulture("tr-TR")) Double.Parse(YourString, System.Globalization.CultureInfo.CreateSpecificCulture("tr-TR"))

This post made by @Parvathy received 2 likes!

How to Remove a Newline from an Excel cell using UiPath

Hi @tmcwade12 Use “Read Range WorkBook” activity and read the excel and store it in an data table say dtExcel. Use “For Each Row in Data Table” activity to iterate through each row in excel. Use the below two syntax in assign activity: CurrentRow("Departure Time")= CurrentRow("Departure Time").ToString.Replace(vbLf, " ").Replace(vbCr, "") CurrentRow("Arrival Time")= CurrentRow("Arrival Time").ToString.Replace(vbLf, " ").Replace(vbCr, "") Use “Write Range Workbook” activity to write the dat…

This post made by @lrtetala received 2 likes!

How to Remove a Newline from an Excel cell using UiPath

Hi @tmcwade12 Try this Input.ReplaceLineEndings(" ") [image] I hope it helps!!

Top 3 Most Liked Solutions

This solution provided by @Parvathy received 2 likes!

How to Remove a Newline from an Excel cell using UiPath

Hi @tmcwade12 Use “Read Range WorkBook” activity and read the excel and store it in an data table say dtExcel. Use “For Each Row in Data Table” activity to iterate through each row in excel. Use the below two syntax in assign activity: CurrentRow("Departure Time")= CurrentRow("Departure Time").ToString.Replace(vbLf, " ").Replace(vbCr, "") CurrentRow("Arrival Time")= CurrentRow("Arrival Time").ToString.Replace(vbLf, " ").Replace(vbCr, "") Use “Write Range Workbook” activity to write the dat…

This solution provided by @supermanPunch received 1 likes!

Write list of integers into excel horizontally

Hi @Joecom101 , You could also maybe check with the below Expression : DT = (From i In Enumerable.Range(0,CInt(integerList.Count/4)).Select(Function(x)x*4).ToArray Let ra = integerList.Skip(i).Take(4).Cast(Of Object).ToArray Select dt.Clone.Rows.Add(ra)).CopyToDatatable Implementation : [image] Debug Visuals : [image]

This solution provided by @lrtetala received 1 likes!

How to sum and average the whole column

Hi @emir_ozsimsir Please find below xaml for your reference BlankProcess5.zip (164.0 KB) O/P Excel: FORD.xlsx (14.2 KB) I hope it 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.