Jump to content

Finding text as partial part of longer string


This topic is 2338 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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.

 

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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 by doughemi
Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 2338 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.