How about, enter find mode (ctrl + F in windows), in the correct box, type A* then enter.
edit: opps not entirely true. It will find words that begin with A. So it will find Anthony Smith, and Frank's Auto.
To follow up on Steve's suggestion, do you have multiple words in the same field of different records or just single word entries?
Thank you for your response.
I am trying to group the records by first word ONLY in the field beginning with the letter "A". The records have multiple words in the same field.
OK, we're still not clear..
Are you wanting to sort (your use of the word 'group' implies a sort rather than a find) your records alphabetically, using the first word of the contents of your field - let's call it Name ?
Or are you wanting to find all records that have the first word beginning with 'A' in field Name ?
Or are you wanting to find all records that have any word beginning with 'A' in field Name ?
Sorry for the lack of clarity but thank you for helping to clarify.
Yes - Or are you wanting to find all records that have the first word beginning with 'A' in field Name
but not using the sort feature because I want to omit the rest of the records out the find results
OK, then you'll need a script, something like:
Show All Records
Go To Record [First]
If [Left (LeftWords ( Yourtable::Yourfield ; 1 ) 1 ) =/(notequalsymbol) "A"]
Go To Record [Next; Exit after last]
this will need finessing if, for example, the first 'word' is a space or a carriage return, you may want to setup a further test for those possibilities
and I'm sure that Phil will have a far more elegant way of doing it!
can't you make use of the left function ?
have a second field called first_letter e.g:-
then a script similar to below:-
show all records
set error capture [on]
enter find mode
set field [first_letter ="a"]
set error capture[off]
symbister thank you, appreciate your suggestion, would too troublesome for you explain the IF statement?
if [Left (LeftWords ( Yourtable::Yourfield ; 1 ) 1 ) =/(notequalsymbol) "A"]
Kaps suggestion will be much faster/simpler
Thank you everyone for your suggestion.
2 of 2 people found this helpful
I had forgotten a much simpler method for this:
To find all records where the first letter of the first word starts with "E":
Enter find mode and specify: