Finding what ISN'T there

[Bekah]

Silly. I hvae text field (CHANGE). This was old audit list from another program. I am trying to find all lines without anything on the right of the dash.

Finding for "(space)-"

But it finds everything. ==*- ... finds half of them, some with text to the right of dash and some without??

And sometimes there is a second dash (eevn with a space on each side) to the right of the 'dash' separator. I think I might need calc to somehow specify nothing on the right of FIRST dash. Everything I have tried fails. I am attaching this file with some records in hopes of getting help.

I want to delete all records with fieldname and dash and nothing else in the field. Like the third record Comments -

Thank you.

Change.zip

[-Queue-]

How about a calculated number field: Right( History 2:Change; 1 ) = "-" ?

[Bekah]

Queue to the rescue!!! Bam gone! I'm proud of myself for seeing it would produce a 1 boolean when I read it. I tried text formulas but kept starting from the left.

Thank you so much for helping. I've have spent my weekend on it. now I can play and rest a bit instead.