Removing any Row with "/" character in specific column .

staceygreene

I was wondering if anyone could help me remove any row with "/" character in a column. For example :

Name      state  code

chase       nc      8586

rob            ga      12/4/

sam           nc       5/5

Not exact data just example ...I would want to remove the row with 12/4/ & 5/5 and any other like it. 

DataNath

Hey @staceygreene, if you put a Filter tool on your canvas and use the following expression:

!Contains([code],'/')

The records you want i.e. those without a '/', will come out of the top (True) anchor. Hope this helps!