find text in a string
 

I'm looking for a suggestion or code on finding text within a string.

For example, I have a field in an Excel spreadsheet that contains a
description of a user issue.

I want to categorize these descriptions by finding a specific word in the
description, e.g., claim, lawsuit, refund, etc. These specific words are
supposed to appear at the beginning of the description but users may place
them anywhere in the description.

I thought of doing using the 'mid' and cycling through the description but
that doesn't seem to be a very efficient way to validate whether a specific
word appears in the description.

Thanks for the help...


--
JT

find text in a string
 

Assuming we are talking about VB code (since you posted in a programming
newsgroup and also used the keyword "Mid")... you can use the InStr function
which returns the position within a larger text string where the text you
are searching for is located. Since you have multiple words to search for,
then you will need to loop through your keywords as you loop through your
cells.

--
Rick (MVP - Excel)


"JT" wrote in message
...
I'm looking for a suggestion or code on finding text within a string.

For example, I have a field in an Excel spreadsheet that contains a
description of a user issue.

I want to categorize these descriptions by finding a specific word in the
description, e.g., claim, lawsuit, refund, etc. These specific words are
supposed to appear at the beginning of the description but users may place
them anywhere in the description.

I thought of doing using the 'mid' and cycling through the description but
that doesn't seem to be a very efficient way to validate whether a
specific
word appears in the description.

Thanks for the help...


--
JT

find text in a string
 

Say we are searching for "happiness". Try this:

Sub FindIt()
Dim s As String
s = "happiness"
For Each r In ActiveSheet.UsedRange
v = r.Value
l = Len(v)
v2 = Application.WorksheetFunction.Substitute(v, s, "")
l2 = Len(v2)
addy = r.Address
If l1 < l2 Then
MsgBox "You can find happiness in cell " & addy
End If
Next

End Sub

--
Gary''s Student - gsnu201001


"JT" wrote:

I'm looking for a suggestion or code on finding text within a string.

For example, I have a field in an Excel spreadsheet that contains a
description of a user issue.

I want to categorize these descriptions by finding a specific word in the
description, e.g., claim, lawsuit, refund, etc. These specific words are
supposed to appear at the beginning of the description but users may place
them anywhere in the description.

I thought of doing using the 'mid' and cycling through the description but
that doesn't seem to be a very efficient way to validate whether a specific
word appears in the description.

Thanks for the help...


--
JT

find text in a string
 

InStr function???

--
Rick (MVP - Excel)


"Gary''s Student" wrote in message
...
Say we are searching for "happiness". Try this:

Sub FindIt()
Dim s As String
s = "happiness"
For Each r In ActiveSheet.UsedRange
v = r.Value
l = Len(v)
v2 = Application.WorksheetFunction.Substitute(v, s, "")
l2 = Len(v2)
addy = r.Address
If l1 < l2 Then
MsgBox "You can find happiness in cell " & addy
End If
Next

End Sub

--
Gary''s Student - gsnu201001


"JT" wrote:

I'm looking for a suggestion or code on finding text within a string.

For example, I have a field in an Excel spreadsheet that contains a
description of a user issue.

I want to categorize these descriptions by finding a specific word in the
description, e.g., claim, lawsuit, refund, etc. These specific words are
supposed to appear at the beginning of the description but users may
place
them anywhere in the description.

I thought of doing using the 'mid' and cycling through the description
but
that doesn't seem to be a very efficient way to validate whether a
specific
word appears in the description.

Thanks for the help...


--
JT