Need Help With Wildcaed Search

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

Jezebel
Mon May 09 02:03:45 CDT 2005

Exclamation mark is the NOT indicator -- [!A]*


"JBNewsGroup" <jerrybemail-newsgroup@yahoo.com> wrote in message
news:%23LZaCs$UFHA.2540@tk2msftngp13.phx.gbl...
> 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
Mon May 09 02:21:53 CDT 2005

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>



JBNewsGroup wrote:
> 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

JBNewsGroup
Mon May 09 02:58:48 CDT 2005

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

"Graham Mayor" <gmayor@DELETECAPSmvps.org> wrote in message
news:eTTYLfGVFHA.3244@TK2MSFTNGP15.phx.gbl...
> 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
>
> My web site www.gmayor.com
> Word MVP web site http://word.mvps.org
> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
>
>
>
> JBNewsGroup wrote:
> > 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
>
>

HelmutWeber
Mon May 09 03:09:30 CDT 2005

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
Mon May 09 07:25:46 CDT 2005

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

"Helmut Weber" <HelmutWeber@discussions.microsoft.com> wrote in message
news:F8E11318-AAAB-48A1-B39C-941843C61AE5@microsoft.com...
> 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
>
>
>