Forum Engagement Daily Reports

[system]

Daily Forum Report | 28 January 2024

Top 3 Topics with Most Views

Deleting Empty Rows Using LINQ Cast Function made by @NILESH.BOT369 with 41 views.

Challenges in Inserting Image Paths into a Specific Excel Column Using Queue Items made by @sasadrinksprite with 40 views.

Element Exists true issue made by @A_Learner with 35 views.

Top 3 Topics with Most Replies

Please help in http returns nothing made by @Anelisa_Bolosha1 with 19 replies.

Webpage - Find Text (from Excel) and click the button next to it made by @Jenny_Ye1 with 13 replies.

Retrieving and Matching File Paths made by @sasadrinksprite with 11 replies.

Top 3 Users Who Posted The Most

@mkankatala made 22 posts!

@vrdabberu made 11 posts!

@Anil_G made 8 posts!

Top 3 Most Liked Posts

This post made by @mkankatala received 2 likes!

How to extract substrings from a string using regular expressions

Hi @kavya_mamidishetti - Variable1 = System.Text.RegularExpressions.Regex.Match(Input,"^[\w\s]+(?=\s+\d+\/\d+\/\d+)").Value - Variable2 = System.Text.RegularExpressions.Regex.Match(Input,"(\d+\/\d+\/\d+)").Value - Variable3 = System.Text.RegularExpressions.Regex.Match(Input,"(?<=\d+\/\d+\/\d+\s+)\d+").Value - Variable4 = System.Text.RegularExpressions.Regex.Match(Input,"(?<=\d+\/\d+\/\d+\s+\d+\s+)\(?\$+\d+\.?\d+\)?").Value - Variable5 = System.Text.RegularExpressions.Regex.Match(Input,"(?<=\(?\…

This post made by @mkankatala received 2 likes!

Please help in http returns nothing

Hi @Anelisa_Bolosha1 May be this is the issue * Request URL - The URL to which you want to make the request. Custom segments have to be placed between braces “{}” and defined in the Parameters section. For example, this URL https://platform.uipath.com/odata/Robots(28) can be written as https://platform.uipath.com/odata/Robots{id}, and the value of the id parameter can be provided in the URLSegments window. Check the below documentation to know more about HTTP request activity. Hope it helps!…

This post made by @Yoichi received 2 likes!

How to extract substrings from a string using regular expressions

Hi, Can you try the following sample using Regex.Group? This sample output not only each value but also excel table. [image] mc = System.Text.RegularExpressions.Regex.Matches(strData,"(?<=^|\n)(?<STATUS>.*?)\s+(?<DATE>\d+/\d+/\d+)\s+(?<ID>\d+)\s+(?<AMOUNT>\S+)\s+(?<NUMBER>\d+)\s+(?<NOTE>.*)") Then we can access each value like m.Groups("DATE").Value [image] Sample Sample20240128-1.zip (7.9 KB) Regards,

Top 3 Most Liked Solutions

This solution provided by @vrdabberu received 1 likes!

'Then' and 'Else' position inverted in IF activity

Hi @Gwen When using the 22.10.4 version it’s better to upgrade all the packages to the latest version and keep the runtime rule as Lowest Applicable Version. So, that it will take the packages compatible with that version. [image] Regards

This solution provided by @lrtetala received 1 likes!

How do I copy hyperlinks from one excel sheet to another?

Hi @David_Hernandez2 How about the following? [image] Input Excel: [image] Output Excel: [image] Regards,

This solution provided by @ppr received 1 likes!

Writing Dataset.table to excel in specific format

looks like you want to transform a DataTable with 1 row into a Key, Value Structure Build DataTable Activity: - dtKVData Col1: - Name: Key , DataType: String Col2: - Name: Value, DataType: Object Assign Activity dtKVData = (From d in dataset.table(0).AsEnumerable From c in dataset.table(0).Columns.Cast(Of DataColumn) let ra = new Object(){c.ColumnName, d(c.ColumnName)} Select r = dtKVData.Rows.Add(ra)).CopyToDataTable

---

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.