Forum Engagement Daily Reports

[system]

Daily Forum Report | 15 February 2024

Top 3 Topics with Most Views

How to send an outlook mail in UiPath made by @naveen5 with 66 views.

Delete values except the particular word from a column in excel made by @yashashwini2322 with 47 views.

Eliminar datos nulos o con "," made by @jorge_morales with 42 views.

Top 3 Topics with Most Replies

Regex- extracting data from text file made by @abivanth.r with 26 replies.

Delete values except the particular word from a column in excel made by @yashashwini2322 with 24 replies.

How to send an outlook mail in UiPath made by @naveen5 with 22 replies.

Top 3 Users Who Posted The Most

@Happydayyy made 22 posts!

@vrdabberu made 22 posts!

@rlgandu made 19 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 2 likes!

Replace word in variable

Hi, FYI, another approach: If you use StudioX, ModifyText activity works as the following. [image] Regards,

This post made by @Jon_Smith received 2 likes!

ComputerVision is amazing

In a previous role I had to build a robot, which meant I had to open a Citrix VM and then interact with a Citrix hosted app… I was furious at the sales team for not properly determining the complexity and over promising, I did eventually make a stable solution, but only because CV saved my ass. I did actually even get the UiPath remote Runtime installed all the way down, the application still didnt have full selectors cause it was that bad.

This post made by @Shyam_Pragash received 2 likes!

Downloading File using Chrome giving error

You can also whitelist entire websites via Chrome’s settings: Settings > Security and Privacy > Site Settings > Insecure Content. Under Allowed to show insecure content click “Add” and enter the main website URL and click “Add”. Issue Solved

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

How to save the excel file as other file

Hi, If you want to the file named AppNum, can you try to add “.xlsx” as the following in MoveFile activity? "D:\User\Desktop\RPA_Tier2\Completed"+"\"+AppNum+".xlsx" Or if you want to move the file in AppNum folder, can you try to create the folder in advance? [image] Regards,

This solution provided by @Yoichi received 1 likes!

Wrong format of decimal numbers when reading csv - possibly bug

Hi, Which WriteRange activity do you use? At least, WriteRangeWorkbook seems to work well. How about using this? Regards,

This solution provided by @ppr received 1 likes!

For each excel row from bottom up

Based on your inputs a regex could look like this: [grafik] with refering to Groups: [grafik] And above suggestion just need a small adaption Assign Activitiy dtResult = dtDataClone Assign Activity dtResult = (From d in dtData.AsEnumerable Let mts = System.Text.RegularExpressions.Regex.Matches(d("Items").toString, "([A-Z]) (\d+)") From m in mts.Cast(Of Match) Let ra = new Object(){d("ID"), m.Groups(1).Value, m.Groups(2).Value } Select r = dtResult.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.