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!

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!

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!

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

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

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

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.

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.

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.

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

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

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