How to get Data from data table that starts with letter "E"

filter “Assignment Number” column with values starting with letter “E” inside fore each Row

Can someone help how to Get it properly.
i think my code is not correct.
image

My Excel
image

Thank you in advance

Hi,

Can you try to use StartsWith method instead of Contains, as the following?

roaster.Item(24).ToString().StartsWith("E")

or

We can use FilterDataTable activity in advance as the following.

img20210925-2

Regards,

1 Like

@Vincent_Nuestro

Try below expression.

    roaster.Item(24).ToString.Trim.StartsWith("E")
1 Like

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