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
Solved! Go to Solution.
@SahilArora3139 In the filter tool add the condition
!Contains([Name],'$')
thank you so much
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