Forum Engagement Daily Reports

[system]

Daily Forum Report | 15 May 2023

Top 3 Topics with Most Views

String manipulation using split function made by @RAKESH_KUMAR_Tiwari with 57 views.

Want to Compare two excel file and fill the data into this excel file but the Problem is Headings are Dynamic from one row to another how to overcome this made by @Gopikrishna_S with 55 views.

How to use LINQ different data table made by @miftah with 51 views.

Top 3 Topics with Most Replies

String manipulation using split function made by @RAKESH_KUMAR_Tiwari with 25 replies.

How do you Assign Multiple Variables from a Data Table? made by @jdavis7 with 16 replies.

Dynamic String Manipulation - Required help made by @Swetha_V with 14 replies.

Top 3 Users Who Posted The Most

@Anil_G made 63 posts!

@Yoichi made 24 posts!

@LAKSHMI_NARAYANA_PEMMASAN made 23 posts!

Top 3 Most Liked Posts

This post made by @pavithra_pavi received 4 likes!

How to initialize queueitemm and assign value

Hi @gopal_ram , please try below logic TransactionItem = new QueueItem() TransactionItem.SpecificContent = New Dictionary(Of String, Object)() From {{"<your queueitem field","its value"}} NOTE : TransactionItem is of type queueitem **example : ** [image]

This post made by @pavithra_pavi received 2 likes!

Remove rows from DT which have date later than a provide date

Hello @TyraS , Try below logic. Hope it helps (From p In dt.Select() Where (From q In dt.Select() Where DateTime.ParseExact(q("Column1").tostring,"ddMMyyyy",System.Globalization.CultureInfo.InvariantCulture)<(DateTime.ParseExact(p("Column1").tostring,"ddMMyyyy",System.Globalization.CultureInfo.InvariantCulture)) Select q).toArray.count>1 Select p).ToArray.copyTodatatable() **NOTE : ** dt : is variable of type datatable “Column1” : is your date column

This post made by @arisarnado received 1 likes!

How to Use ComputerVision and OCR in an offline environment

Background: We are currently trying to use ComputerVision and OCR in an offline environment (not connected to Orchestrator). We tried to use the following guide but we were not able to make it work: UiPath version: 2022.10.07 (Enterprise License) Questions: Are there missing steps in the guide above? Is there a separate guide for setting up offline OCR?

Top 3 Most Liked Solutions

This solution provided by @pavithra_pavi received 4 likes!

How to initialize queueitemm and assign value

Hi @gopal_ram , please try below logic TransactionItem = new QueueItem() TransactionItem.SpecificContent = New Dictionary(Of String, Object)() From {{"<your queueitem field","its value"}} NOTE : TransactionItem is of type queueitem **example : ** [image]

This solution provided by @arjunshenoy received 1 likes!

Input string was not in a correct format -Get text activity

Hi @Paddi The error occurs in Activity 4 because the grant variable might not always contain a valid integer value. This issue can arise if the regular expression pattern doesn’t match any digits or if there are leading or trailing whitespaces in the extracted value. Try this to tackle the issue: For Activity 3 → Assign grant = System.Text.RegularExpressions.Regex.Match(page, "\d+(?=page)").Value.Trim() Before proceeding with the Activity 4, use an If condition to check the RegEx outcome: …

This solution provided by @ppr received 1 likes!

Error converting Int to String with LINQ

with the Field method and to String it is double converted, give a try at: DT.AsEnumerable().GroupBy(Function(r) r("Column A value").toString.ToUpper.Trim).Select(Function(s) s.First()).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.