Finding values that DO NOT contain specified value

[rmconlon]

Say I have a field called NAME in a table.

The names are

BOB

BOB-A

JOE

JOE-A

BILL

BILL-A

How would I write a script to search for and display only the names that DIDN'T have an "A" at the end??

Help is much appreciated.

Thanks!

[rmconlon]

Say I have a field called NAME in a table.

The names are

BOB

BOB-A

JOE

JOE-A

BILL

BILL-A

How would I write a script to search for and display only the names that DIDN'T have an "A" at the end??

Help is much appreciated.

Thanks!

[rmconlon]

Say I have a field called NAME in a table.

The names are

BOB

BOB-A

JOE

JOE-A

BILL

BILL-A

How would I write a script to search for and display only the names that DIDN'T have an "A" at the end??

Help is much appreciated.

Thanks!

[Vaughan]

It's the "at the end" that's the hard part.

The Omit option is used to pereform NOT finds. So perhaps an omitted reqiest for "*-A" without the quotes might do the trick. If the hyphen gives problems you may need to put quotes aound the hyphen...

*"-"A

[Vaughan]

It's the "at the end" that's the hard part.

The Omit option is used to pereform NOT finds. So perhaps an omitted reqiest for "*-A" without the quotes might do the trick. If the hyphen gives problems you may need to put quotes aound the hyphen...

*"-"A

[Vaughan]

It's the "at the end" that's the hard part.

The Omit option is used to pereform NOT finds. So perhaps an omitted reqiest for "*-A" without the quotes might do the trick. If the hyphen gives problems you may need to put quotes aound the hyphen...

*"-"A

[kevh72]

Another option would be to create a 2nd field. The first field would simply have the name, the 2nd would specify the "A" if necessary. Now, when you do a search, you can search for names in the first field, and omit all finds for "A" in the 2nd field.

To display all names with or without the "A", create a calc field that joins them both.

[kevh72]

Another option would be to create a 2nd field. The first field would simply have the name, the 2nd would specify the "A" if necessary. Now, when you do a search, you can search for names in the first field, and omit all finds for "A" in the 2nd field.

To display all names with or without the "A", create a calc field that joins them both.

[kevh72]

Another option would be to create a 2nd field. The first field would simply have the name, the 2nd would specify the "A" if necessary. Now, when you do a search, you can search for names in the first field, and omit all finds for "A" in the 2nd field.

To display all names with or without the "A", create a calc field that joins them both.

[rmconlon]

Thanks!

It actually worked best by running a simple loop. I did a find for all of the names,

then..

Go to First Record

If (Right(Name;2)="-A")

Then Omit Record

Go to Next Record ; Exit after last.

Basically trimmed out records I didn't need.

Thanks for everyones help

[rmconlon]

Thanks!

It actually worked best by running a simple loop. I did a find for all of the names,

then..

Go to First Record

If (Right(Name;2)="-A")

Then Omit Record

Go to Next Record ; Exit after last.

Basically trimmed out records I didn't need.

Thanks for everyones help

[rmconlon]

Thanks!

It actually worked best by running a simple loop. I did a find for all of the names,

then..

Go to First Record

If (Right(Name;2)="-A")

Then Omit Record

Go to Next Record ; Exit after last.

Basically trimmed out records I didn't need.

Thanks for everyones help