Forum Engagement Daily Reports

[system]

Daily Forum Report | 30 May 2024

Top 3 Topics with Most Views

How to Read an Email Inside Another Email and Extract Attachments Using UiPath made by @burcine with 54 views.

How to write wildcard in use application/browser made by @xiangyun.koh with 52 views.

Facing issue with datable while converting converting from windows legacy to windows made by @Farooq_Syeda with 47 views.

Top 3 Topics with Most Replies

Change format date excel made by @Stef_99 with 17 replies.

Facing issue with datable while converting converting from windows legacy to windows made by @Farooq_Syeda with 13 replies.

Can not assign 'Split(OutDates(0).tostring.trim, Environment.NewLine()) made by @Farooq_Syeda with 13 replies.

Top 3 Users Who Posted The Most

@Anil_G made 41 posts!

@postwick made 30 posts!

@ashokkarale made 25 posts!

Top 3 Most Liked Posts

This post made by @lrtetala received 2 likes!

Data Table columns to clip board

Hi @A_Learner Try this String.Join(Environment.NewLine, dt.AsEnumerable().Select(Function(row) row("YourColumnName").ToString())) [image] Regards,

This post made by @A_Learner received 2 likes!

Data Table columns to clip board

Worked great! Thank you @lrtetala

This post made by @marquezd received 2 likes!

GET NUMBER OF ROW

Tnks both of you, it works with the solutions

Top 3 Most Liked Solutions

This solution provided by @lrtetala received 2 likes!

Data Table columns to clip board

Hi @A_Learner Try this String.Join(Environment.NewLine, dt.AsEnumerable().Select(Function(row) row("YourColumnName").ToString())) [image] Regards,

This solution provided by @Parvathy received 1 likes!

Change format date excel

Hi @Stef_99 => Read Range Workbook. Output → dt [image] => For Each Row in DataTable dt Assign: CurrentRow("Planned Start") = DateTime.ParseExact(CurrentRow("Planned Start").ToString,{"dd/MM/yyyy HH:mm:ss","d/M/yyyy HH:mm"},System.Globalization.CultureInfo.InvariantCulture,System.Globalization.DateTimeStyles.None).ToString("dd/MM/yyyy HH:mm:ss") => Write Range Workbook dt back to excel. Enable Add Headers option. Output: [image] [image] Regards

This solution provided by @Yoichi received 1 likes!

Facing issue with datable while converting converting from windows legacy to windows

This is cause of this error. If it’s not what you expected value, it’s necessary to find reason the datatable is null. 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.