How to find any of a set of characters in a string

Similar Threads:

1.Find number of characters in string

2.Finding strings of the character ^

Try ^^{1,} (see Word 2002 Help topic "Codes for items you want to find and
replace").

"Greg" < XXXX@XXXXX.COM > wrote in message
news: XXXX@XXXXX.COM ...
> I am trying to find strings of 1 or more of the character ^.  in the
> Find what field.  Find ^ will find single instances but I just noticed
> that Word generates an error if you use ^{1,}.  Does anyone know how to
> find strings of 1 or more of this character?
>

3.Find String, Copy/Paste Next 255+ Characters to New .doc

Does anyone know of a way to search for a certain string, such as 
dditionaland then copy/paste this into a new document, along with the 
following 255 characters?  Is 255 the limit?  I found the code below on this 
DG: 

Sub RTM4()
Dim oDoc As Document
Dim oSrcRg As Range, oDestRg As Range

Set oSrcRg = ActiveDocument.Range
Set oDoc = Documents.Add
Set oDestRg = oDoc.Range
oDestRg.Collapse wdCollapseEnd

With oSrcRg.Find
.ClearFormatting
.Text = "Additional ?{255}"
.Forward = True
.Wrap = wdFindStop
.Format = False
.MatchCase = False
.MatchWholeWord = False
.MatchAllWordForms = False
.MatchSoundsLike = False
.MatchWildcards = True

Do While .Execute
oDestRg.FormattedText = oSrcRg.FormattedText
oDestRg.Collapse wdCollapseEnd
oDestRg.InsertParagraph
oDestRg.Collapse wdCollapseEnd
Loop
End With

Set oDestRg = oDoc.Range
oDestRg.ConvertToTable Separator:=wdSeparateByTabs, _
NumColumns:=3, NumRows:=100, _
AutoFitBehavior:=wdAutoFitFixed
With oDoc.Tables(1)
.Style = "Table Grid"
.ApplyStyleHeadingRows = True
.ApplyStyleLastRow = True
.ApplyStyleFirstColumn = True
.ApplyStyleLastColumn = True
End With

oDoc.Activate

Set oSrcRg = Nothing
Set oDestRg = Nothing
Set oDoc = Nothing
End Sub


It works great.  Sometimes the string, such as dditionalis in a table, 
and the code seems to struggle with the tables sometimes.  For instance, if I 
have the word dditionalin one table, I'd like to find 255 characters, or 
more, up to 500 characters, in an adjacent table, just to the right on this 
table.  Any suggestions?

Regards,
Ryan

-- 
RyGuy

4.Finding Character in String

I want to return the name of the drawing file (DWG) from the end of a string.
The string will be of varying lengths... as well as the drawing file name
itself.

I could do it the long way by getting the length of the string, and
subtracting one character at a time until I hit the  '\' character... then
I'll know how much to subtract to get my file name.

An example of the string is:
"P:\Projects\2004\10-02-230 (ProjectName\600 Drawings\E101.dwg"

But is there an easier (and faster) way to search for the last '\' character
in my string?  (keep in mind that the number of '\' in each string will also
vary).

Thanks in advance!

Regards,

Bruce

5.Finding a Character in a String Using VBA

Hi,

I am trying to return an integer for the number of characters from the left 
of a string that the character "/" is located.

I need to do this using VBA as I am trying to trim the value of a cell.

Can anyone help?

BVass

6. Finding a particular character in a string using VBA

7. Using Excel VBA - Finding Characters in Strings

8. Function to find certain character in String