Newbies ChuckO Posted January 28, 2003 Newbies Posted January 28, 2003 I have a field called CompanyName. I'm trying to write a script so that I can find all Records that begin with a certain letter. All I've been able to figure out is to do a Find on words that begin with a certain letter. If I do that, the company ABC Cans will appear in a search for A and C. Is there a way to do a search based on the first letter (of the first word)of a company name?
Jazz Posted January 28, 2003 Posted January 28, 2003 In the find field type "==a*" (without the quotes) to find all starting with 'a'. The "==" says do an exact match (but case insensitive), and the "a*" says 'a' followed by anything. John
Lee Smith Posted January 28, 2003 Posted January 28, 2003 Hi Chuck, I have adapted a file by Don Wieland called AlphaJump that does this pretty good, and there is a very similar file called Alphabet Filter by John Mark Osborne. These files can be downloaded directly form their sites: "AlphaJump" at www.dwdataconcepts.com "Alphabet Filter" www.databasepros.com HTH Lee
jasonwood Posted January 28, 2003 Posted January 28, 2003 I haven't used wildcards much so I could be wrong, but I seem to recall that they take extra time to find... You might also consider adding a new calculation field that is simply = Left(CompanyName, 1) This field will contain the first letter of the company name, so you can simply perform a find in this field.
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now