How to filter rоws in date table ......?

[radoslav.spasov]

Hello,

How can I filter only the rows that contain exactly 15 characters(in blue arrows) ???

[ppr (Peter Preuss)]

Four Ways to Filter Data Tables in UiPath Studio | UiPath

Assign Activity
dtFiltered =

(From d in dtDataVar.AsEnumerable
Where d(0).toString.Trim.Length.Equals(15)
Select r = d).CopytoDataTable

handling empty result:

[FirstAid] Handling of The source contains no DataRows exception

This FirstAid Tutorial will describe how a the source contains no DataRows EXCEPTION can be handled. Introduction Let’s have a look at the following filter data table scenario: Name CCode Tom US Charlotte FR Seema IN Jean FR Assignment: Filter all rows on a particular Country Code like FR, UK, ES, UK… Ensure that all CCode data column values are trimmed Ensure that the Filter check is case insensitive we can implement it e.g. with the help of a LINQ statement: dtData.AsE…

[radoslav.spasov]

“d” = Column name or ?
and “r” = ?

[ppr (Peter Preuss)]

d / r a acting like local variables referencing the looped row

[HowTo] - First Start with LINQ (VB.Net)

LINQ is part of the .NET framework and offers capabilities for interacting with data, objects or other sources within a particular syntax. This HowTo introduces on starting with LINQ (Language-Integrated Query). Current Version of this topic is DRAFT and will be finalized / enhanced soon Introduction Typical tasks for implementing parts of an automation project are interacting with e.g. with data in a datatable or items from collections. LINQ can help to implement it into a compact and standa…

[radoslav.spasov]

@ppr

d / r a acting like local variables referencing the looped row

Shouldn’t the column name be specified somewhere?

[ppr (Peter Preuss)]

@radoslav.spasov

Shouldn’t the column name be specified somewhere?

we recommend to check if some courses e.g UiPath Academy will help for the basics

we used the access by column index and can use also column name.

(From d in dtDataVar.AsEnumerable
Where d("Column-0").toString.Trim.Length.Equals(15)
Select r = d).CopytoDataTable

[radoslav.spasov]

Thanks, it worked !!!

[ppr (Peter Preuss)]

@radoslav.spasov
Perfect so the topic can be closed

Forum FAQ - How to mark a post as a solution

Forum FAQ - How to mark a post as a solution This document is part of our beginners guide. This article will teach you how to properly mark a post as a solution. We were closely following our last UiPath Forum feedback round! topic and carefully extracted all the bits of feedback that was provided. As such, we would like to tackle the topic of solutions on our Forum and how to properly use them. When is the topic resolved? The topic can be considered resolved when the topic author has found…