This seems so basic, not sure why it is not working.

I am searching a database of campaign contributions, the candidate uses several variations.

One is People for Jenny Durkan, another is JennyDurkanforSeattle.

When I search "Durkan" it finds People for Jenny Durkan but not JennyDurkanforSeattle.

FM Help says to use double quotes, what am I not understanding?

I am using version 11 on the Mac.

Thanks for your help.

 

Hi FM,

Do you have a field for each part of the name, it sounds like you do?

How many records are involved? You can do some searches of sort to see.

Depending on the number of records will dictate how you will need to approach it.

There is no operator that I know of that will find the last name in field data like  "JennyDurkanforSeattle"

Here is what I would do. Using the table view,  sort the records on the Last Name Field (or do a find for = operator in the field).

This will place all of the records that are empty at the top of the list. Or provide you with a found set with empty Last Names. 

If it is only a few records, I would just cut and past the data.

If it is a lot of data, let us know and maybe we can suggest another way.

If this is a manual entry err, you can prevent it for happening in the future by using a validation to prevent committing the record until they have enter something in those fields.

HTH

Lee

Try adding a calculation field with the calculation

If(PatternCount(YourField; "Durkan");"Durkan"; "")

Repeat as necessary for other candidates. 

EDIT: Note that PatternCount is not case sensitive so it will also find occurrences of "durkan".

Edited November 3, 20178 yr by doughemi

Try using a wildcard: *Durkan

I think that I stated my question quite poorly, because I received some very complicated answers for simple problem.

But I still appreciate the time and trouble of the responses.

I was trying to execute a find for a text string Durkan in a single field.

Possibles:

Durkan

JennyDurkanforSeattle

People for Jenny Durkan

Turns out the answer is wrapping Durkan in asterisks.

Thanks everyone.