How to Find Start with A rows in Excel

Help Orchestrator
,
1

I have a Excel sheet 1, i want to find start with A rows to store in sheet2.

Can you please suggest me
thank you

2

@jaranrikki_17

share the input and expected output.

3

@jaranrikki_17

if you want to check for particular column use this

dt.asenumerable.where(function(r) r(“columnName”).tostring.startswith(“A”)).copytodatatble

to check all the row values use this

dt.asenumerable.where(function(r) r.itemarray.any(function(a) a.tostring.startswith(“A”))).copytodatatble

1 Like
4

Did u try with Balareva excel activity from marketplace
Here is an activity called “Find”. it will return the cell info and row index as an array. So the last element is the last index.

@jaranrikki_17

5

Example:

image

6

@jaranrikki_17

Try this Linq

(
From row In DT
Let a = If(row("Column Name").tostring.startswith("A"),"Yes","No")
Select DT2.Rows.Add(row("Column Name"),a)
).copytodatatable
7

image
image765×390 11.2 KB

refer the above post or use the below query

dt.AsEnumerable.Where(Function(r) r(0).ToString.StartsWith(“A”)).CopyToDataTable

1 Like
8

@Shiva_Nikhil

I have tried this linq query but getting some error

9

Hi @jaranrikki_17

Try this

image
image652×512 18.4 KB

Code:

(From row In DT1.AsEnumerable()
              Let name = row.Field(Of String)("ColumnName")
              Where name.StartsWith("A", StringComparison.OrdinalIgnoreCase)
              Select row).CopyToDataTable()

I/P:
image
O/P:
image

Hope this helps!!

1 Like
10

@jaranrikki_17

can you share the error screenshot

with the sample input i have excuted

image
image793×249 4.42 KB

if you are copying and pasting the code you will get error,

if so please type the code and check once

1 Like
11

@Dilli_Reddy
yeah its working thank you.

1 Like
12

Thank for the reply @Shiva_Nikhil @lrtetala @Palaniyappan

2 Likes
13

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.