Removing data Assisstance?

[SahilArora3139]

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

[binuacs · Accepted solution]

@SahilArora3139 In the filter tool add the condition

!Contains([Name],'$')

[SahilArora3139]

thank you so much

[SahilArora3139]

Just one small thing, if i want to segregate pattern having $ sign at the end only then it will work the same?

like

A$
$A 

A

so $A is acceptable andhence  A and $A should be the output

only the name having dollr in end needs to be excluded 

[binuacs · Accepted solution]

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