Forum Engagement Daily Reports

[system]

Daily Forum Report | 06 September 2022

Top 3 Topics with Most Views

Add header row to top of existing data datatable made by @Jcircuit13 with 46 views.

Advanced RPA Certification Question made by @sainandini.mannava with 45 views.

Cannot publish library with flowchart activity used made by @kaydine.santuyo with 43 views.

Top 3 Topics with Most Replies

Merge multiple rows in one made by @ravindar.singh with 17 replies.

Assign - the source contains no data row - problem with extracting data from empty datatable made by @Olivera_Kalinic with 17 replies.

How to add key & value to the dictionary from the text file? made by @jamunatj with 16 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 38 posts!

@Sanjit_Pal made 21 posts!

@Shubham_Dutta made 21 posts!

Top 3 Most Liked Posts

This post made by @ppr received 3 likes!

How to add key & value to the dictionary from the text file?

@jamunatj [grafik] Feel free to decompose the oneliner to part steps File.ReadAllLines(strFilePath) .Skip(1) .Where(Function (x) Not String.IsNullorEmpty(x.Trim)) .Select(Function (x) Regex.Split(x.Trim,"\s{2,}")) .toDictionary(Function (x) x.First(),Function (x) x.Last())

This post made by @qbrandon received 2 likes!

UiPathのアクティビティではどのようなVB.NET Codeが実行されるか確認できないでしょうか？

恐れ入りますがUiPathのオフィシャルなActivityのソースコードは基本非公開です。 マーケットプレースのパッケージは物によってgithubで公開されているコードがたまにあります。 ちなみに、ほとんどのアクティビティがC#で実装されています。

This post made by @Yoichi received 2 likes!

Regex Help Is not Match

Hi, How about using Regex.Replace as the following? System.Text.RegularExpressions.Regex.Replace(yourString,"(?<=\r\n)(.+?)(?= \d{4,5} (?:[\w]+: |Documents))(?:[^a-zA-Z]+)([^\s]+)\s(.+)(?= [A-Z0-9]+ /) (.+)(?=/ \d{2}/\d{2}/\d{4})(?:.*)(?<=\d{2}:\d{2}:\d{2}\s)([\d]+)","") Regards,

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

Regex Help Is not Match

Hi, How about using Regex.Replace as the following? System.Text.RegularExpressions.Regex.Replace(yourString,"(?<=\r\n)(.+?)(?= \d{4,5} (?:[\w]+: |Documents))(?:[^a-zA-Z]+)([^\s]+)\s(.+)(?= [A-Z0-9]+ /) (.+)(?=/ \d{2}/\d{2}/\d{4})(?:.*)(?<=\d{2}:\d{2}:\d{2}\s)([\d]+)","") Regards,

This solution provided by @ppr received 2 likes!

Regex to filter on first occurrence of 3 or 4 digits in a sting

ok bold did mislead us [grafik]

This solution provided by @Gokul001 received 2 likes!

Merge multiple rows in one

HI @ravindar.singh How about this expression? (From d In BuildDT.AsEnumerable Group d By k=d("Booking No").toString.Trim Into grp = Group Let nj = String.Join(" ",grp.Select(Function (n) n("Leading passenger 1").toString.Trim)) Let ra = New Object(){k,grp.First()(1),grp.First()(2),nj,grp.First()(4)} Select r = DtOutput.Rows.Add(ra)).CopyToDataTable Regards Gokul

---

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.