Removing data Assisstance?

Question

hi all

can someone help me what should be done for this situation:

s.no.    Name   Address

1.         A$.      NY

2.         A.         UK

3.         C$.       CA

i want to remove the data having dollar($) in Name column.

output should be:

2.    A.     UK

others two should not be there as it have dollar sign in Name column .

please help

binu_acs · Accepted Answer

@SahilArora3139 In the filter tool add the condition

!Contains([Name],'$')

binu_acs · Accepted Answer

@SahilArora3139 In that case use the !EndWith() function in the filter tool