Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

Need help with Finding the first letter of a name, only


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

Recommended Posts

Posted

I thought I this was going to be an easy task but nooooooooooo...

How do I script a Find request where FM looks for the first character only of a company name in a text field? I want to find, say, all the companies beginning with the letter, 'C'.

TIA for your help!

Posted (edited)

Try:

==C*

---

Note that this an "unindexed" search - if you want to make it faster, define a calculation field returning the first character and search there instead.

Edited by Guest
Posted

Note that this an "unindexed" search - if you want to make it faster, define a calculation field returning the first character and search there instead.

Ah! Great idea. Thanks again!

Posted

I made a quick sample file of a technique I have used. This was inspired by a version 3 file by Don Wieland, AlphaJump and updated when version 7 came out by someone, using one script, and Script Parameters, I think it was Matt Petrowsky.

If I'm in error of the second credit, please let me know.

Lee

AlphaButtons.fp7.zip

Posted (edited)

How could this be indexed?

??

How could calculating the first character of an indexed field present an indexing problem?

AlphaButtons.fp7.zip

Edited by Guest
Posted

No one said that.

?? YOU said that.

What exactly is the indexing problem you perceive here? Like bcooney, I just don't know where this perceived indexing problem could come from.

Posted

It's your same issue of not reading what is said, Bruce. If you are going to say that Comment said something, quote him. Because he did NOT say that at all. Re-read it.

Posted

Can you please elaborate, comment? I would like to better understand why creating a calc field that contains just the first letter of a field would perform better (via its index) than a company name field (which I assume is indexed--or will be as soon as a find is performed).

Posted

The company field will be indexed, but some types of searches cannot use the index. An exact match is one of those, and a wild card is another - here you have both.

Posted

but some types of searches cannot use the index. An exact match is one of those,

Could possibly be true, but could you lead me to sources explaining this?

--sd

Posted

Well, I'm afraid I'm taking comment at his word. A field that contains only a letter will generate a corresponding index, and a whole word index wouldn't be helpful in this scenario. I would like to read a more in depth description of indexing, also.

Posted

I'm afraid I'm taking comment at his word.

One could usually as a practical approach, only it isn't particular socratic. Well my gray matters are honestly slow as molases in these days, and I havn't yet realized to depth to his statement.

I can't help thinking of this:

We are a culture without the will to seriously examine our own problems. We eschew that which is complex, contradictory or confusing. As a culture, we seek simple solutions. We enjoy being provoked and titillated, but resist the rigorous, painstaking examination of issues that might, in the end, bring us to the point of recognizing our problems, which is the essential first step to solving any of them.

...it's not the best approach to learning, to remember all the exceptions by heart.

--sd

This topic is 5609 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.