Need Help With Wildcaed Search

[JBNewsGroup]

Hi,

I have a table with alphabetic entries in it. I want to search the table
for all entries beginning with a selected letter. I need to add a NOT to
the search but I haven't been able to construct a string for the NOT. As an
Example:

Table
...
Argentina
Argentina - Buenos Aires
...

So far I have <A{1} which seems to pick all the "A" entries. However, what
do I add to the string so that the word "Aires" is NOT selected.

Any help or suggestions would be appreciated.

Jerry Bodoff

 

[Graham Mayor]

Jezebel has quoted the required parameter, but for more info. on wildcards,
see http://www.gmayor.com/replace_using_wildcards.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[JBNewsGroup]

Hi Jezebel and Graham,

Thanks for the response. I am still having a problem. What I am trying to
do is search the table for all entries beginning with the letter "A" but I
do not want entries where the "A" has a preceding space.

For instance; I want to find "Argentina" and "Argentina - Buenos Aires" but
I do not want the "Aires" of "Argentina - Buenos Aires."

I tried <A*>[!( <A*>] (space before the < in the not expression). This is
definitely wrong.

Is this even possible or do I do I have to access each table entry and look
at the first character?

Jerry Bodoff

 

[Helmut Weber]

Hi Jerry,

I wonder, whether all criteria you need can be put in a wildcard
search. It seems, you want to find
cells or paragraphs in cells or lines in cells,
which start with e.g. "A".
As I don't think there is a start-of-cell mark, you might have to search
for the pattern you have specified and check if found,
whether "A" is at the beginning of a cell (1)
or at the beginning of a paragraph ¶ in a multiparagraph cell (2)
or at the beginning of a line in a multiline cell (3), etc...

What kind of structure do the cells have?

Greetings from Bavaria, Germany
Helmut Weber, MVP
"red.sys" & chr(64) & "t-online.de"
Word 2002, Windows 2000

 

[JBNewsGroup]

Hi Helmut,

The cell structure is a table cell with only one line of text. I have been
playing around with the wildcards and I am beginning to come to the same
conclusion that you have. I am pretty well resigned to accessing each cell
and checking the first text character. I was hoping to use FIND.EXECUTE and
let it do it for me but "c'est la vie".

Unfortunately there is about 800 to 1000 rows and the user can select
anything from A to Z (multiple times). I use the found text to populate a
dropdown listbox. I did this because they were complaining about manually
scrolling through the entries. Putting them all in a listbox wouldn't be
much better.

Thanks for your input.

Jerry Bodoff