I have an Excel file with a column labeled 'Employee ID,' which contains employee IDs. I want to delete the rows where the employee ID starts with the number 1

Help Forum
,
1

If the employee ID starts with the number 1, delete the row otherwise, continue with the next row.

image

2

Hi @Mohammad_Rizwan_03

dt.AsEnumerable().Where(Function(row) Not row("Employee ID").ToString.StartsWith("1")).CopyToDataTable()

Regards,

3

@Mohammad_Rizwan_03

Another approach try with Filter Data Table activity

The image displays a UiPath workflow that reads an Excel file, filters a data table, converts the filtered data table to text, and displays it in a message box. (Captioned by AI)
The image displays a UiPath workflow that reads an Excel file, filters a data table, converts the filtered data table to text, and displays it in a message box. (Captioned by AI)930×683 27 KB

The Filter Wizard in a software interface is configured to remove rows from the input DataTable "DT" where the "Employee ID" column starts with the value "1". (Captioned by AI)
The Filter Wizard in a software interface is configured to remove rows from the input DataTable "DT" where the "Employee ID" column starts with the value "1". (Captioned by AI)782×497 16.4 KB

Input:

A spreadsheet displays a table with two columns labeled "Name" and "Employee ID," containing various entries. (Captioned by AI)

Regards,

1 Like
4

@lrtetala Thank you for the prompt response and solution.

1 Like
5

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