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 · Accepted solution]

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!

[JosephSerpis]

Hi @staceygreene you can use a filter tool to remove any row if / are in one column. I have mocked up an approach which will filter any row that has / in any column in your data in case / are in more than one column.