Forum Engagement Daily Reports

[system]

Daily Forum Report | 16 September 2021

Top 3 Topics with Most Views

Changing the Date Format in a excel column made by @HeartCatcher with 60 views.

How to get specified string from a sentence made by @HeartCatcher with 44 views.

Write Range: two datatable to one Excel made by @Astor with 44 views.

Top 3 Topics with Most Replies

Changing the Date Format in a excel column made by @HeartCatcher with 23 replies.

Order processing queue made by @jlemon with 15 replies.

Splitting a String1 made by @HeartCatcher with 14 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 54 posts!

@ppr made 27 posts!

@lakshman made 27 posts!

Top 3 Most Liked Posts

This post made by @StefanSchnell received 3 likes!

From 32-bit to 64-bit with 2021.8

Hello Studio Developer Team, in the context of my question about dotNET Core Release Support it is also very interesting to know about your plans of x86 and x64 architecture support. As far as I can see supports Windows-net461 only x86 architecture … [image] … and Windows-net5.0 only x64 architecture. [image] Here my code: Console.WriteLine("dotNET version: " + Environment.Version.ToString()); if (Environment.Is64BitProcess == true) { Console.WriteLine("64-bit Architecture"); } else { …

This post made by @ppr received 3 likes!

Changing the Date Format in a excel column

we can do it with followoing activities [grafik] ensure that this is done out side any Excel Application Scopes. Another option could be to do it with a macro executed by UiPath

This post made by @Gopal_Tewari1 received 2 likes!

I cant find users icon on orchestrator

Hi Anders, Now you can find the users inside the Manage Access Options Hope this will resolve your issue . Cheers

Top 3 Most Liked Solutions

This solution provided by @Palaniyappan received 2 likes!

How to get specified string from a sentence

No worries if these value are in each row one after the another then you can pass the datatable to a FOR EACH ROW activity and inside that loop use this assign activity like this Str_output = Split(row(“yourcolumnname”).ToString.Trim,” “)(1).ToString.Trim If all of them are in one cell like if this is a single value with multiple lines it Then the activity used will be —use a assign activity like this Arr_line = Split(str_input.ToString,Environment.Newline.ToArray()) Where arr_line is a …

This solution provided by @Palaniyappan received 2 likes!

Getting the Day Minus one

Hi Hope this expression would help you resolve this If the input is in a string variable named str_input Then in a assign activity str_output = Datetime.ParseExact(str_input.ToString,”dd/MMM/yyyy”,System.Globalization.CultureInfo.InvariantCulture).AddDays(-1).ToString(“yyyyMMdd”) This will give the day -1 as you expect Cheers @HeartCatcher

This solution provided by @Yoichi received 2 likes!

Searching a specific word and getting all the strings in a line with a condition

Hi, Hope the following helps you. [img20210916-5] System.Text.RegularExpressions.Regex.Matches(yourString,"[A-Za-z ]*(University|College)[A-Za-z ]*") Sequence3.xaml (6.8 KB) 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.